commits

2,233 rows

Search:

- column - sha message author_date committer_date raw_author raw_committer repo author committer

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by sha Sort by message Sort by author_date Sort by committer_date Sort by raw_author Sort by raw_committer Sort by repo Sort by author Sort by committer

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, repo, committer, author_date (date), committer_date (date)

sha ▼	message	author_date	committer_date	raw_author	raw_committer	repo	author	committer
000528192eaf891118932250141dabe7a1561ece	New 'Testing plugins' page, closes #687	2020-06-22T03:53:42Z	2020-06-22T03:53:42Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
00527e5c629d9dae56d6228891b40105ff0e34c6	Enable --cors by default in containers	2017-11-14T01:23:22Z	2017-11-14T01:23:22Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
0057c087a1d467b1770bebf3206e2cb008bc2b7f	Upgrade to sqlite-utils 2.x, closes #20	2020-03-23T19:22:46Z	2020-03-23T19:22:46Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	github-to-sqlite 207052882	simonw 9599	simonw 9599
005913518b695a2456fada7db61ba0d30488bc12	Fix for bug where tweets were not saved This is a messy fix, need to dig in more	2019-09-04T21:16:38Z	2019-09-04T21:16:38Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	twitter-to-sqlite 206156866	simonw 9599	simonw 9599
0071b5d6f5c97b9896dbcfc8f95ca0db8652a18a	Added UI for editing table filters Refs #86	2017-11-23T04:33:55Z	2017-11-23T04:33:55Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
008e2f63c217aa066027a872ee706b07bd084857	response.set_cookie(), closes #795	2020-06-09T22:19:37Z	2020-06-09T22:19:37Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0091dfe3e5a3db94af8881038d3f1b8312bb857d	More reliable tie-break ordering for facet results I was seeing a weird bug where the order of results running tests on my laptop was inconsistent, causing pytest failures even though the order of tests in Travis CI was fine. I think the fix is to explicitly state how facet ordering ties on the count should be resolved.	2020-02-13T06:36:42Z	2020-02-13T06:36:42Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
00ab95430003768067bb496b125a2be93134e73d	Added CSS class rows-and-columns to main table	2018-04-24T01:30:03Z	2018-04-24T01:31:32Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
00c5a49a87e1ef3e39bb7ec5ab61f7c17f9ecd60	Option to ignore inserts if primary key exists already Support for SQLite's INSERT OR IGNORE In the API layer it looks like this: fresh_db["test"].insert({"id": 1, "bar": 3}, ignore=True) For the CLI layer it looks like this: $ sqlite-utils insert data.db dogs dogs.json --ignore Closes #21	2019-05-29T04:15:57Z	2019-05-29T04:15:57Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
00e2473f919d921a2aa1c9264397e3e593e3907e	Added support for stickers	2019-08-30T14:45:26Z	2019-08-30T14:45:26Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	swarm-to-sqlite 205429375	simonw 9599	simonw 9599
0104dccca9d04916a9a5ba03874c92d9a9704096	Updated Travis password, refs #317	2018-06-21T15:33:14Z	2018-06-21T15:33:14Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0120c24927af364304574ab1a58e417094e01c22	extra_css_urls/extra_js_urls in metadata, refs #153 A mechanism in the metadata.json format for adding custom CSS and JS urls. Create a metadata.json file that looks like this: { "extra_css_urls": [ "https://simonwillison.net/static/css/all.bf8cd891642c.css" ], "extra_js_urls": [ "https://code.jquery.com/jquery-3.2.1.slim.min.js" ] } Then start datasette like this: datasette mydb.db --metadata=metadata.json The CSS and JavaScript files will be linked in the <head> of every page. You can also specify a SRI (subresource integrity hash) for these assets: { "extra_css_urls": [ { "url": "https://simonwillison.net/static/css/all.bf8cd891642c.css", "sri": "sha384-9qIZekWUyjCyDIf2YK1FRoKiPJq4PHt6tp/ulnuuyRBvazd0hG7pWbE99zvwSznI" } ], "extra_js_urls": [ { "url": "https://code.jquery.com/jquery-3.2.1.slim.min.js", "sri": "sha256-k2WSCIexGzOj3Euiig+TlR8gA0EmPjuc79OEeY5L45g=" } ] } Modern browsers will only execute the stylsheet or JavaScript if the SRI hash matches the content served. You can generate hashes using www.srihash.org	2017-11-29T02:38:15Z	2017-11-29T02:38:15Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
012c76901af65442e90eac4b36db43455e3c922f	_ prefix for many private methods of Datasette, refs #576	2020-05-30T14:38:46Z	2020-05-30T14:38:46Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
012fc7c5cd3e9160c9a4c19cc964253e97fb054a	Fix for FTS virtual table counting error	2018-03-21T01:26:04Z	2018-03-21T01:26:04Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
013cc8147abb78227b7232c2d14cb428613b5760	user-timeline documentation	2019-09-04T20:39:12Z	2019-09-04T20:39:12Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	twitter-to-sqlite 206156866	simonw 9599	simonw 9599
015bd2a840a008a105f731c50eee319963352c1b	Test for .table_names(fts5=True)	2019-01-25T04:23:53Z	2019-01-25T04:23:53Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
01b3de5b66742f0f661183e9e2ef66be3600e831	Unit test for binary data display, refs #442	2019-05-03T16:43:59Z	2019-05-03T16:45:06Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
01b7a6a71ca121ec91ca4cc18f46a565098441fd	List of all current Dogsheep tools	2019-10-13T02:23:10Z	2019-10-13T02:23:10Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	dogsheep.github.io 214746582	simonw 9599	web-flow 19864447
01c7784be54d14ee5b653753c38005d823fcdd09	CI is now GitHub Actions, closes #143	2020-08-28T22:41:29Z	2020-08-28T22:41:29Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
01dec730860ce4d2b6e92cb8cbca7330c252893d	GitHub Actions test badge	2020-10-12T20:30:18Z	2020-10-12T20:30:18Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	swarm-to-sqlite 205429375	simonw 9599	web-flow 19864447
01e0c3fa18cd0dd7970e208790ffd683a420c924	Fixed &nbsp; bug &nbsp; was showing for all None values in table cells, thanks to the autoescaping change introduced in 82261a638bd35c9	2017-11-16T15:29:52Z	2017-11-16T15:29:52Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
01fe5b740171bfaea3752fc5754431dac53777e3	datasette install / datasette uninstall commands, closes #925	2020-08-11T22:31:47Z	2020-08-11T22:32:06Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0209a0a344503157351e625f0629b686961763c9	table_exists() now uses async SQL, refs #420	2019-03-31T18:02:22Z	2019-03-31T18:02:22Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9	Much, much faster extract() implementation Takes my test down from ten minutes to four seconds! * Removed unnecessary update() optimization * Added column_order= to .transform() and .transform_sql() * Tests for reusing lookup table in extract() Closes #172	2020-09-24T15:43:55Z	2020-09-24T15:43:55Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0242ae340b34417248fb88cdaa7716804ced1ed9	Handle subject-date note attribute	2020-10-11T23:45:15Z	2020-10-11T23:45:15Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	evernote-to-sqlite 303218369	simonw 9599	simonw 9599
026c84db30bd0a75ecde146a80a5d142078dc299	Refactor Datasette methods to ConnectedDatabase Refs #487	2019-05-27T04:56:43Z	2019-05-27T04:56:43Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
02862be04c51e8ec6e29517d3c28b030627bb179	Default to FTS5	2018-08-13T00:21:55Z	2018-08-13T00:21:55Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
02870e573154517f129cbc85e437d5f0105d7cbe	Filter out duplicate JS/CSS URLs, refs #291 (testme)	2018-05-27T08:45:03Z	2018-05-27T08:45:03Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
028f193dd6233fa116262ab4b07b13df7dcec9be	How to use a custom domain with Cloud Run	2020-07-22T18:17:05Z	2020-07-22T18:17:05Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	datasette 107914493	simonw 9599	web-flow 19864447
02b1814fcfdc61b1b69b5955f2b60252ff10cde9	Redirects now preserve query string Fixes #28	2017-10-24T23:54:26Z	2017-10-24T23:54:26Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
02dc6298bdbfb1d63e0d2a39ff597b5fcc60e06b	permission_allowed resource can be a tuple	2020-07-21T15:22:31Z	2020-07-21T15:22:36Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
02e38b363ed2211fd32f7d97bef36512b5ebf294	Foreign keys for milestones table, refs #31	2020-04-21T18:58:21Z	2020-04-21T18:58:21Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	github-to-sqlite 207052882	simonw 9599	simonw 9599
02ee31c8b45b872fff91e2059c15a20532e2d035	New hidden: True option for table metadat, closes #239	2018-04-26T03:42:57Z	2018-04-26T03:42:57Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0331666e346c68b86de4aa19fbb37f3a408d37ca	?_search=x now works directly against fts virtual table Closes #135	2017-11-20T06:18:07Z	2017-11-20T06:18:07Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
033a1bb22c70a955d9fd1d3b4675a0e2e5c8b8cd	Removed rogue print() from test	2020-06-05T19:06:43Z	2020-06-05T19:06:43Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
033cf0bcbbcadd0256d0c43fb7b9d3053727b4fe	DatabaseView no longer uses .inspect(), closes #420	2019-05-02T01:12:58Z	2019-05-02T01:13:26Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
03418ee037057aa85204f5a3feb2066cbb6a9b3e	Release 0.47 Refs #335, #923, #925, #926, #928	2020-08-12T00:42:47Z	2020-08-12T00:42:47Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
034d498b319d37b0639203fa4fbb304715b3ae03	Support Database(memory=True) for in-memory databases	2019-07-23T00:12:54Z	2019-07-23T00:12:54Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
03572ae35573c2ea802a540624ce116f540ba1ac	Allow --load-extension to be set via environment variable I tesed this by first building and running a container using the new Dockerfile from #114: docker build . docker run -it -p 8001:8001 6c9ca7e29181 /bin/sh Then I ran this inside the container itself: apt update && apt-get install wget -y \ && wget http://www.gaia-gis.it/spatialite-2.3.1/test-2.3.sqlite.gz \ && gunzip test-2.3.sqlite.gz \ && mv test-2.3.sqlite test23.sqlite \ && datasette -h 0.0.0.0 test23.sqlite I visited this URL to confirm I got an error due to spatialite not being loaded: http://localhost:8001/test23-c88bc35?sql=select+ST_AsText%28Geometry%29+from+HighWays+limit+1 Then I checked that loading it with `--load-extension` worked correctly: datasette -h 0.0.0.0 test23.sqlite \ --load-extension=/usr/lib/x86_64-linux-gnu/mod_spatialite.so Then, finally, I tested it with the new environment variable option: SQLITE_EXTENSIONS=/usr/lib/x86_64-linux-gnu/mod_spatialite.so \ datasette -h 0.0.0.0 test23.sqlite Running it with an invalid environment variable option shows an error: $ SQLITE_EXTENSIONS=/usr/lib/x86_64-linux-gnu/blah.so datasette \ -h 0.0.0.0 test23.sqlite Usage: datasette -h [OPTIONS] [FILES]... Error: Invalid value for "--load-extension": Path "/usr/lib/x86_64-linux-gnu/blah.so" does not exist. Closes #112	2017-11-17T14:13:35Z	2017-11-17T14:13:35Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
0357774c946b7a35871715d7fc23b3f04f519af8	Renamed test_tables.db to fixtures.db in unit tests	2018-06-17T18:34:16Z	2018-06-17T18:34:16Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
03c58fb350f6b9bb941a46907da5ac6f67bf47cf	Show databases in alphabetical order on index page	2017-11-10T19:04:56Z	2017-11-10T19:04:56Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
03e3f7d6486123bf3eb852ad007d9761475f138c	Configured Travis CI	2018-07-28T13:48:53Z	2018-07-28T13:48:53Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
03ee97d2258254581bea72842518904fc1cbe60f	CLI now supports upsert/insert - closes #115	2020-06-12T17:40:53Z	2020-06-12T17:40:53Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
040fc0546f1ad602125ecdc27d9d013d830aa808	Updated tests, refs #817	2020-06-08T19:02:56Z	2020-06-08T19:02:56Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
046ca380fd93f352da6e58139b96f2e4a365f53a	Release 0.2	2020-03-27T22:23:16Z	2020-03-27T22:23:16Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	pocket-to-sqlite 213286752	simonw 9599	simonw 9599
04c1d2cc54c71d4c6e795d174c7bb52f91739627	followers/friends --sql/--attach options, closes #36	2020-03-20T23:12:30Z	2020-03-20T23:12:30Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	twitter-to-sqlite 206156866	simonw 9599	simonw 9599
04c896160a9981d37beb71529ac717a6fcf1b195	Renamed 'stream all records' to 'stream all rows', refs #266	2018-06-18T14:25:44Z	2018-06-18T14:25:44Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
04d21ccd089fcaf7a2b535d217fc541ab19aa54b	/-/versions now includes SQLite fts_versions, closes #252	2018-05-11T13:19:25Z	2018-05-11T13:19:25Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
04ec53c039feb590c7832d499a14a9caba081f11	Validate column names in more places, refs #86	2020-02-27T04:55:17Z	2020-02-27T04:55:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
05238b16328c9fed1486972dbce1b4df66a82f1b	Added tags to demo, refs #43	2020-07-18T21:52:51Z	2020-07-18T21:52:51Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	github-to-sqlite 207052882	simonw 9599	simonw 9599
05317f53411fab3c3d66b88408bc867f2e474a35	Release 0.14	2019-02-24T23:11:51Z	2019-02-24T23:11:51Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
05399058062ba6df467c8745b87ece5f6951b39f	Renamed "datasette build" command to "datasette inspect" Closes #130	2017-12-07T16:57:31Z	2017-12-07T16:57:31Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
05a85b358fb907d8fcb72f19390ee2ba5a2261a5	Don't assume -1 for error code	2019-02-24T19:50:56Z	2019-02-24T19:50:56Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
05bdf53358ec6ea81a7dce17290f3db0cd94d23d	Added missing hyphen	2018-04-20T21:15:13Z	2018-04-20T21:15:13Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	datasette 107914493	simonw 9599	web-flow 19864447
05cabaebd99b4aa388096de0a03fb52d08f6c117	Pass --token to now alias, refs #459	2019-05-11T20:35:34Z	2019-05-11T20:35:34Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
060a56735c1d3bde0a4c7674e82b5f45bef34dee	actor_from_request and permission_allowed hookspecs, refs #699	2020-05-30T20:24:00Z	2020-06-01T01:16:42Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
062303419cef9bbf72927c4ac4efdb185829c03b	Hide facet button is now a ✖ - refs #255	2018-05-16T14:37:05Z	2018-05-16T15:27:24Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
06645f2e267b16d0c193bb1d1b7ca0cb67227c43	Formatting tweak	2017-12-09T18:41:20Z	2017-12-09T18:41:20Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	datasette 107914493	simonw 9599	web-flow 19864447
06a826c3188af82f27bb6b4e09cc89b782d30bd6	:fire: Removes DS_Store (#81) * :fire: Removes .DS_Store Signed-off-by: Jeff Triplett <jeff.triplett@gmail.com> * :snowflake: Adds .DS_Store to gitignore Signed-off-by: Jeff Triplett <jeff.triplett@gmail.com>	2017-11-13T22:16:54Z	2017-11-13T22:16:54Z	Jeff Triplett 207bb2132044fa5a4fe28a579f7588c2eee6e391	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	jefftriplett 50527	simonw 9599
06dfb95a5ca5c0682ccad87b6150a2b0db66ade1	Initial working version Only supports loading checkins from a JSON file on disk: swarm-to-sqlite swarm.db -f checkins.json	2019-08-30T11:26:27Z	2019-08-30T11:26:27Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	swarm-to-sqlite 205429375	simonw 9599	simonw 9599
06fdf0fd79adb8510da5de8f6ed30a0b5b8668e1	Fully working faceted search Closes #3	2020-09-03T21:01:14Z	2020-09-03T21:01:20Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	dogsheep-beta 197431109	simonw 9599	simonw 9599
070838bfa19b177f59ef3bd8f0139266adecda90	Better test for Vary header	2020-06-06T19:26:19Z	2020-06-06T19:26:19Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
071bc2dd6350461aa1fb1a8e281ad9a79fba08ae	Typo	2020-03-21T04:29:53Z	2020-03-21T04:29:53Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	hacker-news-to-sqlite 248903544	simonw 9599	web-flow 19864447
0747dabb24b608e8524de4858ce50c60ba7e471b	table.update() method * Also now set .last_pk to lastrowid for rowid tables * table.pks introspection now returns ["rowid"] for rowid tables Closes #35	2019-07-28T15:43:50Z	2019-07-28T15:43:50Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0748a65a22302640ec7520a19aaba280b5615930	Fixed content-disposition header on DB download, closes #909	2020-07-29T21:34:22Z	2020-07-29T21:34:22Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
075d422c0a1c70259188dfbd940538c67419694a	Fixed typo	2017-11-14T05:28:02Z	2017-11-14T05:28:02Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	datasette 107914493	simonw 9599	web-flow 19864447
0784f2ef9d3ff6dd9df05f54cb51de29a6d11764	Allow specific pragma functions, closes #761	2020-05-06T17:18:31Z	2020-05-06T17:18:31Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
07a10bdb2c09c7e275a9db546c42900b1dea4e75	foreign_keys=[...] can now detect tables and keys - closes #25	2019-06-13T05:32:26Z	2019-06-13T05:32:26Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
07e208cc6d9e901b87552c1be2854c220b3f9b6d	Refactored .custom_sql() method to new QueryView class Refs #698	2020-04-03T01:12:13Z	2020-04-03T01:12:13Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
07fc2d113e462bfd8d7d56152c0d1fc55e0fdbe9	Fix for _sort_desc=sortable_with_nulls test, refs #216	2018-04-17T00:05:03Z	2018-04-17T00:05:03Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
08029a2f8f67bbcd42bea755de5fb7db12b2c275	Hyperlink to www.srihash.org	2018-05-26T19:46:24Z	2018-05-26T19:46:24Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	datasette 107914493	simonw 9599	web-flow 19864447
0807c4200f6b31c804c476eb546ead3f875a2ecc	Release notes for 0.45a1, refs #852	2020-06-18T23:40:45Z	2020-06-18T23:40:45Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
08110bc2b8801d725d65fa834d30b57e473d2241	Added example Twitter developer account application email Thanks to Jacob Kaplan-Moss: https://twitter.com/jacobian/status/1192510111719313408	2019-11-08T23:04:17Z	2019-11-08T23:04:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	twitter-to-sqlite 206156866	simonw 9599	simonw 9599
084350b0f1343d988928cae63cfedbeb6205e25e	Switched to gather_request=False for Sanic tests Gets rid of those ugly _, response = lines.	2017-11-17T14:53:37Z	2017-11-17T14:53:37Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
08b4928a75faa1f2ba1c5b9908bcf2df4975a9d4	asgi-csrf>=0.6, refs #835	2020-07-01T01:18:19Z	2020-07-01T01:18:19Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
08f4b7658fec97419eb34118a2cd5c8be805673f	Show facets that timed out using new InterruptedError If the user requests some _facet= options that do not successfully execute in the configured facet_time_limit_ms, we now show a warning message like this: These facets timed out: rowid, Title To build this I had to clean up our SQLite interrupted logic. We now raise a custom InterruptedError exception when SQLite terminates due to exceeding a time limit. In implementing this I found and fixed a logic error where invalid SQL was being generated in some cases for our faceting calculations but the resulting sqlite3.OperationalError had been incorrectly captured and treated as a timeout. Refs #255 Closes #269	2018-05-18T06:07:45Z	2018-05-18T06:11:23Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
09253817dea3c131553494f9b2eb9c03f94ae761	Fix for missing view_name bug, closes #716	2020-04-05T18:28:20Z	2020-04-05T18:28:20Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
092874202c8748d6e0d4800eaf707c0145d95ffe	Improvements to allow block logic and debug tool true and false allow block values are now supported, closes #906 Added a bunch of demo links to the documentation, refs #908	2020-07-25T00:04:06Z	2020-07-25T00:04:06Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
092e1368edc4e7f4cb337a62eabd9a6e1245006b	Fixed typo	2019-05-25T14:24:17Z	2019-05-25T14:24:17Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
09316835e609e2321dafa08d37d8f227521373f8	Implemented --tsv option, closes #41	2019-07-19T04:50:38Z	2019-07-19T04:50:38Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0934844c0b6d124163d0185fb6a41ba5a71433da	request.post_vars() no longer discards empty values	2020-06-03T13:48:39Z	2020-06-03T13:48:39Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0949f0989c932bae59ec702a002fe521ca56570c	emojis command, closes #47	2020-08-18T14:52:08Z	2020-08-18T14:52:08Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	github-to-sqlite 207052882	simonw 9599	simonw 9599
0988f2eccc2dfa26b1a55243582222f540a72838	Explicitly include tests and docs in sdist (#75) Also exclude 'tests' from runtime installation - thanks, @jayvdb	2020-01-31T00:21:26Z	2020-01-31T00:21:26Z	John Vandenberg 85de645274a2cefaeda2a43f117f5e672fd8e2f9	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	jayvdb 15092	web-flow 19864447
0991ea75cc7b265389aa8362414a305ba532d31a	Renamed _timestamp to _now, refs #842, closes #871	2020-06-28T19:45:34Z	2020-06-28T19:47:28Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
09a3479a5402df96489ed6cab6cc9fd674bf3433	New "startup" plugin hook, closes #834	2020-06-13T17:55:41Z	2020-06-13T17:55:41Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
09bf3c63225babe8e28cde880ca4399ca7dbd78b	Documentation for publish --secret, refs #787	2020-06-11T16:14:30Z	2020-06-11T16:14:30Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
09ef305c687399384fe38487c075e8669682deb4	Fixed "datasette publish now ... --alias=x" The --alias argument can now be passed more than once. Also updated our Travis configuration to use this. Fixes #459	2019-05-11T20:20:36Z	2019-05-11T20:20:36Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0a0cec3cf27861455e8cd1c4d84937825a18bb30	Release 1.12.1	2019-11-07T04:58:47Z	2019-11-07T04:58:47Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0a14a4846b29b4b60d153356ad926cbc461c45c7	Added plugin_config() method	2018-08-28T08:35:21Z	2018-08-28T08:35:21Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	datasette 107914493	simonw 9599	simonw 9599
0a2dddccd7eb6cedae128c08931f14f12d5bce70	'github-to-sqlite repos' now accepts multiple usernames	2019-11-11T05:02:33Z	2019-11-11T05:02:33Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	github-to-sqlite 207052882	simonw 9599	simonw 9599
0a8194e730f8ecdd9a5af1f6a8d5a889796d7dba	sqlite-utils optimize command, .optimize() and .detect_fts() table methods	2019-01-25T04:35:51Z	2019-01-25T04:35:51Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0aa28293adedc488eb9107dc52b5e9a124887fbd	Fix compatibility with SQLite prior to 3.16.0 pragma_index_info() and pragma_index_list() were introduced in 3.16.0 but the version of SQLite running in Travis CI is earlier than that, hence the test failures: https://travis-ci.com/simonw/sqlite-utils/jobs/137617744	2018-08-01T15:29:53Z	2018-08-01T15:29:53Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	sqlite-utils 140912432	simonw 9599	simonw 9599
0abd3abacb309a2bd5913a7a2df4e9256585b1bb	New ?_shape=objects/object/lists param for JSON API (#192) New _shape= parameter replacing old .jsono extension Now instead of this: /database/table.jsono We use the _shape parameter like this: /database/table.json?_shape=objects Also introduced a new _shape called 'object' which looks like this: /database/table.json?_shape=object Returning an object for the rows key: ... "rows": { "pk1": { ... }, "pk2": { ... } } Refs #122	2018-04-03T14:52:54Z	2018-04-03T14:52:54Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	datasette 107914493	simonw 9599	web-flow 19864447
0ac8bbce2e73c0759ec48661a7b740d2c368b2a2	Default subcommand is now serve Using click-default-group: https://github.com/click-contrib/click-default-group Also removed requirements.txt in favour of setup.py	2017-11-04T23:53:50Z	2017-11-04T23:53:50Z	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843	datasette 107914493	simonw 9599	simonw 9599
0ad3ce5e2d664c227d7045afafec46704f251a10	Use INTEGER for organization column, fixes #27	2020-04-18T00:18:45Z	2020-04-18T00:18:45Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	github-to-sqlite 207052882	simonw 9599	simonw 9599
0b0a431bff94d24866fc10d82dc91ab00287de2d	Changelog for 2.0 release	2019-12-30T06:18:44Z	2019-12-30T06:18:44Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
0b1af42ead3b3902347951180b3364ce1942da6e	Link to my blog entry	2019-02-25T03:45:38Z	2019-02-25T03:45:38Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	GitHub cd792325681cbad9f663f2879d8b69f1edbb678f	sqlite-utils 140912432	simonw 9599	web-flow 19864447
0b5edd646926d6e01e3bf9f2897d072f4302ce2d	Added basic tests using hypothesis, closes #180	2020-10-19T04:51:50Z	2020-10-19T04:51:50Z	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874	sqlite-utils 140912432	simonw 9599	simonw 9599
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

Next page

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