home / github

Menu
  • GraphQL API

commits

Table actions
  • GraphQL API for commits

3,284 rows

✎ View and edit SQL

This data as json, CSV (advanced)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
107d47567dedd472eebec7f35bc34f5b58285ba8 Black 2019-07-04T05:56:13Z 2019-07-04T05:56:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1091a9cbd804504efa8e1126226759e736e3ccdf Add sqlite-utils memory to the README, refs #272 2021-06-19T03:14:12Z 2021-06-19T03:14:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
109c5a430d53fe38b1300e0daa20f5cef047a08e Update janus requirement from ~=0.4.0 to >=0.4,<0.6 (#734) Updates the requirements on [janus](https://github.com/aio-libs/janus) to permit the latest version. - [Release notes](https://github.com/aio-libs/janus/releases) - [Changelog](https://github.com/aio-libs/janus/blob/master/CHANGES.rst) - [Commits](https://github.com/aio-libs/janus/compare/v0.4.0...v0.5.0) Signed-off-by: dependabot-preview[bot] <support@dependabot.com> Co-authored-by: dependabot-preview[bot] <27856297+dependabot-preview[bot]@users.noreply.github.com> 2020-05-04T16:48:03Z 2020-05-04T16:48:03Z dependabot-preview[bot] 2edd38cb3801aa07f709f083eba7cbe4f16e0978 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 dependabot-preview[bot] 27856297 web-flow 19864447
10a34f995c70daa37a8a2aa02c3135a4b023a24c Removed rogue print() call 2018-04-16T15:38:09Z 2018-04-16T15:38:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10b9d85edaaf198879344aa1c498000cfb27dff8 datasette-csvs on Glitch now uses sqlite-utils It previously used csvs-to-sqlite but that had heavy dependencies. See https://support.glitch.com/t/can-you-upgrade-python-to-latest-version/7980/33 2019-11-09T02:15:13Z 2019-11-09T02:15:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
10c35bd371faaa0f3c98067c08f26334c9f5ea52 urls.static_plugins() method, closes #1033 Also documented how to package static assets and templates in plugins, closes #575 2020-10-24T20:03:40Z 2020-10-24T20:03:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10c6fbc3689311091a18ad4f8d1098e6761c35bc Applied Black 20.8b1, refs #142 2020-08-28T22:30:57Z 2020-08-28T22:30:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
10ce9ce3bcfd1ea967df8da63a4774f4afef3035 Include templates/ in MANIFEST, refs #930 2020-08-12T02:34:39Z 2020-08-12T02:34:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10dddcc2822863f9a6dbdc5cd4b28c6c4e4e9170 Fix for since_id bug, closes #57 2021-08-20T00:01:16Z 2021-08-20T00:01:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
10e3aab4c63bc02cacd64e7aa1e5eaff2b314b3e Fixed typo with last_pk 2019-02-24T06:49:54Z 2019-02-24T06:49:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
10f4913c144c4680c0feec576c2d4080f5005b33 Release 3.9.1 Refs #271 2021-06-13T02:59:08Z 2021-06-13T02:59:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
10fb34de41aaa35681f08b5991540d65bfcf2e2e Option to auth with GITHUB_TOKEN env var, closes #33 2020-05-02T18:45:31Z 2020-05-02T18:45:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1125460497e0891e730f3e5feff2bb04a78c9163 Improved column type introspection, closes #92 2020-03-14T20:04:06Z 2020-03-14T20:04:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
113bfbe5fe833e3c90a4ba364b2173d7cffe47a8 Fixed bug with conservation_status column 2020-03-24T00:35:14Z 2020-03-24T00:35:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 inaturalist-to-sqlite 206202864 simonw 9599 simonw 9599
1143fcc20b253213925f84f3979a27c9834fbbac Implemented 'fetch' command 2019-10-07T05:07:37Z 2019-10-07T05:07:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 pocket-to-sqlite 213286752 simonw 9599 simonw 9599
1163da89163f357003007b14f458a2c28f2e0a8e Update test to handle Python 3.10 error message differenc, refs #1482 2021-10-09T00:32:52Z 2021-10-09T00:32:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
11a9511d23ba79e7c8c92bc90ec29ba7f22e3eb7 Updated README to reflect new query default subcommand 2019-02-23T01:53:48Z 2019-02-23T01:53:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
11b2847252a2d6683023339873d6a31c5300409e Save followers in following m2m table, closes #1 2019-09-04T20:22:52Z 2019-09-04T20:22:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
11b352b4d52fd02a422776edebb14f12e4994d3b Fix for Python 3.5, refs #435 2019-04-21T18:20:20Z 2019-04-21T18:20:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
11eb1e026f3d84cb771f8d6e204939cbaee130cd datasette.urls.table(..., format="json"), closes #1035 Also improved tests for datasette.urls and added format= to some other methods 2020-10-31T18:16:28Z 2020-10-31T18:16:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
12046c32207f35d2260268e3ab52f313835df6e7 Fixed bad bash syntax, refs #13 2020-03-23T22:41:36Z 2020-03-23T22:41:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
120f20cd97c14b4d9102d9c309b27cc2c0e4ee17 Allow "." in database filenames, closes #302 2018-06-21T15:21:09Z 2018-06-21T15:21:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
121e10c29c5b412fddf0326939f1fe46c3ad9d4a Doumentation and test for utils.parse_metadata(), closes #1405 2021-07-29T23:30:12Z 2021-07-29T23:30:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
12350e8b8a5e55f0fba14bb37ca725d751056c92 Fixed broken link to global-power-plants demo 2019-05-16T05:12:36Z 2019-05-16T05:12:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
124acf34a678f0af438dc31a2dceebf28612f249 Removed db.get_outbound_foreign_keys method It duplicated the functionality of db.foreign_keys_for_table. 2020-05-30T18:39:46Z 2020-05-30T18:39:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1259b8ac0bb25fc8af61c1948e2cc16860dca7ff Support _search_COLUMN=text searches, closes #237 2018-05-05T22:33:08Z 2018-05-05T22:33:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
125c625fbc46244a4b4025732e1526fb13c55843 .rows_where(..., order_by=) argument, closes #76 2020-04-16T03:12:55Z 2020-04-16T03:12:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
126703706ea153f63e6134ad14e5712e4bbcb8ae Release 3.19 Refs #342 2021-11-21T04:40:47Z 2021-11-21T04:41:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
12731143c8bba510bebe96a48c126902ca8b5449 Renamed secret 2021-05-19T16:05:52Z 2021-05-19T16:05:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
127a836054fb784dc02ea40dadb55b3741dcd603 Documented new table configuration options via .table() 2019-07-22T23:59:17Z 2019-07-22T23:59:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
12877d7a48e2aa28bb5e780f929a218f7265d849 Plugin testing docs now recommend datasette.client, closes #1102 2020-11-29T07:44:57Z 2020-11-29T07:44:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
129141572f249ea290e2a075437e2ebaad215859 `sqlite-utils bulk` command * sqlite-utils bulk command, closes #375 * Refactor import_options and insert_upsert_options, refs #377 * Tests for sqlite-utils bulk, refs #377 * Documentation for sqlite-utils bulk, refs #377 2022-01-11T02:10:54Z 2022-01-11T02:10:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
129cc710285f75494bbddf8d8fa6b8c099b8763d Only show facet if it has values 2020-09-04T07:42:08Z 2020-09-04T07:42:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep-beta 197431109 simonw 9599 web-flow 19864447
12b8c9de256ba907d4fa8e134bf9ce9bc012302e sqlite-utils memory --flatten, closes #332 2021-11-14T23:05:00Z 2021-11-14T23:05:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
12c0bc09cc4bf9addde20f3d46613de11f27c641 /-/allow-debug tool, closes #908 2020-07-24T22:54:41Z 2020-07-24T22:55:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
12cec411cae73ba7211429da12cd32c551fe17b1 Display metadata footer on custom SQL queries (#589) Closes #408 - thanks, @rixx! 2019-10-14T03:53:21Z 2019-10-14T03:53:21Z Tobias Kunze b90d9715d7c0881515e9d6aa98923ed89d445945 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 rixx 2657547 simonw 9599
12f3ca79956ed9003c874f67748432adcacc6fd2 google-github-actions/setup-gcloud@v0 2022-03-22T01:42:03Z 2022-03-22T01:42:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
12f7e1dc5624d14f644abead18bd90b420b6d97e Hashed URLs now have far-future cache expiry Since the URL now includes a hash of the database, we can return a Cache- Control: max-age=31536000 header for every response. The exception is our 302 redirects. These we now serve with a Link: header that tells any HTTP/2 server-push aware fronting proxies (such as Cloudfront) to push the target of the redirect. Closes #4 2017-10-24T02:36:44Z 2017-10-24T02:36:44Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
130dc8823ebdcc1834fc7c4a03c996b13fc1e444 Run Travis CI against Python 3.7 as well 2018-07-12T17:36:00Z 2018-07-12T17:36:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
13195d8747764df3952ed1117e0fd2152f1899e7 Test demonstrating fix for #335 2021-11-14T22:55:42Z 2021-11-14T22:55:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
13216cb6bd715b3068b917bdeb1f1f24d159c34c Don't push alpha/beta tagged releases to Docker Hub Refs #807 2020-06-18T20:40:33Z 2020-06-18T20:40:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
13426d1b232b1a570ac81717be351026ca36cfff --accept option for get, refs #50 2020-10-19T05:00:50Z 2020-10-19T05:00:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
13528faa817d79bc3900d3af7473300686b145d7 Release 2.6 2020-04-16T03:13:13Z 2020-04-16T03:13:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
136a70d88741e2a5892c3de437064a9d14494d66 Add column name classes to <td>s, make PK bold 2018-04-17T08:29:48Z 2018-04-18T01:13:02Z Russ Garrett cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 russss 45057 simonw 9599
138e4d9a53e3982137294ba383303c3a848cfca4 Update click requirement from <8.1.0,>=7.1.1 to >=7.1.1,<8.2.0 (#1694) Updates the requirements on [click](https://github.com/pallets/click) to permit the latest version. - [Release notes](https://github.com/pallets/click/releases) - [Changelog](https://github.com/pallets/click/blob/main/CHANGES.rst) - [Commits](https://github.com/pallets/click/compare/7.1.1...8.1.0) --- updated-dependencies: - dependency-name: click dependency-type: direct:production ... Signed-off-by: dependabot[bot] <support@github.com> Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com> 2022-04-08T23:05:09Z 2022-04-08T23:05:09Z dependabot[bot] 5df307d91b1167b0aa175853783d760add239497 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 dependabot[bot] 49699333 web-flow 19864447
13b3b51087964d5e1a8c1cdd2495e07bdbe176b8 Release 0.47.3 Refs #934, https://github.com/simonw/latest-datasette-with-all-plugins/issues/3 2020-08-15T20:56:08Z 2020-08-15T20:56:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13c960c03b46e35f3432063a19f3f528ca249e23 Test is no longer order dependent, closes #1123 2020-12-03T00:49:43Z 2020-12-03T00:49:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13d1228d80c91d382a05b1a9549ed02c300ef851 /dbname/tablename/-/modify-table-schema is OK after all Refs #1053, #296 2020-11-02T20:02:50Z 2020-11-02T20:02:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
13e4f9a676da91e271a243f18f3a4ebe4f84557a Unit test for _table custom template, refs #521 2019-07-03T03:06:22Z 2019-07-03T03:23:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13e76b375ac3e3448df5d705ba65fadaaf9887d6 Release 3.10 Refs #272, #274, #275, #276, #282, #284, #285 2021-06-19T16:01:39Z 2021-06-19T16:01:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
13ee3c222f8ee967a2f716cca11bee4ea51fea46 Moved BaseView.absolute_url() to Datasette 2019-04-13T19:16:05Z 2019-04-13T19:16:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
13f8868fb5efa01c263b24f6dd91c617e6e938e1 Demo also pulls datasette and sqlite-utils 2020-04-18T14:56:47Z 2020-04-18T14:56:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
13fd9bdf01451decd55e1cbbd4017c0e5d0522e7 docker push --all-tags, refs #1281 2021-03-29T01:07:49Z 2021-03-29T01:07:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
141544613f9e76ddb74eee38d6f8ee1e0e70f833 Extract out menu icon CSS, refs #981 2020-09-30T23:55:00Z 2020-09-30T23:55:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
142a550a99f3c78349a10ed79f1b513fe704a169 Facet results now have "truncated" field To indicate if there was more than 20 distinct values. Refs #255 2018-05-15T09:50:27Z 2018-05-16T15:27:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
143c105f875f4c8d4512233fa856477a938b38ca Removed rogue print 2022-04-12T18:43:32Z 2022-04-12T18:43:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
143c3c5e2c5cf2c608742297d00cac6d499aa9ed Add dependent_repos view, closes #36 Also refs #37 2020-05-02T16:29:47Z 2020-05-02T16:29:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1440d01f5580c22cd55cd0dab5ac921278164ef5 Fix for error if search query is github-to-sqlite, closes #31 2020-12-19T06:17:27Z 2020-12-19T06:17:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
147b52622d68473ba6ab184657258d8576100b05 sqlite-utils tables ... --schema option, closes #104 2020-05-01T17:09:36Z 2020-05-01T17:12:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
148e9c7aeea2486b0562814b82f152506bfb0dd5 Use cog to maintain --fmt list, closes #373 2022-01-09T17:48:48Z 2022-01-09T17:48:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
14982bd900f17a66acc3930ec1a2ff138716d198 Release 0.50a1 Refs #995, #993, #989 2020-10-06T20:50:54Z 2020-10-06T20:50:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
14da70525b35e1a44cd45c19101385467057f041 Don't show 'None' as label for nullable foreign key, closes #406 2019-11-02T22:29:40Z 2019-11-02T22:29:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
14e320329f756b7d8e298c4e2251d8a0b194c9c4 Hidden tables data_licenses, KNN, KNN2 for SpatiaLite, closes #1601 2022-01-20T04:38:49Z 2022-01-20T04:38:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
14f643d9e91f5557d5e46251dadac481f4b41021 Better error messages in CLI, closes #309 2021-08-09T22:25:52Z 2021-08-09T22:25:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
14f6b4d200f24940a795ddc0825319ab2891bde2 actor_matches_allow utility function, refs #800 2020-06-06T18:39:11Z 2020-06-06T18:39:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
150967d98ef6c5b6064587e7ed30cbdd9b992b8e Hand-edited pixel favicon, refs #1603 2022-01-20T18:43:15Z 2022-01-20T18:43:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
152eb2afaf35cde5d44e50369f4cb32a72e72fdb Use pysqlite3 if available 2019-07-22T22:39:35Z 2019-07-22T22:39:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
15368c5f59066fc9c6b8ce5d0578132b1b68b75d First working version of .update(), refs #35 2019-07-14T17:03:18Z 2019-07-28T12:15:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1552ac931e4d2cf516caac3ceeab4fd24da1510a Documented custom error pages, closes #965 2020-09-14T18:47:16Z 2020-09-14T18:47:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
156196431219f27b3835ed3b96b6bf042053e6ca Upgrade to sqlite-utils 3.0, closes #30 2020-12-16T21:27:04Z 2020-12-16T21:27:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
15758d02fd437004fd9f84c9d4a8bf49f0793e13 Fixed spelling of objects, refs #310 2021-08-09T21:45:39Z 2021-08-09T21:45:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1592fd0419f374de201926d3ba67fbf1522eed13 Started work on cli, which also meant adding setup.py I'm using click, and click recommends using a setup.py - so I've added one of those. I also refactored code into a new datasite package. It's not quite deploying to now properly at the moment though - I seem to have messed up the path handling a bit. Also snuck in a new template for the "Row" view. Refs #40 2017-10-27T07:08:24Z 2017-10-27T07:08:24Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
15973d473310240d18eca264d64f2b1446ea2bb3 Switch to GitHub Actions for CI 2020-10-12T20:29:25Z 2020-10-12T20:29:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
15a9d4abfff0c45dee2a9f851326e1d61b1c678c Docs on named parameters with cast as real/integer, closes #1496 2021-10-22T19:34:23Z 2021-10-22T19:34:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
15e232180427e988174fdf88440c84b91d2d98d1 Extra body CSS class for canned queries, closes #727 2020-04-15T21:06:12Z 2020-04-15T21:07:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1600d2a3ec3ada1f6fb5b1eb73bdaeccb5f80530 Renamed /:memory: to /_memory, with redirects - closes #1205 2021-01-28T22:48:56Z 2021-01-28T22:48:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
160bfc35159f13572bdf32983164de59466fbcea Run pull-requests as part of demo, refs #48 2020-11-30T00:19:42Z 2020-11-30T00:19:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
16265f6a1a7c547e3925e0fc2d6b88754afb0435 Release notes for 0.31.1 2019-11-13T02:18:04Z 2019-11-13T02:18:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
16398641d95db7374fddccc79d0f08e4d4c96ee1 SQL syntax highlighting in docs 2018-05-31T13:17:53Z 2018-05-31T13:17:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1652a9707e325b387ab9550e78eefd48029be44f Apache 2.0 license badge 2018-04-16T23:10:12Z 2018-04-16T23:10:12Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
16665c9ee63df40bc262661ce6ed728a946375db Better handling of corrupted database files 2019-12-22T15:31:40Z 2019-12-22T15:31:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
16987bd56ef04ed1f1629b58272d8592c3a13249 Removed rogue assert False, refs #240 2021-02-25T16:35:24Z 2021-02-25T16:35:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
169b72e2c9f64214e32874e3dbd55e94b2e39540 repos --readme and --readme-html options, closes #52 2020-10-19T05:33:29Z 2020-10-19T05:33:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
169ea455fc1f1d5e5b6e44cb339ba7ffa9d49c31 Added table.delete_where(), closes #62 2019-11-04T16:18:06Z 2019-11-04T16:18:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
16d271253f4ea71b261d2d228b926c7bc1a7e660 Release 2.7 Refs #50 and #52 2020-10-19T05:36:32Z 2020-10-19T05:36:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
16d7008002b43cf47a973791da93e5cdd5913fc3 Applied black 2019-07-28T15:37:27Z 2019-07-28T15:37:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
16dfccb1c569359fa2a03639ada233e7661156af Include sha1 hash in /static/app.css URL This means that when Datasette's CSS changes the new CSS will be loaded even though browsers may have cached the previous version. Closes #154 2017-12-09T03:10:09Z 2017-12-09T03:10:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
16f592247a2a0e140ada487e9972645406dcae69 Use explicit lifestyle=on for Uvicorn, refs #873 2020-06-29T15:42:50Z 2020-06-29T15:42:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
16fdabda978fa659bed0e8670a385dab3c2cd197 Better robustness in face of missing raw_path 2019-07-04T14:03:02Z 2019-07-04T14:03:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
17243fc35546fefbdba7bf7f3bc6ab13b06e39e3 Release notes for 0.28 - closes #463 2019-05-19T21:24:12Z 2019-05-19T21:24:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
172da009d890aa029cff7138b4dcfd4f60948525 Added ?_through= table argument, closes #355 Also added much more interesting many-to-many fixtures - roadside attractions! 2019-05-23T05:44:34Z 2019-05-23T05:45:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
17606ed11e157f3c67611d7233b60ed5eb750c37 statuses-lookup command, closes #13 2019-10-07T00:31:27Z 2019-10-07T00:31:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
176f4e0ef4a4825ae3b61a5f7169a8943fccb073 sqlite-utils rebuild-fts command, closes #155 2020-09-08T23:16:03Z 2020-09-08T23:16:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
177059284dc953e6c76f86213aa470db2ff3eaca New request.actor property, refs #811 2020-06-08T17:05:32Z 2020-06-08T17:05:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
17863d108b9c8672b5e102d97858a96ca715a9d6 datasette publish heroku now supports --extra-options, closes #334 2018-07-10T01:45:56Z 2018-07-10T01:45:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
178b7e8749f14300363af5961e9f8964595264d9 .csv now links to .blob downloads Closes #1063, closes #1034 2020-10-29T22:47:32Z 2020-10-29T22:47:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
17cbbb1f7f230b39650afac62dd16476626001b5 generated_columns table in fixtures.py, closes #1119 2020-12-01T00:28:02Z 2020-12-01T00:28:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
17fee0cc1411b69d66d4401120f96c5087b16841 Automatically deploy tags as PyPI releases https://docs.travis-ci.com/user/deployment/pypi/ 2017-11-25T03:02:55Z 2017-11-25T03:32:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
180c7a5328457aefdf847ada366e296fef4744f1 --uds option for binding to Unix domain socket, closes #1388 2021-07-10T23:37:30Z 2021-07-10T23:37:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1818f611fcb1f567b430bba8954e7c3b3b1eb8f1 Removed some debugging, refs #13 2020-03-23T22:28:29Z 2020-03-23T22:28:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 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 · Queries took 15.515ms · About: simonw/datasette-graphql