2,203 rows where committer = 9599 sorted by sha descending

View and edit SQL

Suggested facets: raw_author, raw_committer, repo, author, author_date (date), committer_date (date)

sha ▲ message author_date committer_date raw_author raw_committer repo author committer
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
f901a8a2ed25149e7550799b51c62e1d4a40cce8 Explicitly open file in utf-8 encoding, refs #10 Thanks, RiverZhou 2021-02-11T22:37:36Z 2021-02-11T22:37:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 evernote-to-sqlite 303218369 simonw 9599 simonw 9599
f8d3b7cfe5c1950b0749d40eb2640df50b52f651 sqlite-utils add-foreign-key books.db books author_id authors id Command for adding foreign keys to existing tables. Closes #2 2019-02-24T21:33:45Z 2019-02-24T21:33:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f8553799d38deece370f890f6c90af32f52a609b table.extract() method, refs #42 2020-09-22T22:20:18Z 2020-09-22T22:20:18Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f853d5592ec7f901a50381de22a26a9ab098f885 "python3 -m pip" is clearer (thanks @jaap3) (#368) 2019-05-03T18:18:42Z 2019-05-03T18:18:42Z Jaap Roes 93b11f15fd4dc15002baf3d9160dc6eb928bd883 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 jaap3 48517 simonw 9599
f825e2012109247fa246e2b938f8174069e574f1 Run black and update docs for #457 2019-05-09T16:47:58Z 2019-05-09T16:48:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f80ff9b07b5ecdfeca4aa81f5728812a22bfb019 min-height on .hd Now it should be the same size on the homepage as it is on pages with breadcrumbs 2019-07-07T20:16:48Z 2019-07-07T20:16:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f804690274ce1bd93cc9e173a9d3b393312666cb Support inserting UUID and memoryview, closes #128 2020-07-30T01:10:25Z 2020-07-30T01:10:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f8010ca78fed8c5fca6cde19658ec09fdd468420 Release 3.4 Refs #223 2021-02-06T01:37:27Z 2021-02-06T01:37:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f7fddc9019516c4702416fe4cdb05a07ac214b61 Fixed typo in help text, refs #925 2020-08-11T22:33:16Z 2020-08-11T22:33:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f7f31a0223d822f7186c4d20174c002cb723d0f9 Upgrade Dockerfile to SQLite 3.31.1, closes #695 2020-03-06T06:15:19Z 2020-03-06T06:15:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f7d3e76fb3d1fa5aabe339251e4a930610643822 Facets now execute ignoring ?_col and ?_nocol, fixes #1345 2021-05-31T02:31:14Z 2021-05-31T02:31:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f7af9fa164739a09d5e83bc5be64fede4b7f795b Removed obsolete import 2019-09-04T03:34:07Z 2019-09-04T03:34:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 inaturalist-to-sqlite 206202864 simonw 9599 simonw 9599
f78e956eca1f363e3a3f93c69fd9fc31bed14629 Plugin testing documentation on using pytest-httpx Closes #1198 2021-01-24T20:38:29Z 2021-01-24T20:38:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f78c4e9baaf0970ffab266ba780df7240aae9f32 Install datasette (for datasette publish) - refs #13 2020-03-23T23:33:28Z 2020-03-23T23:33:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f786033a5f0098371cb1df1ce83959b27c588115 Fixed 'datasette plugins' command, with tests - closes #802 2020-06-05T23:46:37Z 2020-06-05T23:46:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f7289174e66ae4d91d57de94bbd9d09fabf7aff4 Release 2.1 2020-01-31T00:25:20Z 2020-01-31T00:25:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f722b0a730377d28e3b4e8292da2036f32896e02 allow_sql config option to disable custom SQL, closes #284 2018-05-25T05:50:50Z 2018-05-25T05:50:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f70e35c9bbc0d5803bc0aee572b894a8b21ac41e Added table.rows_where(where, args) method 2019-07-14T18:58:40Z 2019-07-14T18:58:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f697f247468516aa4ee13b1862b59e0dba18d00f Release 0.3 2019-09-14T21:49:27Z 2019-09-14T21:49:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f65c45674d3242bfd2b80ade646cbfbc19ff5a42 Notes on upgrading CodeMirror, refs #948 2020-08-30T18:11:04Z 2020-08-30T18:11:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f643f7aee1b3d29df82b93a6560887a35b7a2f13 base64 encode bytestrings from DB in JSON Fixes #29 2017-10-24T14:58:41Z 2017-10-24T14:58:41Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f6183ff5fa715c68d13d6ae8c7b3b9f2c6ffc9f8 Renamed --limit to --config, added --help-config, closes #274 Removed the --page_size= argument to datasette serve in favour of: datasette serve --config default_page_size:50 mydb.db Added new help section: $ datasette --help-config Config options: default_page_size Default page size for the table view (default=100) max_returned_rows Maximum rows that can be returned from a table or custom query (default=1000) sql_time_limit_ms Time limit for a SQL query in milliseconds (default=1000) default_facet_size Number of values to return for requested facets (default=30) facet_time_limit_ms Time limit for calculating a requested facet (default=200) facet_suggest_time_limit_ms Time limit for calculating a suggested facet (default=50) 2018-05-20T17:01:49Z 2018-05-20T17:01:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f5f6cbe03cbf05737d848f44779372b5daa79a25 Release 0.30.1 2019-10-30T18:56:04Z 2019-10-30T18:56:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f5dbe61a4568c0915ec6be820095c2960cf0857c -o now opens to most relevant page, closes #976 2020-10-26T05:06:20Z 2020-10-26T05:06:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f5b7ceba5b3167e962808814d492e49f87454b3f favorites command now populates favorited_by table, closes #14 2019-10-14T03:30:17Z 2019-10-14T03:30:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
f59c840e7db8870afcdeba7a53bdea07bb674334 Show row count for custom SQL queries 2017-11-19T15:54:50Z 2017-11-19T15:54:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f58f7464243f75367da2ad3cab240246e6e2e618 Release 2.7 - refs #100 2020-04-18T00:04:50Z 2020-04-18T00:04:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f571b19d8a5fd3a19fdf679421fd55a8edbf5295 sqlerrors() decorator catching and returning useful errors Closes #8 2017-10-23T15:28:00Z 2017-10-23T15:28:00Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
f553a670216960043ec7e62ff35d42db78903ff0 Don't load setuptools plugins during test runs Uses pattern from https://docs.pytest.org/en/latest/example/simple.html#detect-if-running-from-within-a-pytest-run Closes #438 2019-05-02T05:09:03Z 2019-05-02T05:09:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f5418e13f2e435a42cd3611b28ec3c9ac02481da Release 0.3.1 to publish updated README to PyPI 2018-07-31T15:39:43Z 2018-07-31T15:39:43Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
f52451023025579ae9a13de4a7f00d69200184cd Fix "publish heroku" + upgrade to use Python 3.8.0 Closes #633. Closes #632. 2019-11-13T16:42:47Z 2019-11-13T16:42:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f518d8c7099a9f8826920ab9634a159036094cf7 Break records out into separate tables, closes #6 2019-07-22T03:28:43Z 2019-07-22T03:28:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 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]);