commits

Table actions

3,491 rows sorted by repo

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 799 ✖

sha message author_date committer_date raw_author raw_committer repo ▼ author committer
4df1b4d8b0cd37a880d8a04c823be7783c6d5fad Re-arranged full-text search docs Also documented ?_searchmode=raw - closes #748 2020-04-30T21:06:00Z 2020-04-30T21:06:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
cf2d547ffc9ecee265e09780ad73bcc337ad8ef3 Documentation for #747 2020-04-30T19:02:28Z 2020-04-30T19:02:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1d91ab71d4359741b03bbd4347f4360eb8ca817d Directory configuration mode supports metadata.yaml, closes #747 2020-04-30T18:47:21Z 2020-04-30T18:47:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d18086ae016caf14be0da7154ad92cf9d7bec060 Changelog badge 2020-04-30T18:31:35Z 2020-04-30T18:31:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
e37f4077c0f1cd09d4102213d4e2a512af471b8d Remove 'Serve!' line from serve CLI output It wasn't adding anything, and it was confusing when run in conjunction with the new config directory mode from #731 2020-04-27T22:02:02Z 2020-04-27T22:02:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
89c4ddd4828623888e91a1d2cb396cba12d4e7b4 403 for static directory listing, closes #740 2020-04-27T18:29:04Z 2020-04-27T18:29:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
25014ca25eb70b4c1217558ebd14db2845973bfb Configuration directory mode, closes #731 2020-04-27T16:30:24Z 2020-04-27T16:30:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
1b7b66c465e44025ec73421bd69752e42f108321 Make request available when rendering custom pages, closes #738 2020-04-26T19:01:46Z 2020-04-26T19:01:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
304e7b1d9fd904ae1c35600bc03662eb90eeeae0 Mechanism for creating custom pages using templates Closes #648 2020-04-26T18:46:43Z 2020-04-26T18:46:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
227bb3e91fe34811a9374150798643a5af98ed79 Added more example plugins 2020-04-22T13:47:20Z 2020-04-22T13:47:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
8da108193b08abf140716f8ac499f32309dfe9cf Fixed a couple of spelling errors 2020-04-22T04:06:39Z 2020-04-22T04:06:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
edb39c91f75c97b6b55f1db6b7626e66cb8f2d45 Release Datasette 0.40 2020-04-22T04:00:34Z 2020-04-22T04:00:34Z 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
d349d57cdf3d577afb62bdf784af342a4d5be660 Smarter merging of metadata and extra_metadata, closes #724 2020-04-10T18:34:09Z 2020-04-10T18:34:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d55fe8cdfc2ce7bc6960bf2507766c1fcd1d31a7 Fixed bug with Templates considered comment, closes #689 2020-04-05T19:38:33Z 2020-04-05T19:38:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e89b0ef2f9ae89eb3bde83b694f21452ea4858da Expose extra_template_vars in _contex=1, refs #693 2020-04-05T18:49:15Z 2020-04-05T18:49:15Z 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
e0e7a0facfc935a835cd73c720bc46661462f0b1 Removed Zeit Now v1 support, closes #710 2020-04-04T23:04:33Z 2020-04-04T23:04:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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
b07312c2b3bc7e4a9298c1f291f420bd92b6f842 dedent SQL for neighborhood_search fixture Makes this page a little prettier: https://latest.datasette.io/fixtures/neighborhood_search 2020-04-03T00:54:27Z 2020-04-03T00:54:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
6717c719dd36dc2adc0f9da38a8c8e08129e96b4 --metadata accepts YAML as well as JSON - closes #713 2020-04-02T19:30:53Z 2020-04-02T19:30:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
2aaad72789c427875426673c1a43e67c86fc970e Refactor template setup into Datasette constructor Closes #707 2020-03-27T01:12:43Z 2020-03-27T01:12:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
6aa516d82dea9885cb4db8d56ec2ccfd4cd9b840 Run base_url tests against /fixtures/facetable too, refs #712 2020-03-26T02:31:22Z 2020-03-26T02:31:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
99b1e919651c4be781aea162fe517e45f1f2a9c3 Fixed RST bug 2020-03-25T04:46:52Z 2020-03-25T04:46:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
dedd775512daee49925882654f252df61a9e3b6d Release 0.39 2020-03-25T04:02:37Z 2020-03-25T04:02:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a351d353bc0d6b0f737f789a0c2953e2531ed92d Fixed typo in GitHub Action configuration, refs #705 2020-03-25T02:30:50Z 2020-03-25T02:30:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
90015b26895fd2bd29676bc375f096102b0587ed Deploy latest.datasett.io to Cloud Run, refs #705 2020-03-25T02:26:02Z 2020-03-25T02:26:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
cc4445801eb7c86a686b0e65fbd815d5aef857ec Removed deploy to Zeit Now, refs #705 2020-03-25T02:17:27Z 2020-03-25T02:17:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7656fd64d8b6a32ebc34d89c1b8711cc5ea240f7 base_url configuration setting, closes #394 * base_url configuration setting * base_url works for static assets as well 2020-03-25T00:18:43Z 2020-03-25T00:18:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
2a36dfa2a892122029f379722913469d71367925 Fix for input type=search Webkit styling, closes #701 2020-03-24T22:57:09Z 2020-03-24T22:57:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
5f4aeb1f198e2e866a1eed6a7194842d77313ea8 Removed documentation for Zeit Now v1, refs #710 2020-03-24T22:45:24Z 2020-03-24T22:45:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c0aa929cdd497f0c722e6f4eb17ad5668786a6fd Added datasette-publish-fly plugin to docs, closes #704 2020-03-24T22:38:58Z 2020-03-24T22:38:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3b3cb3e8df243408ab4c03b0ea75cadd02bd65dc Added example plugins to plugin hooks docs, closes #709 2020-03-24T22:29:34Z 2020-03-24T22:29:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a498d0fe6590f9bdbc4faf9e0dd5faeb3b06002c Fix bug with over-riding default sort, closes #702 2020-03-22T02:40:29Z 2020-03-22T02:40:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
236aa065b2ecfbe5a77870689bae432b89a48b23 "sort" and "sort_desc" metadata properties, closes #702 2020-03-22T02:28:35Z 2020-03-22T02:28:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e1a817411a20e3120943ee407503e53a7445c0db Bump to click 7.1.1 to fix flaky tests 2020-03-22T01:47:51Z 2020-03-22T01:47:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3d656f4b31e95047e0ffc1eaa7417a303ccce3c1 Updated documentation formatting 2020-03-22T01:31:49Z 2020-03-22T01:31:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
2c0e1e09bc833c5939c20b937a2ce8ef997c5f5a Show sort arrow on primary key by default Closes #677. Refs #702. 2020-03-21T23:57:37Z 2020-03-21T23:57:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fd2a74dc09e585802ecec76c1a20a9c5a839a36a Updated publish_subcommand example 2020-03-19T00:47:53Z 2020-03-19T00:47:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
a000c80d5036822c8324c1cd037fe7d20e5246b5 await Request(scope, receive).post_vars() method, closes #700 Needed for #698 2020-03-17T02:47:37Z 2020-03-17T02:47:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7e357abbc38dcc9d19a2f1df3252668a48e941e4 Release 0.38 2020-03-08T23:26:50Z 2020-03-08T23:26:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e1b5339fdfe47474a0d33a400acedefecff6e67e Do not look for templates_path in default plugins Closes #697 2020-03-08T23:09:31Z 2020-03-08T23:11:18Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7508477a96492caa1893c52411405656c50d30f9 Link to Datasette Writes blog entry 2020-03-08T17:23:51Z 2020-03-08T17:23:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
f7f31a0223d822f7186c4d20174c002cb723d0f9 Upgrade Dockerfile to SQLite 3.31.1, closes #695 2020-03-06T06:15:19Z 2020-03-06T06:15:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
af9cd4ca64652fae262e6f7b5d201f6e0adc989b Fixes for new --memory option, refs #694 2020-03-05T23:44:15Z 2020-03-05T23:44:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ddd11b3ddd886d16867c134d73105895c5726cc7 --memory option for publish cloudrun, refs #694 2020-03-05T23:34:21Z 2020-03-05T23:34:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
be20e6991eac2baa9b43e9b26ae209bae805ede5 Changelog for 0.37.1 2020-03-03T03:43:08Z 2020-03-03T03:43:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b796519da27dc6c30d490321bb449091974d3d38 Print exceptions if they occur in the write thread 2020-03-03T01:59:29Z 2020-03-03T01:59:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
dc80e779a2e708b2685fc641df99e6aae9ad6f97 Handle scope path if it is a string I ran into this while running a unit test with httpx.AsyncClient 2020-03-02T20:01:10Z 2020-03-02T23:34:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4933035b75607e60dc63f7977e2bd4fa771d8898 RST fix 2020-03-02T16:10:16Z 2020-03-02T16:10:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
613f6fad7249da547c06ebc46616aba0f74259a4 Improved extra_template_vars documentation 2020-03-02T15:12:34Z 2020-03-02T15:12:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
7f5a330377fd7db1f6d1efa5686d183bcaf89217 Don't count rows on homepage for DBs > 100MB (#688) Closes #649. 2020-02-29T01:08:29Z 2020-02-29T01:08:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0f8e91c68f2d2ad48efc8324b12762bf8b58facd Documentation fix 2020-02-26T07:13:39Z 2020-02-26T07:13:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
1a77f30d3c40b1a6812da5d27ab35fa1acbd988b Fixed typo 2020-02-26T07:11:19Z 2020-02-26T07:11:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
c9e6841482b299fceadc5ad548c2dbf58a8f1227 News and release notes for 0.37 2020-02-26T01:22:02Z 2020-02-26T01:22:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
78198df668e189d2c9afe5f922fe4277d84b2f30 Fixed incorrect target name 2020-02-26T01:10:30Z 2020-02-26T01:10:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3041c6b6412bbe317f8b9afd6529a15954f2c47e Use inspect-file, if possible, for total row count (#666) For large tables, counting the number of rows in the table can take a significant amount of time. Instead, where an inspect-file is provided for an immutable database, look up the row-count for a plain count(*). Thanks, @kevindkeogh 2020-02-25T20:19:29Z 2020-02-25T20:19:29Z Kevin Keogh 0f68d17313c6f4ccbf0c24a3883444b5263f5648 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 kevindkeogh 13896256 web-flow 19864447
6cb65555f46456eb31b62e855e21b1d8c809b1a2 ?_searchmode=raw option (#686) 2020-02-25T05:56:03Z 2020-02-25T05:56:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
a093c5f79fa034a97d2ad8b606745dd3b80365af .execute_write() and .execute_write_fn() methods on Database (#683) Closes #682. 2020-02-25T04:45:08Z 2020-02-25T04:45:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
411056c4c43e74f2b3d0e3bc1175e7998516b1b3 Only --reload on changes to immutable databases, closes #494 2020-02-24T19:44:59Z 2020-02-24T19:44:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b031fe97636b80b05fec409ee1dffb7d044fd4e9 Updated README news for 0.36 2020-02-22T03:04:46Z 2020-02-22T03:04:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
962a7e16e5e73c000d87815194b8261428e0938e Release notes for 0.36, refs #679 2020-02-22T03:01:57Z 2020-02-22T03:01:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d6335f1f3184683b05131dd12a73ff1115aefba3 Added shapefile-to-sqlite, datasette-mask-columns, datasette-auth-existing-cookies, datasette-auth-existing-cookies Refs #679 2020-02-22T02:53:35Z 2020-02-22T02:53:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
be2265b0e811d0ac2875c2f748125c17b0f9289e Fix db-to-sqlite command in ecosystem doc page (#669) Thanks, @adipasquale 2020-02-22T02:32:17Z 2020-02-22T02:32:17Z Adrien Di Pasquale bd53542d6923dd8fcfd93cd43a925e6e8acd6e80 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 adipasquale 883348 web-flow 19864447
7c6a9c35299f251f9abfb03fd8e85143e4361709 Better tests for prepare_connection() plugin hook, refs #678 2020-02-22T02:27:07Z 2020-02-22T02:27:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
6303ea50483e432bbef193d1c54c2bf54e53f157 prepare_connection() now takes datasette and database args, refs #678 2020-02-22T01:32:40Z 2020-02-22T01:32:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d3f2fade88984dc6157b2ff69c24aa5a070f9716 Refactored run_sanity_checks to check_connection(conn), refs #674 2020-02-15T17:56:48Z 2020-02-15T17:56:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f1442a8151f66ceef6517b6d3d045e2ec1d0f0ec Replaced self.ds.execute with db.execute in more places 2020-02-14T02:20:05Z 2020-02-14T02:20:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
efa54b439fd0394440c302602b919255047b59c5 Docs for .render_template(), refs #577 Also improved parameter documentation for other methods, refs #576 2020-02-14T01:58:32Z 2020-02-14T01:58:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3ffb8f3b98252531d11897fd431711e9b8045ace .add_database() and .remove_database() methods, refs #671 Also made a start on the Datasette class documentation, refs #576 2020-02-14T01:25:27Z 2020-02-14T01:27:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
cf5f4386ef6fea9179bbaaec2e187917934759d7 Run black against everything, not just tests and datasette dirs 2020-02-13T23:02:10Z 2020-02-13T23:02:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b38a792ef0fb9c9e4057afd196bb9439edd9c0e9 Apply Black, update copyright to be 2017-2020 2020-02-13T23:00:35Z 2020-02-13T23:01:14Z 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
298a899e792ebd0cd82a5f01b613c31f19082e51 Reformatted with black 2020-02-13T06:05:46Z 2020-02-13T06:05:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
30b6f71b306a43605c99bef79302ed5cb22d1924 Updated release notes with #653 2020-02-05T02:17:30Z 2020-02-05T02:17:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
33a12c8ae526afb40a7819c9ca411c9d3c41219b Allow leading comments in SQL input field (#653) Thanks, @jaywgraves! 2020-02-05T02:13:24Z 2020-02-05T02:13:24Z Jay Graves 6410ac01839c113476668eeff88d60a0a2c6eb7a GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 jaywgraves 418191 web-flow 19864447
ce12244037b60ba0202c814871218c1dab38d729 Release notes for 0.35 2020-02-05T02:02:32Z 2020-02-05T02:02:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4d7dae9eb75e5430c3ee3c369bb5cd9ba0a148bc Added a bunch more plugins to the Ecosystem page 2020-02-04T20:49:41Z 2020-02-04T20:49:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
70b915fb4bc214f9d064179f87671f8a378aa127 Datasette.render_template() method, closes #577 Pull request #664. 2020-02-04T20:26:17Z 2020-02-04T20:26:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
286ed286b68793532c2a38436a08343b45cfbc91 geojson-to-sqlite 2020-01-31T07:09:56Z 2020-01-31T07:09:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
e7f60d2a9b59752e20de8412f7b0a3e9a5359a31 Release notes for Datasette 0.34, plus news updates 2020-01-30T00:09:01Z 2020-01-30T00:09:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
67fc9c5720ed1fcd62b116481f70d4e80b403a22 --port argument for datasette package, plus tests - closes #661 From pull request #663 2020-01-29T22:46:43Z 2020-01-29T22:46:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
34d77d780f68b778fd9d6ebbaf69f250436f055f gcloud run is now GA, s/beta// (#660) Thanks, @glasnt 2020-01-21T23:28:11Z 2020-01-21T23:28:11Z Katie McLaughlin f9a18a704545f33349d7b28b24faf7063846ae0a Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 glasnt 813732 simonw 9599
3c861f363df02a59a67c59036278338e4760d2ed _search= queries now correctly escaped, fixes #651 Queries with reserved words or characters according to the SQLite FTS5 query language could cause errors. Queries are now escaped like so: dog cat => "dog" "cat" 2019-12-29T18:48:13Z 2019-12-29T18:48:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
59e7014c8a0f4102d7dc79f517540c55c49e1554 Release 0.33 2019-12-22T16:27:04Z 2019-12-22T16:27:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
dc98b0f41defa4eb45d5b88fd9dfcfb1c5bbe144 Link to JSK Medium post from news 2019-12-22T16:16:58Z 2019-12-22T16:16:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d54318fc7f2565e6121920ce1ea9cb8b700e629a Added template_debug setting, closes #654 2019-12-22T16:04:45Z 2019-12-22T16:04:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ceef5ce684214a9b55d242043206cb10b13c878a Documentation for --port=0 2019-12-22T15:42:30Z 2019-12-22T15:42:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
85c19c4037ddc757794c63a04faad07a6ea57ae6 Apply black 2019-12-22T15:34:20Z 2019-12-22T15:34:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
9c3f0b73de059ec2b953f952fc1eadecb8f396c5 Bump to uvicorn 0.11 2019-12-22T15:33:04Z 2019-12-22T15:33:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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
d6b6c9171f3fd945c4e5e4144923ac831c43c208 Include asyncio task information in /-/threads debug page 2019-12-05T06:46:39Z 2019-12-05T06:47:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
2039e78e589ae7c60f404fe84fb75eda1630104e Added Niche Museums to News 2019-12-03T06:53:59Z 2019-12-03T06:53:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
a562f2965552fb2dbbbd74df245c9965ee23d886 Examples of things you can do with plugins 2019-11-27T19:19:11Z 2019-11-27T19:19:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f9d0ce4233b29a8a90b9d87e18aacdeefde2e022 Added datasette-haversine to plugins list 2019-11-27T14:04:32Z 2019-11-27T14:04:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
df2879ee2a88f94ae590067e019237afc2189e00 Better documentation for --static, closes #641 https://datasette.readthedocs.io/en/stable/custom_templates.html#serving-static-files 2019-11-26T02:31:42Z 2019-11-26T02:31:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
aca41618f8761f99c47c8ae8e81b07a6d4af4d7a index view is also important for plugin hooks 2019-11-25T17:04:39Z 2019-11-25T17:04:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d3e1c3017ee2f606a731208d59fe48805cdc3259 Display 0 results, closes #637 2019-11-23T06:07:01Z 2019-11-23T06:07:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fd137da7f83c117b18e189707a1039e319dd5c91 Suggest column facet only if at least one count > 1 Fixes #638 2019-11-22T00:56:55Z 2019-11-22T00:56:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c16be14517414a94e1fdbd888e8a3ad0669e3bca How to upgrade using Docker 2019-11-20T18:02:07Z 2019-11-20T18:02:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447

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