commits

Table actions

3,784 rows

✎ View and edit SQL

This data as json, CSV (advanced)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
06dfb95a5ca5c0682ccad87b6150a2b0db66ade1 Initial working version Only supports loading checkins from a JSON file on disk: swarm-to-sqlite swarm.db -f checkins.json 2019-08-30T11:26:27Z 2019-08-30T11:26:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
06fdf0fd79adb8510da5de8f6ed30a0b5b8668e1 Fully working faceted search Closes #3 2020-09-03T21:01:14Z 2020-09-03T21:01:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
07044bd130542870d5eb2e545988d0a24eb573ec SQL view-friendly arraycontains/arraynotcontains implementation, refs #448 2021-11-15T23:41:07Z 2021-11-15T23:41:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
070838bfa19b177f59ef3bd8f0139266adecda90 Better test for Vary header 2020-06-06T19:26:19Z 2020-06-06T19:26:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
071bc2dd6350461aa1fb1a8e281ad9a79fba08ae Typo 2020-03-21T04:29:53Z 2020-03-21T04:29:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f hacker-news-to-sqlite 248903544 simonw 9599 web-flow 19864447
073ae9b4c7cbd80355777b50eacee03828e0655e Drop Python 3.6, add 3.10 and 3.100 2022-12-15T17:41:50Z 2022-12-15T17:41:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
0747dabb24b608e8524de4858ce50c60ba7e471b table.update() method * Also now set .last_pk to lastrowid for rowid tables * table.pks introspection now returns ["rowid"] for rowid tables Closes #35 2019-07-28T15:43:50Z 2019-07-28T15:43:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0748a65a22302640ec7520a19aaba280b5615930 Fixed content-disposition header on DB download, closes #909 2020-07-29T21:34:22Z 2020-07-29T21:34:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
075d422c0a1c70259188dfbd940538c67419694a Fixed typo 2017-11-14T05:28:02Z 2017-11-14T05:28:02Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0784f2ef9d3ff6dd9df05f54cb51de29a6d11764 Allow specific pragma functions, closes #761 2020-05-06T17:18:31Z 2020-05-06T17:18:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0789bad8f7581fd96dec5bde51a75e937dffb1e0 @db.register_function(deterministic=True), closes #191 2020-10-28T21:24:03Z 2020-10-28T21:30:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
079bf1f4dc8540f834adae68c7feeeffcbc1d4f2 Use tmp_path fixture in test_recreate, refs #503 2022-10-25T20:06:58Z 2022-10-25T20:06:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
07a10bdb2c09c7e275a9db546c42900b1dea4e75 foreign_keys=[...] can now detect tables and keys - closes #25 2019-06-13T05:32:26Z 2019-06-13T05:32:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
07aad511769da9242260c850e8d975cbd8c29552 Merge pull request #1912 from simonw/1.0-dev Merge 1.0-dev (with initial write API) back into main 2022-11-29T19:39:36Z 2022-11-29T19:39:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
07e163561592c743e4117f72102fcd350a600909 All ?_ parameters now copied to hidden form fields, closes #1194 2021-01-25T03:10:10Z 2021-01-25T03:10:10Z 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
07fc2d113e462bfd8d7d56152c0d1fc55e0fdbe9 Fix for _sort_desc=sortable_with_nulls test, refs #216 2018-04-17T00:05:03Z 2018-04-17T00:05:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
08029a2f8f67bbcd42bea755de5fb7db12b2c275 Hyperlink to www.srihash.org 2018-05-26T19:46:24Z 2018-05-26T19:46:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0807c4200f6b31c804c476eb546ead3f875a2ecc Release notes for 0.45a1, refs #852 2020-06-18T23:40:45Z 2020-06-18T23:40:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
080d4b3e065d78faf977c6ded6ead31aae24e2ae Switch to python:3.10.6-slim-bullseye for datasette publish - refs #1768 2022-08-14T15:49:14Z 2022-08-14T15:49:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
08110bc2b8801d725d65fa834d30b57e473d2241 Added example Twitter developer account application email Thanks to Jacob Kaplan-Moss: https://twitter.com/jacobian/status/1192510111719313408 2019-11-08T23:04:17Z 2019-11-08T23:04:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
084350b0f1343d988928cae63cfedbeb6205e25e Switched to gather_request=False for Sanic tests Gets rid of those ugly _, response = lines. 2017-11-17T14:53:37Z 2017-11-17T14:53:37Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
084cfe1e00e1a4c0515390a513aca286eeea20c2 Removed out-of-date datasette serve help from README 2021-07-15T01:00:39Z 2021-07-15T01:00:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
087753cd42c406f1e060c1822dcd9b5fda3d60f4 sites.db is better name than dogs.db in this example 2022-08-28T04:01:55Z 2022-08-28T04:01:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
088d89982299f8136e608fa2b6c30e9529adc714 Release 3.23 Refs #79, #363, #392, #393, #395, #396 2022-02-04T06:41:46Z 2022-02-04T06:41:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
089278b8dbe0cb3d41f27666d97b0096b750fbe2 rST fix, refs #1384 2021-06-26T22:49:07Z 2021-06-26T22:49:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
08947fa76433d18988aa1ee1d929bd8320c75fe2 Fix more broken base_url links Refs #1519, #838 2021-11-20T19:03:08Z 2021-11-20T19:03:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
08b4928a75faa1f2ba1c5b9908bcf2df4975a9d4 asgi-csrf>=0.6, refs #835 2020-07-01T01:18:19Z 2020-07-01T01:18:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
08f4b7658fec97419eb34118a2cd5c8be805673f Show facets that timed out using new InterruptedError If the user requests some _facet= options that do not successfully execute in the configured facet_time_limit_ms, we now show a warning message like this: These facets timed out: rowid, Title To build this I had to clean up our SQLite interrupted logic. We now raise a custom InterruptedError exception when SQLite terminates due to exceeding a time limit. In implementing this I found and fixed a logic error where invalid SQL was being generated in some cases for our faceting calculations but the resulting sqlite3.OperationalError had been incorrectly captured and treated as a timeout. Refs #255 Closes #269 2018-05-18T06:07:45Z 2018-05-18T06:11:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
09033c08bec8555e0e893e077afa10a7a75d7d35 Suggest --load-extension=spatialite, closes #1115 2020-11-29T20:13:16Z 2020-11-29T20:13:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
091441a4449beae559a8c0d007376dc85d3aa624 Fixed remaining places that needed datasette.urls, closes #1025 2020-10-20T05:21:19Z 2020-10-20T05:21:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
09253817dea3c131553494f9b2eb9c03f94ae761 Fix for missing view_name bug, closes #716 2020-04-05T18:28:20Z 2020-04-05T18:28:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
092874202c8748d6e0d4800eaf707c0145d95ffe Improvements to allow block logic and debug tool true and false allow block values are now supported, closes #906 Added a bunch of demo links to the documentation, refs #908 2020-07-25T00:04:06Z 2020-07-25T00:04:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
092e1368edc4e7f4cb337a62eabd9a6e1245006b Fixed typo 2019-05-25T14:24:17Z 2019-05-25T14:24:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
09316835e609e2321dafa08d37d8f227521373f8 Implemented --tsv option, closes #41 2019-07-19T04:50:38Z 2019-07-19T04:50:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0934844c0b6d124163d0185fb6a41ba5a71433da request.post_vars() no longer discards empty values 2020-06-03T13:48:39Z 2020-06-03T13:48:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0949f0989c932bae59ec702a002fe521ca56570c emojis command, closes #47 2020-08-18T14:52:08Z 2020-08-18T14:52:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0988f2eccc2dfa26b1a55243582222f540a72838 Explicitly include tests and docs in sdist (#75) Also exclude 'tests' from runtime installation - thanks, @jayvdb 2020-01-31T00:21:26Z 2020-01-31T00:21:26Z John Vandenberg 85de645274a2cefaeda2a43f117f5e672fd8e2f9 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 jayvdb 15092 web-flow 19864447
0991ea75cc7b265389aa8362414a305ba532d31a Renamed _timestamp to _now, refs #842, closes #871 2020-06-28T19:45:34Z 2020-06-28T19:47:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
09a3479a5402df96489ed6cab6cc9fd674bf3433 New "startup" plugin hook, closes #834 2020-06-13T17:55:41Z 2020-06-13T17:55:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
09a41662e70b788469157bb58ed9ca4acdf2f904 Fix typo 2022-08-18T16:10:48Z 2022-08-18T16:10:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
09bf3c63225babe8e28cde880ca4399ca7dbd78b Documentation for publish --secret, refs #787 2020-06-11T16:14:30Z 2020-06-11T16:14:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
09c3386f55f766b135b6a1c00295646c4ae29bec Applied Black, refs #237 2021-02-25T17:13:00Z 2021-02-25T17:13:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
09ef305c687399384fe38487c075e8669682deb4 Fixed "datasette publish now ... --alias=x" The --alias argument can now be passed more than once. Also updated our Travis configuration to use this. Fixes #459 2019-05-11T20:20:36Z 2019-05-11T20:20:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0a0cec3cf27861455e8cd1c4d84937825a18bb30 Release 1.12.1 2019-11-07T04:58:47Z 2019-11-07T04:58:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0a14a4846b29b4b60d153356ad926cbc461c45c7 Added plugin_config() method 2018-08-28T08:35:21Z 2018-08-28T08:35:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0a2dddccd7eb6cedae128c08931f14f12d5bce70 'github-to-sqlite repos' now accepts multiple usernames 2019-11-11T05:02:33Z 2019-11-11T05:02:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0a47c376ba8c7143aeb05146643d6b26bb83e485 archive_app import for app.js 2021-08-21T20:50:14Z 2021-08-21T20:50:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
0a7621f96f8ad14da17e7172e8a7bce24ef78966 Use pytest-xdist to speed up tests (#1290) * Run tests in CI using pytest-xdist * Documentation for pytest-xdist Closes #1289 2021-04-03T03:42:28Z 2021-04-03T03:42:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0a7815d2038255a0834c955066a2a16c01f707b2 Documentation for facet_size in metadata, closes #1804 2022-09-06T18:06:49Z 2022-09-06T18:06:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0a8194e730f8ecdd9a5af1f6a8d5a889796d7dba sqlite-utils optimize command, .optimize() and .detect_fts() table methods 2019-01-25T04:35:51Z 2019-01-25T04:35:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0aa28293adedc488eb9107dc52b5e9a124887fbd Fix compatibility with SQLite prior to 3.16.0 pragma_index_info() and pragma_index_list() were introduced in 3.16.0 but the version of SQLite running in Travis CI is earlier than that, hence the test failures: https://travis-ci.com/simonw/sqlite-utils/jobs/137617744 2018-08-01T15:29:53Z 2018-08-01T15:29:53Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
0abd3abacb309a2bd5913a7a2df4e9256585b1bb New ?_shape=objects/object/lists param for JSON API (#192) New _shape= parameter replacing old .jsono extension Now instead of this: /database/table.jsono We use the _shape parameter like this: /database/table.json?_shape=objects Also introduced a new _shape called 'object' which looks like this: /database/table.json?_shape=object Returning an object for the rows key: ... "rows": { "pk1": { ... }, "pk2": { ... } } Refs #122 2018-04-03T14:52:54Z 2018-04-03T14:52:54Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0ac8bbce2e73c0759ec48661a7b740d2c368b2a2 Default subcommand is now serve Using click-default-group: https://github.com/click-contrib/click-default-group Also removed requirements.txt in favour of setup.py 2017-11-04T23:53:50Z 2017-11-04T23:53:50Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0ad3ce5e2d664c227d7045afafec46704f251a10 Use INTEGER for organization column, fixes #27 2020-04-18T00:18:45Z 2020-04-18T00:18:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0b0a431bff94d24866fc10d82dc91ab00287de2d Changelog for 2.0 release 2019-12-30T06:18:44Z 2019-12-30T06:18:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0b0c5cd7a94fe3f151a3e10261b5c84ee64f2f18 Hopeful fix for Python 3.7 httpx failure, refs #2066 2023-04-27T04:20:38Z 2023-04-27T04:20:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0b1af42ead3b3902347951180b3364ce1942da6e Link to my blog entry 2019-02-25T03:45:38Z 2019-02-25T03:45:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0b244d207a460d872cdac029d01deec784058858 Release 3.2.1 Refs #221 2021-01-12T23:22:53Z 2021-01-12T23:22:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0b315d3fa83c1584eaeec32f24912898621e437a progressbar for inserts/upserts of other file formats * progressbar for inserts/upserts of other file formats, closes #485 * Pin to Python 3.10.6 for the moment as workaround for mypy error Co-authored-by: Simon Willison <swillison@gmail.com> 2022-09-15T20:37:51Z 2022-09-15T20:37:51Z Mischa Untaga e7784035c9ce3ef64d906c543907d5025673d054 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 MischaU8 99098079 web-flow 19864447
0b4a28691468b5c758df74fa1d72a823813c96bf render_cell(..., request) argument, closes #2007 2023-01-28T03:34:14Z 2023-01-28T03:34:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0b5edd646926d6e01e3bf9f2897d072f4302ce2d Added basic tests using hypothesis, closes #180 2020-10-19T04:51:50Z 2020-10-19T04:51:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0b68996cc511b3a801f0cd0157bd66332d75f46f Revert "Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955" This reverts commit dc18f62089e5672d03176f217d7840cdafa5c447. 2022-12-15T21:06:45Z 2022-12-15T21:06:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0b6aba696dd07814d97f563de6ad1d5daab01fd9 Documentation for maximize_csv_field_size_limit, closes #442 2022-06-14T21:31:45Z 2022-06-14T21:31:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0b702f3679a2ffd4e3efb5c34b9fe30221172ccb Fixed weird edge-case with foreign key detection It turns out it is possible for a SQLite table to define a foreign key relationship to a table that does not actually exist We should still be able to handle these databases. 2017-11-17T16:18:26Z 2017-11-17T16:18:26Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0b7b80bd40fe86e4d66a04c9f607d94991c45c0b Document the convert() with initialization pattern, closes #420 2022-03-25T20:07:29Z 2022-03-25T20:07:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0b84d52ab87d960d4b5e188052540518db2ea569 Release 0.10 2019-10-15T18:53:53Z 2019-10-15T18:53:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
0b8a952cd5709ac27494b1694ca95188c89442ce Release 0.20.1 Refs #41 2020-04-01T04:31:23Z 2020-04-01T04:31:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
0b8c1b0a6da9cb8ac0d28cc90dd783de87554036 Test for sql_time_limit_ms + sqlite_functions mechanism Added a unit test for the sql_time_limit_ms option. To test this, I needed to add a custom SQLite sleep() function. I've added a simple mechanism to the Datasette class for registering custom functions. I also had to modify the sqlite_timelimit() function. It makes use of a magic value, N, which is the number of SQLite virtual machine instructions that should execute in between calls to my termination decision function. The value of N was not finely grained enough for my test to work - so I've added logic that says that if the time limit is less than 50ms, N is set to 1. This got the tests working. Refs #95 2017-11-15T02:41:03Z 2017-11-15T02:43:34Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0b8e5981a37c0da75ce4f4e6b6b5275681e2e0c5 Typo fix 2018-05-20T21:30:48Z 2018-05-20T21:30:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0b9ac1b2e9c855f1b823a06a898891da87c720ef Release 0.54 Refs #509, #1091, #1150, #1151, #1166, #1167, #1178, #1181, #1182, #1184, #1185, #1186, #1187, #1194, #1198 2021-01-25T17:33:29Z 2021-01-25T17:33:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0bb483ca5bee61c9f7d148b5755d2eed56001aca /-/static-plugins/PLUGIN_NAME/ now serves static/ from plugins Refs #214 2018-04-18T02:32:48Z 2018-04-18T02:32:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0bc49e938e1e3444df734f9178a9a317f68f9716 'sqlite-utils add-column name type' command, closes #15 2019-02-24T20:04:33Z 2019-02-24T20:04:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0bc5186b7bb4fc82392df08f99a9132f84dcb331 Tooltip and commas for byte length display, closes #1712 2022-04-12T18:44:12Z 2022-04-12T18:44:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0bc6ba503eecedb947d2624adbe1327dd849d7fe Release 0.3.1 Refs #8, #10 2021-02-11T22:38:21Z 2021-02-11T22:38:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 evernote-to-sqlite 303218369 simonw 9599 simonw 9599
0bd41d4cb0a42d7d2baf8b49675418d1482ae39b Do not show default plugins on /-/plugins 2018-08-28T07:36:22Z 2018-08-28T07:36:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0be971c2801ab6369f5b887dc2a578f78fb6b3ef alter=True in a bunch more places, refs #11 2021-01-18T04:13:28Z 2021-01-18T04:13:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
0bf51d404929f5a019fdcd96c9fc5b8f780a3347 Apply autoescape to display templates You can still opt out of it using |safe 2020-09-18T22:20:41Z 2020-09-18T22:20:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
0c064c5fe220b7b3d8dcf85b02b4e60452c47232 More things you can do with plugins 2020-06-05T03:10:40Z 2020-06-05T03:10:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0c1b8b7f96be874bb63801f69323960f277aa49a Use assertion to enforce <=999 columns 2019-07-28T11:41:57Z 2019-07-28T11:41:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c22fa8f09e9fce7434d5fc83bcfb73c25795205 Cleaned up view_definition/table_definition code in table view Also moved those out of standard JSON into just the HTML template context 2018-06-16T17:33:17Z 2018-06-16T17:33:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0c2451e0690c5f4e6463a2f339b0a280e30ed806 Release 2.3 2020-02-08T23:56:16Z 2020-02-08T23:56:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c27f10f9d2124f0f534c25612b58be20441c9d8 Updated plugin examples to include datasette-psutil 2020-06-13T23:41:26Z 2020-06-13T23:41:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0c36feb6ca5c3ffb9a6df4c8ea4bb732fcab74f4 .enable_fts() now works with columns with spaces in them, closes #90 2020-03-02T06:10:43Z 2020-03-02T06:10:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c616f732cee79db80cad830917666f41b344262 Release 0.53 Refs #1132, #1135, #1133, #1138, #1137 2020-12-11T01:44:36Z 2020-12-11T01:44:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0c6745b70f95663f8ddf4309c578bd568eca75ec Whitespace fix 2019-02-24T18:42:27Z 2019-02-24T18:42:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0c756b8cd948bd69b7342c0d0e93bad4ff4e97b2 Added datasette-bplist plugin to ecosystem 2019-06-09T02:11:59Z 2019-06-09T02:11:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0c91e59d2bbfc08884cfcf5d1b902a2f4968b7ff datasette-leaflet-freedraw is an example of filters_from_request 2021-12-17T23:28:44Z 2021-12-17T23:55:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0ca5585fcb834122193e8e7186f926217b23cb8a Clarify why you would want transform_sql() 2020-09-23T20:16:01Z 2020-09-23T20:16:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0cb29498c796267c5e4a5545ede8058b7ca03a94 Fixed bug with python tests/fixtures.py https://github.com/simonw/datasette/runs/1333357885?check_suite_focus=true 2020-10-30T17:54:47Z 2020-10-30T17:54:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0cd982fc6af45b60e0c9306516dd412ae948c89b De-duplicate 'datasette db.db db.db', closes #1632 Refs https://github.com/simonw/datasette-publish-fly/pull/12 2022-02-07T23:28:46Z 2022-02-07T23:28:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0cdceb9244a21fbd1e70a6ca0a76b2ed2ce4dd3f github-to-sqlite commits command, refs #17 2020-03-10T21:55:36Z 2020-03-10T21:55:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0cdf111ae68d46eb2eb51d85e20e1447a42cbdcc Move pip/pipx to top of installation instructions Less intimidating than Docker, hopefully. 2020-05-04T19:31:13Z 2020-05-04T19:31:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0cee77b1764f7dff029eb0ea1e857e5b69c591ee Update test for renamed restkey, refs #440, #443 2022-06-14T21:14:10Z 2022-06-14T21:14:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0cfd7ce59d9018eb07af8f9e20f7d04308c9d01d Allow WITH query (previously we required SELECT at start) Fixes #161 2017-12-04T04:51:31Z 2017-12-04T04:51:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0d10402f7b0428c6bb275a106b628298c6d0201d table.create_index(..., analyze=True), refs #378 2022-01-10T20:00:24Z 2022-01-10T20:00:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0d1763fb2fdabcdde321646721703df1dfcb8597 More datasette.urls usage, refs #1025 2020-10-20T04:24:47Z 2020-10-20T04:24:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0d2a47eab99f625be7ef4f77c6e9803177d13a2c .reset_counts() method and reset-counts command, closes #219 2021-01-03T20:59:31Z 2021-01-03T20:59:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0d2e4f49f324de01bcd8257d0adeea3ebf391791 db.schema and 'sqlite-utils schema' command, closes #268 2021-06-11T20:51:49Z 2021-06-11T20:51:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0d339a4897c808903e34fa6be228cdaaa5a29c55 Removed text about executing SQL, refs #1384 2021-06-26T23:04:39Z 2021-06-26T23:04:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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]);