2,357 rows

View and edit SQL

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0b702f3679a2ffd4e3efb5c34b9fe30221172ccb Fixed weird edge-case with foreign key detection It turns out it is possible for a SQLite table to define a foreign key relationship to a table that does not actually exist We should still be able to handle these databases. 2017-11-17T16:18:26Z 2017-11-17T16:18:26Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0b84d52ab87d960d4b5e188052540518db2ea569 Release 0.10 2019-10-15T18:53:53Z 2019-10-15T18:53:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
0b8a952cd5709ac27494b1694ca95188c89442ce Release 0.20.1 Refs #41 2020-04-01T04:31:23Z 2020-04-01T04:31:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
0b8c1b0a6da9cb8ac0d28cc90dd783de87554036 Test for sql_time_limit_ms + sqlite_functions mechanism Added a unit test for the sql_time_limit_ms option. To test this, I needed to add a custom SQLite sleep() function. I've added a simple mechanism to the Datasette class for registering custom functions. I also had to modify the sqlite_timelimit() function. It makes use of a magic value, N, which is the number of SQLite virtual machine instructions that should execute in between calls to my termination decision function. The value of N was not finely grained enough for my test to work - so I've added logic that says that if the time limit is less than 50ms, N is set to 1. This got the tests working. Refs #95 2017-11-15T02:41:03Z 2017-11-15T02:43:34Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0b8e5981a37c0da75ce4f4e6b6b5275681e2e0c5 Typo fix 2018-05-20T21:30:48Z 2018-05-20T21:30:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0bb483ca5bee61c9f7d148b5755d2eed56001aca /-/static-plugins/PLUGIN_NAME/ now serves static/ from plugins Refs #214 2018-04-18T02:32:48Z 2018-04-18T02:32:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0bc49e938e1e3444df734f9178a9a317f68f9716 'sqlite-utils add-column name type' command, closes #15 2019-02-24T20:04:33Z 2019-02-24T20:04:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0bd41d4cb0a42d7d2baf8b49675418d1482ae39b Do not show default plugins on /-/plugins 2018-08-28T07:36:22Z 2018-08-28T07:36:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0bf51d404929f5a019fdcd96c9fc5b8f780a3347 Apply autoescape to display templates You can still opt out of it using |safe 2020-09-18T22:20:41Z 2020-09-18T22:20:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
0c064c5fe220b7b3d8dcf85b02b4e60452c47232 More things you can do with plugins 2020-06-05T03:10:40Z 2020-06-05T03:10:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0c1b8b7f96be874bb63801f69323960f277aa49a Use assertion to enforce <=999 columns 2019-07-28T11:41:57Z 2019-07-28T11:41:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c22fa8f09e9fce7434d5fc83bcfb73c25795205 Cleaned up view_definition/table_definition code in table view Also moved those out of standard JSON into just the HTML template context 2018-06-16T17:33:17Z 2018-06-16T17:33:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0c2451e0690c5f4e6463a2f339b0a280e30ed806 Release 2.3 2020-02-08T23:56:16Z 2020-02-08T23:56:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c27f10f9d2124f0f534c25612b58be20441c9d8 Updated plugin examples to include datasette-psutil 2020-06-13T23:41:26Z 2020-06-13T23:41:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0c36feb6ca5c3ffb9a6df4c8ea4bb732fcab74f4 .enable_fts() now works with columns with spaces in them, closes #90 2020-03-02T06:10:43Z 2020-03-02T06:10:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c6745b70f95663f8ddf4309c578bd568eca75ec Whitespace fix 2019-02-24T18:42:27Z 2019-02-24T18:42:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c756b8cd948bd69b7342c0d0e93bad4ff4e97b2 Added datasette-bplist plugin to ecosystem 2019-06-09T02:11:59Z 2019-06-09T02:11:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0ca5585fcb834122193e8e7186f926217b23cb8a Clarify why you would want transform_sql() 2020-09-23T20:16:01Z 2020-09-23T20:16:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0cb29498c796267c5e4a5545ede8058b7ca03a94 Fixed bug with python tests/fixtures.py https://github.com/simonw/datasette/runs/1333357885?check_suite_focus=true 2020-10-30T17:54:47Z 2020-10-30T17:54:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0cdceb9244a21fbd1e70a6ca0a76b2ed2ce4dd3f github-to-sqlite commits command, refs #17 2020-03-10T21:55:36Z 2020-03-10T21:55:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0cdf111ae68d46eb2eb51d85e20e1447a42cbdcc Move pip/pipx to top of installation instructions Less intimidating than Docker, hopefully. 2020-05-04T19:31:13Z 2020-05-04T19:31:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0cfd7ce59d9018eb07af8f9e20f7d04308c9d01d Allow WITH query (previously we required SELECT at start) Fixes #161 2017-12-04T04:51:31Z 2017-12-04T04:51:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0d1763fb2fdabcdde321646721703df1dfcb8597 More datasette.urls usage, refs #1025 2020-10-20T04:24:47Z 2020-10-20T04:24:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0d3479ba320e5a5d15f029838744c5219a9e2987 Release notes for 0.13 2017-11-25T03:32:24Z 2017-11-25T03:32:24Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0d63128c40aec15a958dddf181c13e0db1c7908b Preparing v0.2, first release to PyPI 2018-07-29T00:42:41Z 2018-07-29T00:42:41Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
0d7ba1ba676828dc7c8dda78ebe7921f7986fc18 Default to _labels=on on JSON/CSV links with foreign keys, refs #266 2018-06-17T22:56:55Z 2018-06-17T22:56:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0da7f49b24e429e81317e370cb01de941f1b873e Rename RequestParameters to MultiParams, refs #799 2020-06-05T17:52:50Z 2020-06-05T17:52:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0dad111d24856ee6012850dac19929a48dc0a59f New introspection endpoint: /-/databases - closes #470 Refs #419 and #465 2019-05-16T14:49:34Z 2019-05-16T14:49:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0df7f3d1f5db162375415e42c8b14c6bd404a789 Release 0.4 Refs #3 #9 #10 #11 2020-09-03T21:02:46Z 2020-09-03T21:02:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep-beta 197431109 simonw 9599 web-flow 19864447
0e1e89c6ba3d0fbdb0823272952cf356f3016def Release 0.51a1 Refs #1056, #1039, #998, #1045, #1033, #1036, #1034, #976, #1057, #1058, #1053, #1064, #1066 2020-10-30T05:34:52Z 2020-10-30T05:35:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0e49842e227a0f1f69d48108c87d17fe0379e548 datasette/actor_auth_cookie.py coverae to 100%, refs #841 2020-06-13T18:29:14Z 2020-06-13T18:29:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0e58ae7600212c075f5b8ae4b52d2af0e1acd4f1 Release 0.50.2 Refs #1011 2020-10-10T03:53:47Z 2020-10-10T03:53:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0e5b6025c6f9823ff81aa8aae1cbff5c45e57baf Can now fetch data from Foursquare API, closes #1 Also made createdAt field the original unix timestamp and added a new created field which is the ISO formatted version. 2019-08-30T18:16:20Z 2019-08-30T18:19:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
0e5f51adfeff24a120bbdf0e5ac5669b18124400 Three more news items 2018-03-30T07:03:45Z 2018-03-30T07:03:45Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0e62744da9a429093e3409575c1f881376b0361f Correct import path for AlterError exception 2020-09-02T20:29:46Z 2020-09-02T20:29:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0e7b461eb3e925aef713206c15794ceae9259c57 Fixed typo 2019-08-04T04:13:31Z 2019-08-04T04:13:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0eda638d81280c7e585db071c35444e14b0b00f6 table.exists() now a documented method, closes #83 2020-02-08T23:56:03Z 2020-02-08T23:56:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0f1b951c5131d16f3c8559a8e4d79ed5c559e3cb Applied Black 2020-09-18T22:20:55Z 2020-09-18T22:20:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
0f2626868bd635f44f2c04d57a5e8ced1229737e Much improved column menu display logic, refs #981 * Menu links now take into account existing querystring * No longer shows facet option for primary key columns * Conditionally displays sort/sort-desc if already sorted * Does not show facet option if already faceted by this 2020-09-30T23:01:19Z 2020-09-30T23:01:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0f782dd8dfd7c53a9c20bbd2cb8734bb806d928b Additional test asserts 2018-04-16T20:22:04Z 2018-04-18T01:13:02Z Russ Garrett cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 russss 45057 simonw 9599
0f8b042b47ab4516829a2e56a2668fff0c5329e6 Release 2.11 Refs #118, #120 2020-07-08T17:28:29Z 2020-07-08T17:28:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0f8e91c68f2d2ad48efc8324b12762bf8b58facd Documentation fix 2020-02-26T07:13:39Z 2020-02-26T07:13:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0fa177269767e5e55c863382333fde627d2b7074 Allow ?sql= argument against database e.g. /database-234324?sql=select * from table limit 1 2017-10-24T02:48:56Z 2017-10-24T02:48:56Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0fc8afde0eb5ef677f4ac31601540d6168c8208d Changelog for 0.29.3 release 2019-09-03T00:40:53Z 2019-09-03T00:40:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0fe3b38290e1bb2d92746d90318d8662b57218bd Added db-to-sqlite to "Related projects" 2019-06-29T21:34:24Z 2019-06-29T21:34:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0fe96bc50fb3d7b1c7e4577db0ddf207eaeebbb9 Release 0.2 2019-09-14T21:31:17Z 2019-09-14T21:31:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
100911b9cfaa7a555065f99bd41ad12232fb273c Applied Black, refs #21 2020-09-17T22:55:27Z 2020-09-17T22:55:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
105a2c10fdb5134e7ba141e872636aee47cdcf1d Fix z-index issue with dropdown menu, closes #1052 2020-10-26T02:19:21Z 2020-10-26T02:19:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
107d0887a61d2fb3d61e9471863ad665633c321b datasette publish heroku now uses Python 3.8.6 2020-10-08T23:22:11Z 2020-10-08T23:22:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
107d47567dedd472eebec7f35bc34f5b58285ba8 Black 2019-07-04T05:56:13Z 2019-07-04T05:56:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
109c5a430d53fe38b1300e0daa20f5cef047a08e Update janus requirement from ~=0.4.0 to >=0.4,<0.6 (#734) Updates the requirements on [janus](https://github.com/aio-libs/janus) to permit the latest version. - [Release notes](https://github.com/aio-libs/janus/releases) - [Changelog](https://github.com/aio-libs/janus/blob/master/CHANGES.rst) - [Commits](https://github.com/aio-libs/janus/compare/v0.4.0...v0.5.0) Signed-off-by: dependabot-preview[bot] <support@dependabot.com> Co-authored-by: dependabot-preview[bot] <27856297+dependabot-preview[bot]@users.noreply.github.com> 2020-05-04T16:48:03Z 2020-05-04T16:48:03Z dependabot-preview[bot] 2edd38cb3801aa07f709f083eba7cbe4f16e0978 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 dependabot-preview[bot] 27856297 web-flow 19864447
10a34f995c70daa37a8a2aa02c3135a4b023a24c Removed rogue print() call 2018-04-16T15:38:09Z 2018-04-16T15:38:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10b9d85edaaf198879344aa1c498000cfb27dff8 datasette-csvs on Glitch now uses sqlite-utils It previously used csvs-to-sqlite but that had heavy dependencies. See https://support.glitch.com/t/can-you-upgrade-python-to-latest-version/7980/33 2019-11-09T02:15:13Z 2019-11-09T02:15:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
10c35bd371faaa0f3c98067c08f26334c9f5ea52 urls.static_plugins() method, closes #1033 Also documented how to package static assets and templates in plugins, closes #575 2020-10-24T20:03:40Z 2020-10-24T20:03:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10c6fbc3689311091a18ad4f8d1098e6761c35bc Applied Black 20.8b1, refs #142 2020-08-28T22:30:57Z 2020-08-28T22:30:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
10ce9ce3bcfd1ea967df8da63a4774f4afef3035 Include templates/ in MANIFEST, refs #930 2020-08-12T02:34:39Z 2020-08-12T02:34:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10e3aab4c63bc02cacd64e7aa1e5eaff2b314b3e Fixed typo with last_pk 2019-02-24T06:49:54Z 2019-02-24T06:49:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
10fb34de41aaa35681f08b5991540d65bfcf2e2e Option to auth with GITHUB_TOKEN env var, closes #33 2020-05-02T18:45:31Z 2020-05-02T18:45:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1125460497e0891e730f3e5feff2bb04a78c9163 Improved column type introspection, closes #92 2020-03-14T20:04:06Z 2020-03-14T20:04:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
113bfbe5fe833e3c90a4ba364b2173d7cffe47a8 Fixed bug with conservation_status column 2020-03-24T00:35:14Z 2020-03-24T00:35:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 inaturalist-to-sqlite 206202864 simonw 9599 simonw 9599
1143fcc20b253213925f84f3979a27c9834fbbac Implemented 'fetch' command 2019-10-07T05:07:37Z 2019-10-07T05:07:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 pocket-to-sqlite 213286752 simonw 9599 simonw 9599
11a9511d23ba79e7c8c92bc90ec29ba7f22e3eb7 Updated README to reflect new query default subcommand 2019-02-23T01:53:48Z 2019-02-23T01:53:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
11b2847252a2d6683023339873d6a31c5300409e Save followers in following m2m table, closes #1 2019-09-04T20:22:52Z 2019-09-04T20:22:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
11b352b4d52fd02a422776edebb14f12e4994d3b Fix for Python 3.5, refs #435 2019-04-21T18:20:20Z 2019-04-21T18:20:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
11eb1e026f3d84cb771f8d6e204939cbaee130cd datasette.urls.table(..., format="json"), closes #1035 Also improved tests for datasette.urls and added format= to some other methods 2020-10-31T18:16:28Z 2020-10-31T18:16:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
12046c32207f35d2260268e3ab52f313835df6e7 Fixed bad bash syntax, refs #13 2020-03-23T22:41:36Z 2020-03-23T22:41:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
120f20cd97c14b4d9102d9c309b27cc2c0e4ee17 Allow "." in database filenames, closes #302 2018-06-21T15:21:09Z 2018-06-21T15:21:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
12350e8b8a5e55f0fba14bb37ca725d751056c92 Fixed broken link to global-power-plants demo 2019-05-16T05:12:36Z 2019-05-16T05:12:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
124acf34a678f0af438dc31a2dceebf28612f249 Removed db.get_outbound_foreign_keys method It duplicated the functionality of db.foreign_keys_for_table. 2020-05-30T18:39:46Z 2020-05-30T18:39:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1259b8ac0bb25fc8af61c1948e2cc16860dca7ff Support _search_COLUMN=text searches, closes #237 2018-05-05T22:33:08Z 2018-05-05T22:33:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
125c625fbc46244a4b4025732e1526fb13c55843 .rows_where(..., order_by=) argument, closes #76 2020-04-16T03:12:55Z 2020-04-16T03:12:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
127a836054fb784dc02ea40dadb55b3741dcd603 Documented new table configuration options via .table() 2019-07-22T23:59:17Z 2019-07-22T23:59:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
129cc710285f75494bbddf8d8fa6b8c099b8763d Only show facet if it has values 2020-09-04T07:42:08Z 2020-09-04T07:42:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep-beta 197431109 simonw 9599 web-flow 19864447
12c0bc09cc4bf9addde20f3d46613de11f27c641 /-/allow-debug tool, closes #908 2020-07-24T22:54:41Z 2020-07-24T22:55:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
12cec411cae73ba7211429da12cd32c551fe17b1 Display metadata footer on custom SQL queries (#589) Closes #408 - thanks, @rixx! 2019-10-14T03:53:21Z 2019-10-14T03:53:21Z Tobias Kunze b90d9715d7c0881515e9d6aa98923ed89d445945 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 rixx 2657547 simonw 9599
12f7e1dc5624d14f644abead18bd90b420b6d97e Hashed URLs now have far-future cache expiry Since the URL now includes a hash of the database, we can return a Cache- Control: max-age=31536000 header for every response. The exception is our 302 redirects. These we now serve with a Link: header that tells any HTTP/2 server-push aware fronting proxies (such as Cloudfront) to push the target of the redirect. Closes #4 2017-10-24T02:36:44Z 2017-10-24T02:36:44Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
130dc8823ebdcc1834fc7c4a03c996b13fc1e444 Run Travis CI against Python 3.7 as well 2018-07-12T17:36:00Z 2018-07-12T17:36:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
13216cb6bd715b3068b917bdeb1f1f24d159c34c Don't push alpha/beta tagged releases to Docker Hub Refs #807 2020-06-18T20:40:33Z 2020-06-18T20:40:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
13426d1b232b1a570ac81717be351026ca36cfff --accept option for get, refs #50 2020-10-19T05:00:50Z 2020-10-19T05:00:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
13528faa817d79bc3900d3af7473300686b145d7 Release 2.6 2020-04-16T03:13:13Z 2020-04-16T03:13:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
136a70d88741e2a5892c3de437064a9d14494d66 Add column name classes to <td>s, make PK bold 2018-04-17T08:29:48Z 2018-04-18T01:13:02Z Russ Garrett cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 russss 45057 simonw 9599
13b3b51087964d5e1a8c1cdd2495e07bdbe176b8 Release 0.47.3 Refs #934, https://github.com/simonw/latest-datasette-with-all-plugins/issues/3 2020-08-15T20:56:08Z 2020-08-15T20:56:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13d1228d80c91d382a05b1a9549ed02c300ef851 /dbname/tablename/-/modify-table-schema is OK after all Refs #1053, #296 2020-11-02T20:02:50Z 2020-11-02T20:02:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
13e4f9a676da91e271a243f18f3a4ebe4f84557a Unit test for _table custom template, refs #521 2019-07-03T03:06:22Z 2019-07-03T03:23:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13ee3c222f8ee967a2f716cca11bee4ea51fea46 Moved BaseView.absolute_url() to Datasette 2019-04-13T19:16:05Z 2019-04-13T19:16:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13f8868fb5efa01c263b24f6dd91c617e6e938e1 Demo also pulls datasette and sqlite-utils 2020-04-18T14:56:47Z 2020-04-18T14:56:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
141544613f9e76ddb74eee38d6f8ee1e0e70f833 Extract out menu icon CSS, refs #981 2020-09-30T23:55:00Z 2020-09-30T23:55:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
142a550a99f3c78349a10ed79f1b513fe704a169 Facet results now have "truncated" field To indicate if there was more than 20 distinct values. Refs #255 2018-05-15T09:50:27Z 2018-05-16T15:27:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
143c3c5e2c5cf2c608742297d00cac6d499aa9ed Add dependent_repos view, closes #36 Also refs #37 2020-05-02T16:29:47Z 2020-05-02T16:29:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
147b52622d68473ba6ab184657258d8576100b05 sqlite-utils tables ... --schema option, closes #104 2020-05-01T17:09:36Z 2020-05-01T17:12:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
14982bd900f17a66acc3930ec1a2ff138716d198 Release 0.50a1 Refs #995, #993, #989 2020-10-06T20:50:54Z 2020-10-06T20:50:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
14da70525b35e1a44cd45c19101385467057f041 Don't show 'None' as label for nullable foreign key, closes #406 2019-11-02T22:29:40Z 2019-11-02T22:29:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
14f6b4d200f24940a795ddc0825319ab2891bde2 actor_matches_allow utility function, refs #800 2020-06-06T18:39:11Z 2020-06-06T18:39:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
152eb2afaf35cde5d44e50369f4cb32a72e72fdb Use pysqlite3 if available 2019-07-22T22:39:35Z 2019-07-22T22:39:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
15368c5f59066fc9c6b8ce5d0578132b1b68b75d First working version of .update(), refs #35 2019-07-14T17:03:18Z 2019-07-28T12:15:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1552ac931e4d2cf516caac3ceeab4fd24da1510a Documented custom error pages, closes #965 2020-09-14T18:47:16Z 2020-09-14T18:47:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1592fd0419f374de201926d3ba67fbf1522eed13 Started work on cli, which also meant adding setup.py I'm using click, and click recommends using a setup.py - so I've added one of those. I also refactored code into a new datasite package. It's not quite deploying to now properly at the moment though - I seem to have messed up the path handling a bit. Also snuck in a new template for the "Row" view. Refs #40 2017-10-27T07:08:24Z 2017-10-27T07:08:24Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
15973d473310240d18eca264d64f2b1446ea2bb3 Switch to GitHub Actions for CI 2020-10-12T20:29:25Z 2020-10-12T20:29:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
15e232180427e988174fdf88440c84b91d2d98d1 Extra body CSS class for canned queries, closes #727 2020-04-15T21:06:12Z 2020-04-15T21:07:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
16265f6a1a7c547e3925e0fc2d6b88754afb0435 Release notes for 0.31.1 2019-11-13T02:18:04Z 2019-11-13T02:18:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [commits] (
   [sha] TEXT PRIMARY KEY,
   [message] TEXT,
   [author_date] TEXT,
   [committer_date] TEXT,
   [raw_author] TEXT REFERENCES [raw_authors]([id]),
   [raw_committer] TEXT REFERENCES [raw_authors]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [author] INTEGER REFERENCES [users]([id]),
   [committer] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_commits_committer]
                ON [commits] ([committer]);
CREATE INDEX [idx_commits_author]
                ON [commits] ([author]);
CREATE INDEX [idx_commits_repo]
                ON [commits] ([repo]);
CREATE INDEX [idx_commits_raw_committer]
                ON [commits] ([raw_committer]);
CREATE INDEX [idx_commits_raw_author]
                ON [commits] ([raw_author]);