commits

Table actions

3,312 rows sorted by sha descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer, author_date (date)

sha ▲ message author_date committer_date raw_author raw_committer repo author committer
ffff3a4c5398a9f40b61d59736f386444da19289 Easier way to run Prettier locally (#1203) Thanks, Ben Pickles - refs #1167 2021-01-25T01:41:46Z 2021-01-25T01:41:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fffd69ec031b83f46680f192ba57a27f0d1f0b8a Allow EXPLAIN WITH... - closes #583 2019-10-06T17:23:58Z 2019-10-06T17:23:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fff89772b4404995400e33fe1d269050717ff4cf Release 0.3.2 Refs #13 2021-08-26T19:01:49Z 2021-08-26T19:01:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 evernote-to-sqlite 303218369 simonw 9599 simonw 9599
ffca55dfd7cc9b53522c2e5a2fa1ff67c9beadf2 Show link to /stable/ on /latest/ pages, refs #1608 2022-01-20T22:40:44Z 2022-01-20T22:40:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ffc9f09a935fdaec4236c3e5a5c252ec3aad65ef Re-arranged documentation index page 2019-01-25T05:23:24Z 2019-01-25T05:23:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ffb54427d3c5944ea4ed83d138d3917309cc5242 insert now replaces square braces in column name with underscore, closes #341 2021-11-15T02:56:35Z 2021-11-15T02:56:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ffae2f0ecde1ca92e78d097665df820d3b7861e6 Better documentation of --host, closes #574 2019-11-01T21:57:49Z 2019-11-01T21:57:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ffa77f62b46e1ddf2f848f5da10a1e958323a084 Removed dependency on sanic-jinja2 I wasn't using any of the functionality it adds on top of raw Jinja2. Refs #12 and #153 2017-11-30T15:51:40Z 2017-11-30T15:51:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ff9ccfb0310501a3b4b4ca24d73246a8eb3e7914 Fixed typo in release notes 2021-10-14T19:23:43Z 2021-10-14T19:23:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ff55f97f1c9ba3203a25eb2cafe21e712c010d86 Removed unneccessary test file I moved this test into test_import.py in the previous commit. 2019-10-16T18:58:17Z 2019-10-16T18:58:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
ff45ed0ce5e1f151f24f089c6b78ab7f7a5cd0dc Updated --help output for latest Click, closes #1354 2021-06-01T16:16:58Z 2021-06-01T16:16:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ff2fb573cd8773206a6df83229620928056e2ee2 datasette publish --name=now-accepts-name Fixes #72 2017-11-13T02:12:21Z 2017-11-13T02:12:21Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
ff2ab9dc7d82f70daae10f5b0cde87d74704f910 Views now show their SQL, are handled a bit better Refs #66 2017-11-12T20:31:46Z 2017-11-12T20:32:25Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
ff29dd55fafd7c3d27bd30f40945847aa4278309 ?_trace=1 now depends on trace_debug setting, closes #1359 2021-06-05T20:15:58Z 2021-06-05T20:18:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ff253f5242e4b0b5d85d29d38b8461feb5ea997a Replace all uses of runner.isolated_filesystem, refs #1406 2021-07-31T18:49:08Z 2021-07-31T18:49:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ff2348e71af6705dfa3220d823ce0285e95b127f Added failing tests 2019-07-31T06:16:46Z 2019-07-31T06:16:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ff17970ed4988a80b699d417bbeec07d63400e24 Release 0.58a1 Refs #1365, #1377 2021-06-24T16:24:59Z 2021-06-24T16:24:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ff0dd4da38d48c2fa9250ecf336002c9ed724e36 repr() method for Request, refs #1519 2021-11-19T20:29:37Z 2021-11-19T20:29:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fefb0db8ae15199d0204af859ba1edc6ae98f84b Unit test for 02870e57, closes #291 2018-05-28T20:41:53Z 2018-05-28T20:41:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fef96163d92e39a804824ec98d6053e888be76a2 Minor markup cleanup 2019-07-09T11:55:04Z 2019-07-09T11:55:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
fee5f4bdbba4b40551a473a88c6b7ae1ca459962 Fixed link to Pocket 2019-10-07T05:36:56Z 2019-10-07T05:36:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f pocket-to-sqlite 213286752 simonw 9599 web-flow 19864447
fec750435d405ac06cb61a5ddeda7317ef24843a Support anonymous: true in actor_matches_allow, refs #825 2020-06-09T14:01:23Z 2020-06-09T14:01:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fec6cd55cab7ee91046ca4ee278b90cd045a32c2 Contributing documentation, closes #292 2021-06-25T17:53:46Z 2021-06-25T17:53:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
feb01c1ddd2ba0a3c01518b6856520470d649bae Fixed duplicated example 2022-01-30T15:22:39Z 2022-01-30T15:22:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
fea8c9bcc509bcae75e99ae8870f520103b9aa58 Improved SpatiaLite example, closes #401 2022-02-06T02:03:21Z 2022-02-06T02:03:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fe86d853089f324f92daa950cc56f4052bf78f98 datasette serve --create option, closes #1135 2020-12-09T19:45:45Z 2020-12-09T19:45:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fe856bf313e269edec46d304fd09348f37282f1b Release 0.5 2020-03-28T01:50:51Z 2020-03-28T01:50:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
fe687fd0207c4c56c4778d3e92e3505fc4b18172 Fixed a whole bunch of broken base_url links Refs #1519, #838 2021-11-20T00:52:33Z 2021-11-20T00:53:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fe5e813f068abd2ee63994b2baf530c7abe34de1 Styled facets with different bullets 2020-10-27T18:57:34Z 2020-10-27T19:39:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fe5b6ea95a973534fe8a44907c0ea2449aae7602 Hide 'view and edit SQL' if config.allow_sql turned off 2018-08-06T03:17:17Z 2018-08-06T03:17:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fe279ab7b4ae99dab295d5cf4d39ad06d782997e v0.8 - added PyPI metadata, ready to ship 2017-11-13T21:17:34Z 2017-11-13T21:17:34Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
fe1562e8a69872b27c1043c4b117d07623f16274 Structure of most_common and least_common columns 2021-06-16T16:36:32Z 2021-06-16T16:36:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
fe0bccb3654e2e6ba46820e733ce96c0bd020723 Facet display, refs #3 2020-09-03T18:42:44Z 2020-09-03T18:44:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
fdfbbbb9ee0d02fd4d43dfc42382252fa2287d6d Default 'expand labels' to checked in CSV advanced export 2018-06-20T16:15:33Z 2018-06-20T16:15:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fdce6f29e19c3c6b477b72f86e187abee9627b92 Reconfigure ReadTheDocs, refs #1176 2022-02-07T06:38:27Z 2022-02-07T06:38:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fda4dad23a0494890267fbe8baf179e2b56ee914 Test against Python 3.10 (#330) * Test against Python 3.10 * Added 3.10 to classifiers * Test on Python 3.10 before publish 2021-10-13T22:25:05Z 2021-10-13T22:25:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
fd9867d145c11a6be6c4049e0383832d0e856f4b sqlite-utils insert --detect-types option, refs #282 2021-06-19T04:18:58Z 2021-06-19T04:18:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fd5829b27dce669fe1704e07536f339f20472eda First CLI command: sqlite-utils table_names test.db 2019-01-25T03:30:47Z 2019-01-25T03:30:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fd3a33989aaf2533c4928de3b251c24614003f1e Implemented new database view and template Closes #53 - see comments there for screenshots. 2017-11-12T01:50:21Z 2017-11-12T01:50:21Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
fd368d3b2c5a5d9c3e10a21638f6ea9a71471b52 New _nocount=1 option, used to speed up CSVs - closes #1353 2021-06-01T16:12:32Z 2021-06-01T16:12:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fd2a74dc09e585802ecec76c1a20a9c5a839a36a Updated publish_subcommand example 2020-03-19T00:47:53Z 2020-03-19T00:47:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fd1b6eb82d092c60edcc38fcb363290dc6c6dfff Help text for enable-fts and populate-fts 2019-02-08T05:25:26Z 2019-02-08T05:25:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fd1a989e09ccfd7b19ac5044ed4679c2134c1294 Fixed regex 2019-09-03T20:42:38Z 2019-09-03T20:42:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
fd196a7f65c3c4721904042ff97ee85c839f6bf3 Fixed #29: import command fails on empty files By bumping sqlite-utils dependency to get this fix: https://github.com/simonw/sqlite-utils/issues/52 2019-11-09T19:35:09Z 2019-11-09T19:35:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
fd137da7f83c117b18e189707a1039e319dd5c91 Suggest column facet only if at least one count > 1 Fixes #638 2019-11-22T00:56:55Z 2019-11-22T00:56:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fd0b00330fa9bc920185678b9dac8b97956138c4 Don't show cog on Link column, refs #981 Also show ascending option before descending option 2020-09-30T22:31:17Z 2020-09-30T22:31:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fd00ca2e91ec42d09b4225606f9021979d6f33f4 Release 0.1 Refs #4 2020-09-01T06:10:44Z 2020-09-01T06:10:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
fcfcae21e67cc15090942b1d2a47b5f016279337 extra_template_vars plugin hook (#542) * extra_template_vars plugin hook Closes #541 * Workaround for cwd bug Based on https://github.com/pytest-dev/pytest/issues/1235#issuecomment-175295691 2019-07-06T00:05:56Z 2019-07-06T00:05:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fcf9923391438ab543876d66330cf8407f0f7d10 Extract place names and make view facetable by place, refs #1 2020-05-04T00:23:01Z 2020-05-04T00:23:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-photos 256834907 simonw 9599 simonw 9599
fcf43589eb6a1f1d0432772a639fd35711c48e0c Link to homepage in nav on show-json page 2020-10-30T15:53:44Z 2020-10-30T15:54:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fced2a9b67d2cbdf9817f1eb75f7c28e413c963b --since and --since_id options for user-timeline, closes #19 Refs #20 Also added some initial rate limit error handling code. 2019-10-16T19:12:41Z 2019-10-16T19:12:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
fce9738cf6b6ad6533437f96cdfb40167d909c65 Sleep longer, hopefully help workaround #51 2020-11-30T00:46:48Z 2020-11-30T00:46:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
fcc7cd6379ab62b5c2440d26935659a797133030 rST formatting 2020-06-11T16:04:32Z 2020-06-11T16:05:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fcc38b9ff2e4dbb680a4429002767f6df855674b Moved fixtures into conftest.py 2018-08-13T00:24:11Z 2018-08-13T00:25:39Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
fca723ab2ab7c162a5e62d85d28d73f73cf40bcb Fixed order of master and main in release notes 2020-08-09T19:30:55Z 2020-08-09T19:30:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fc9b1cc1368cff455478c10f7b400bf5afc7d8e3 New truncate_cells_html config for truncating cells, closes #330 2018-07-10T16:20:41Z 2018-07-10T16:20:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fc972350a8a0276d87a6a83efbbdfab0edd060d4 Docker image should now allow apt-get install, closes #1320 2021-05-24T18:07:03Z 2021-05-24T18:07:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fc7c04fe0b2f9daf8875ccaa9625ec80d8eeafe2 Added 'datasette publish now --force' option This calls now with --force - which is useful as it means you get a fresh copy of datasette even if now has already cached that docker layer. 2017-11-14T01:48:03Z 2017-11-14T01:48:03Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
fc4846850fffd54561bc125332dfe97bb41ff42e New way of deriving named parameters using explain, refs #1421 2021-08-09T03:21:13Z 2021-08-09T03:21:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fc47dacbbd4c4d245d7144e4cc014d3303f84b9a Add `__version_info__` derived from `__version__` This might be tuple of more than two values (major and minor version) if commits have been made after a release. 2018-05-22T17:18:00Z 2018-05-22T19:35:21Z Robert Gieseke 106fe7fbf8b80a01038e265a137b3b703422db48 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 rgieseke 198537 simonw 9599
fc38868bd4c97acfc65b1aefbff80dfdea5e0d54 Refactored tests into new test_rows.py, refs #76 2020-04-16T01:04:51Z 2020-04-16T01:04:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fc3660cfad7668dbce6ead12766e048fc1f78b11 Streaming mode for downloading all rows as a CSV (#315) * table.csv?_stream=1 to download all rows - refs #266 This option causes Datasette to serve ALL rows in the table, by internally following the _next= pagination links and serving everything out as a stream. Also added new config option, allow_csv_stream, which can be used to disable this feature. * New config option max_csv_mb limiting size of CSV export 2018-06-18T03:21:02Z 2018-06-18T03:21:02Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fc24edc153d76bcec917bb23d532981d9862e696 Added project_urls, closes #764 2020-05-11T18:28:53Z 2020-05-11T18:28:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fbf446965b398a0a6c3e6bce72c0b9b0112498ab Refactoring: renamed "name" variable to "database" 2018-08-28T10:17:13Z 2018-08-28T10:25:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fbeb61e49c940ee96d1423c76300ba3ce2cadf80 Documentation for table.pks, closes #116 2020-06-23T21:03:13Z 2020-06-23T21:03:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
fba8ff6e76253af2b03749ed8dd6e28985a7fb8f "$env": "X" mechanism now works with nested lists, closes #837 2020-06-12T00:21:48Z 2020-06-12T00:21:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fb9d61754a9088a4efafce490db01e2999dea2d2 Better type signature for hash_id, closes #341 2021-11-15T02:19:28Z 2021-11-15T02:19:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fb988ace7c7e2bee5ac142a0eab22431d0675a77 Release 0.17 to fix issues with PyPI See https://twitter.com/simonw/status/984862976447414272 2018-04-13T19:04:33Z 2018-04-13T19:04:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fb7ee8e0ad59a15083234a48e935525f6e7257dd Changelog for 0.29 release 2019-07-08T03:14:27Z 2019-07-08T03:14:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fb505de11c882fa7f2522160509172561b5b8270 Back-ported format strings for compatibility with Py 3.5 Also fixed a encoding error where Heroku --json return needs to be treated as UTF8 2017-11-22T17:42:29Z 2017-11-22T17:42:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fb2698086d766e0333a55bb73435e7283feeb438 Release 0.8 2019-10-11T06:45:21Z 2019-10-11T06:45:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
fb1a3a4b9fbe6bee80e93d86c2a10dd248636ab4 Release 0.22 Refs #58 2021-09-21T17:39:08Z 2021-09-21T17:39:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
faf33515b2e6ef8b891e7c9693c66aba2a77dc54 Sometimes sort tables by number of relationships, closes #460 2019-05-16T03:23:33Z 2019-05-16T03:23:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
faefa30fff03a9e88fc60e646ea6e7be97646dc1 Handle blank tweet[source], closes #44 2020-04-17T19:29:58Z 2020-04-17T19:29:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
faea5093b865031f650da7da6539430f732f511a Column headings now black in mobile view, closes #729 2020-05-15T18:16:47Z 2020-05-15T18:16:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fae3983c51f4a3aca8335f3e01ff85ef27076fbf Drop support for Python 3.6, closes #1577 Refs #1606 2022-01-20T04:31:22Z 2022-01-20T04:31:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fad14ab9438869d38003254f3fc1444af21a2cdb Release 1.4 2019-06-30T23:51:17Z 2019-06-30T23:51:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fac8e9381500fc02cec99281122ee8e0c72fabe1 request.url_vars property, closes #822 2020-06-09T03:40:00Z 2020-06-09T03:40:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
faa76390a02cf35e507ad5381d388295565e9a89 Fixed bug introduced in e1efa9b7, refs #1178 2021-01-08T00:01:01Z 2021-01-08T00:01:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fa8eb0bf1b113ab17ede9cd107b7c3bd5cde39c3 Run unit tests against both Python 3.5 and 3.6 2017-11-22T17:43:52Z 2017-11-22T17:43:52Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
fa87d16612ff671683f35ecc5f5e36af007599e4 Clearer docs for actor_matches_allow 2020-06-09T14:10:46Z 2020-06-09T14:10:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fa77a1fa3ab20c7b44887c3a8f8c17319063c5f3 Explicit auth.json, refs #13 2020-03-23T22:07:31Z 2020-03-23T22:07:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
fa5fc327adbbf70656ac533912f3fc0526a3873d Release 0.60.2 Refs #1632 2022-02-07T23:32:54Z 2022-02-07T23:34:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fa5aa9e7f9dfa92e136a87ef47b636e6a7ae76f1 Support multiple --issue and --pull-request options Refs #48 2020-11-30T00:05:28Z 2020-11-30T00:05:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
fa4de7551cbaf5e08f022d106605252d2a4332ec Binary data documentation, closes #1047 2020-10-31T21:37:58Z 2020-10-31T21:37:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fa42a56c6a0fa62529eabf2d363bd3008ce23094 Bulked out table test a bit I'm closing #50 - more tests will be added in the future, but the framework is neatly in place for them now. 2017-11-11T22:22:47Z 2017-11-11T22:22:47Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
fa35cd9afbff17e5639ee07e8d78c6cbb81ea4e5 Loosen requirement versions 2019-01-25T03:06:30Z 2019-01-25T03:06:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fa27e44fe09f57dcb87157be97f15b6add7f14ad datasette.sign() and datasette.unsign() methods, refs #785 2020-05-31T22:42:08Z 2020-06-01T01:16:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fa0c3777b876c29df8f2f48901533bce24de9aec script type=module support, closes #1186 2021-01-14T01:50:52Z 2021-01-14T01:50:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fa0217a94b9c2e042fc565a0d35e7e98bc275b7c Updated README 2020-08-18T14:53:04Z 2020-08-18T14:53:04Z README-bot f0031cc286d7f7a2dc1ac63c2100b9870639429c README-bot f0031cc286d7f7a2dc1ac63c2100b9870639429c github-to-sqlite 207052882    
f9d0ce4233b29a8a90b9d87e18aacdeefde2e022 Added datasette-haversine to plugins list 2019-11-27T14:04:32Z 2019-11-27T14:04:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
f9c6f0e247a2243cd23fe9fd08ef3f7bb3ec8ba3 Add rowid to view so facet-by-JSON-people works, refs #1 2020-05-05T00:11:19Z 2020-05-05T00:11:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-photos 256834907 simonw 9599 simonw 9599
f9c32e717f67b55e5d51bb896adc2dcec4489c2d Linked to csvs-to-sqlite 2017-12-06T15:09:56Z 2017-12-06T15:09:56Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
f9c146b893856a48afa810ebcce1714f30d0d3a2 Removed unused special_args_lists variable 2019-11-07T00:55:44Z 2019-11-07T00:55:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f99a23652910b03ac4669bbbb35a9b484451aabb Progress bar for sqlite-utils insert command, closes #173 2020-10-27T18:16:02Z 2020-10-27T18:16:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
f98e62fe5ac48cd31362b7e2001b0262fa68ef3b Fix for 500 error on /db?sql=x 2018-05-25T22:08:57Z 2018-05-25T22:08:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f96e55bce55d26c4d5b198edc536e1b8e9bbea43 Fix pytest version conflict https://travis-ci.org/simonw/datasette/jobs/305929426 pkg_resources.VersionConflict: (pytest 3.2.1 (/home/travis/virtualenv/python3.5.3/lib/python3.5/site-packages), Requirement.parse('pytest==3.2.3')) 2017-11-22T20:15:29Z 2017-11-22T20:17:51Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f95762cc25cbf75909fee8ad041cc903d5f421b0 Better heading 2019-09-03T22:42:41Z 2019-09-03T22:42:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
f9473ace14878212c1fa968b7bd2f51e4f064dba disable-fts and .disable_fts(), closes #88 2020-02-27T04:40:35Z 2020-02-27T04:40:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f92d823766872a6fd7e76c5249a6b2de1ab0f447 ensure immutable databses when starting in configuration directory mode with (#1229) * check if immutables is empty list of None * update docs on how to create the inspect-data.json 2021-03-29T00:17:31Z 2021-03-29T00:17:31Z Campbell Allen 50f8a5e45b42f54cd7dfc01c8c34b8736a785e77 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 camallen 295329 web-flow 19864447

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]);