home / github

Menu
  • GraphQL API

commits

Table actions
  • GraphQL API for commits

3,922 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
10bc80547330e826a749ce710da21ae29f7e6048 Finish removing pkg_resources, closes #2057 2023-09-21T19:11:35Z 2023-09-21T19:13:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
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
1154048f7953fb178424e36a99e98b3742d40bb5 Compound primary key support for /db/-/create - closes #1911 Needed for tests in #1864 2022-11-29T18:47:46Z 2022-11-29T18:47:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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
11f7fd38a4aea01c8c75b85105b4a52989ea488a Fixed some rST header warnings 2023-10-12T22:05:02Z 2023-10-12T22:05:02Z 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
1260bdc7bfe31c36c272572c6389125f8de6ef71 Link to sqlite-utils-fast-fks from changelog 2023-08-18T17:47:10Z 2023-08-18T17:47:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
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
12ab0122798c1b3847c7cfcaefd2607b0aaaa89d --help output in README 2023-03-09T20:52:10Z 2023-03-09T20:52:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
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
1335bcb8939e903a4a7680493624055faecc3da4 Use my own global variable instead of scope=session Refs https://github.com/simonw/datasette/pull/1960#issuecomment-1354148139 2022-12-16T03:33:14Z 2022-12-17T21:47:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
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
1377a290cd85ba8d3338b1da47c4665ed4c6c625 New JSON design for query views (#2118) * Refs #2111, closes #2110 * New Context dataclass/subclass mechanism, refs #2127 * Define QueryContext and extract get_tables() method, refs #2127 * Fix OPTIONS bug by porting DaatbaseView to be a View subclass * Expose async_view_for_class.view_class for test_routes test * Error/truncated aruments for renderers, closes #2130 2023-08-08T01:47:39Z 2023-08-08T01:47:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
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
13ebcc575d2547c45e8d31288b71a3242c16b886 Backfilled release notes for 0.2, 0.3, 0.3.1 - closes #576 2023-07-23T05:48:14Z 2023-07-23T05:48:14Z 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
1465fea4798599eccfe7e8f012bd8d9adfac3039 sphinx-copybutton for docs, closes #1748 2022-05-20T19:11:08Z 2022-05-20T19:11:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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
1491b66dd7439dd87cd5cd4c4684f46eb3c5751b register_function(name=...) argument, closes #458 2022-07-28T00:13:49Z 2022-07-28T00:13:49Z 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
14f1cc49848f7194b914c9b604f3e99816281eb1 Update CLI reference help, refs #1855 2022-12-13T04:21:48Z 2022-12-13T04:21:48Z 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
1500c19bd0f31b2e7f28a5ec2d7bfa133a2e4d4c Add more STRICT table support (#604) * Add more STRICT table support per https://github.com/simonw/sqlite-utils/issues/344#issuecomment-982014776. * Make `table.transform()` preserve STRICT mode. * Fix mypy failures in PR #604 * Link to SQLITE strict page in a few places 2023-12-08T05:05:27Z 2023-12-08T05:05:27Z Taj Khattra 77887d00c62b181af66df54bd6325b314eb5b25e GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 tkhattra 16437338 web-flow 19864447
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
1563c22a8c65e6cff5194aa07df54d0ab8d4eecb Don't duplicate _sort_desc, refs #1738 2022-08-14T16:13:12Z 2022-08-14T16:13:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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
165bc5fcb0600a1898249e48b03ce798010e07f9 test_extract_works_with_null_values, refs #423, #455 2022-08-28T03:32:01Z 2022-08-28T03:38:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
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

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 76.825ms · About: simonw/datasette-graphql