commits

2,233 rows

View and edit SQL

Suggested facets: raw_committer, 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

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]);
Powered by Datasette · Query took 163.603ms · About: simonw/datasette-graphql