github

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
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 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
084cfe1e00e1a4c0515390a513aca286eeea20c2 Removed out-of-date datasette serve help from README 2021-07-15T01:00:39Z 2021-07-15T01:00:39Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
088d89982299f8136e608fa2b6c30e9529adc714 Release 3.23 Refs #79, #363, #392, #393, #395, #396 2022-02-04T06:41:46Z 2022-02-04T06:41:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
089278b8dbe0cb3d41f27666d97b0096b750fbe2 rST fix, refs #1384 2021-06-26T22:49:07Z 2021-06-26T22:49:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
08947fa76433d18988aa1ee1d929bd8320c75fe2 Fix more broken base_url links Refs #1519, #838 2021-11-20T19:03:08Z 2021-11-20T19:03:08Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
08b4928a75faa1f2ba1c5b9908bcf2df4975a9d4 asgi-csrf>=0.6, refs #835 2020-07-01T01:18:19Z 2020-07-01T01:18:19Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09033c08bec8555e0e893e077afa10a7a75d7d35 Suggest --load-extension=spatialite, closes #1115 2020-11-29T20:13:16Z 2020-11-29T20:13:16Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
091441a4449beae559a8c0d007376dc85d3aa624 Fixed remaining places that needed datasette.urls, closes #1025 2020-10-20T05:21:19Z 2020-10-20T05:21:19Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09253817dea3c131553494f9b2eb9c03f94ae761 Fix for missing view_name bug, closes #716 2020-04-05T18:28:20Z 2020-04-05T18:28:20Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
092e1368edc4e7f4cb337a62eabd9a6e1245006b Fixed typo 2019-05-25T14:24:17Z 2019-05-25T14:24:17Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
09316835e609e2321dafa08d37d8f227521373f8 Implemented --tsv option, closes #41 2019-07-19T04:50:38Z 2019-07-19T04:50:38Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0934844c0b6d124163d0185fb6a41ba5a71433da request.post_vars() no longer discards empty values 2020-06-03T13:48:39Z 2020-06-03T13:48:39Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0949f0989c932bae59ec702a002fe521ca56570c emojis command, closes #47 2020-08-18T14:52:08Z 2020-08-18T14:52:08Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 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 85de645274a2cefaeda2a43f117f5e672fd8e2f9 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 15092 19864447
0991ea75cc7b265389aa8362414a305ba532d31a Renamed _timestamp to _now, refs #842, closes #871 2020-06-28T19:45:34Z 2020-06-28T19:47:28Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09a3479a5402df96489ed6cab6cc9fd674bf3433 New "startup" plugin hook, closes #834 2020-06-13T17:55:41Z 2020-06-13T17:55:41Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09bf3c63225babe8e28cde880ca4399ca7dbd78b Documentation for publish --secret, refs #787 2020-06-11T16:14:30Z 2020-06-11T16:14:30Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
09c3386f55f766b135b6a1c00295646c4ae29bec Applied Black, refs #237 2021-02-25T17:13:00Z 2021-02-25T17:13:00Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0a0cec3cf27861455e8cd1c4d84937825a18bb30 Release 1.12.1 2019-11-07T04:58:47Z 2019-11-07T04:58:47Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0a14a4846b29b4b60d153356ad926cbc461c45c7 Added plugin_config() method 2018-08-28T08:35:21Z 2018-08-28T08:35:21Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0a2dddccd7eb6cedae128c08931f14f12d5bce70 'github-to-sqlite repos' now accepts multiple usernames 2019-11-11T05:02:33Z 2019-11-11T05:02:33Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
0a47c376ba8c7143aeb05146643d6b26bb83e485 archive_app import for app.js 2021-08-21T20:50:14Z 2021-08-21T20:50:14Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0a8194e730f8ecdd9a5af1f6a8d5a889796d7dba sqlite-utils optimize command, .optimize() and .detect_fts() table methods 2019-01-25T04:35:51Z 2019-01-25T04:35:51Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 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 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 140912432 9599 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 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 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 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0ad3ce5e2d664c227d7045afafec46704f251a10 Use INTEGER for organization column, fixes #27 2020-04-18T00:18:45Z 2020-04-18T00:18:45Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 9599
0b0a431bff94d24866fc10d82dc91ab00287de2d Changelog for 2.0 release 2019-12-30T06:18:44Z 2019-12-30T06:18:44Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0b1af42ead3b3902347951180b3364ce1942da6e Link to my blog entry 2019-02-25T03:45:38Z 2019-02-25T03:45:38Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0b244d207a460d872cdac029d01deec784058858 Release 3.2.1 Refs #221 2021-01-12T23:22:53Z 2021-01-12T23:22:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0b5edd646926d6e01e3bf9f2897d072f4302ce2d Added basic tests using hypothesis, closes #180 2020-10-19T04:51:50Z 2020-10-19T04:51:50Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 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 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0b7b80bd40fe86e4d66a04c9f607d94991c45c0b Document the convert() with initialization pattern, closes #420 2022-03-25T20:07:29Z 2022-03-25T20:07:29Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0b84d52ab87d960d4b5e188052540518db2ea569 Release 0.10 2019-10-15T18:53:53Z 2019-10-15T18:53:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 9599
0b8a952cd5709ac27494b1694ca95188c89442ce Release 0.20.1 Refs #41 2020-04-01T04:31:23Z 2020-04-01T04:31:23Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 206156866 9599 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 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0b8e5981a37c0da75ce4f4e6b6b5275681e2e0c5 Typo fix 2018-05-20T21:30:48Z 2018-05-20T21:30:48Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0bb483ca5bee61c9f7d148b5755d2eed56001aca /-/static-plugins/PLUGIN_NAME/ now serves static/ from plugins Refs #214 2018-04-18T02:32:48Z 2018-04-18T02:32:48Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0bc49e938e1e3444df734f9178a9a317f68f9716 'sqlite-utils add-column name type' command, closes #15 2019-02-24T20:04:33Z 2019-02-24T20:04:33Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0bc5186b7bb4fc82392df08f99a9132f84dcb331 Tooltip and commas for byte length display, closes #1712 2022-04-12T18:44:12Z 2022-04-12T18:44:12Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0bc6ba503eecedb947d2624adbe1327dd849d7fe Release 0.3.1 Refs #8, #10 2021-02-11T22:38:21Z 2021-02-11T22:38:21Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 303218369 9599 9599
0bd41d4cb0a42d7d2baf8b49675418d1482ae39b Do not show default plugins on /-/plugins 2018-08-28T07:36:22Z 2018-08-28T07:36:22Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0be971c2801ab6369f5b887dc2a578f78fb6b3ef alter=True in a bunch more places, refs #11 2021-01-18T04:13:28Z 2021-01-18T04:13:28Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 205429375 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 197431109 9599 9599
0c064c5fe220b7b3d8dcf85b02b4e60452c47232 More things you can do with plugins 2020-06-05T03:10:40Z 2020-06-05T03:10:40Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0c1b8b7f96be874bb63801f69323960f277aa49a Use assertion to enforce <=999 columns 2019-07-28T11:41:57Z 2019-07-28T11:41:57Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0c2451e0690c5f4e6463a2f339b0a280e30ed806 Release 2.3 2020-02-08T23:56:16Z 2020-02-08T23:56:16Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0c27f10f9d2124f0f534c25612b58be20441c9d8 Updated plugin examples to include datasette-psutil 2020-06-13T23:41:26Z 2020-06-13T23:41:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0c36feb6ca5c3ffb9a6df4c8ea4bb732fcab74f4 .enable_fts() now works with columns with spaces in them, closes #90 2020-03-02T06:10:43Z 2020-03-02T06:10:43Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0c616f732cee79db80cad830917666f41b344262 Release 0.53 Refs #1132, #1135, #1133, #1138, #1137 2020-12-11T01:44:36Z 2020-12-11T01:44:36Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0c6745b70f95663f8ddf4309c578bd568eca75ec Whitespace fix 2019-02-24T18:42:27Z 2019-02-24T18:42:27Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0c756b8cd948bd69b7342c0d0e93bad4ff4e97b2 Added datasette-bplist plugin to ecosystem 2019-06-09T02:11:59Z 2019-06-09T02:11:59Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0c91e59d2bbfc08884cfcf5d1b902a2f4968b7ff datasette-leaflet-freedraw is an example of filters_from_request 2021-12-17T23:28:44Z 2021-12-17T23:55:06Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0ca5585fcb834122193e8e7186f926217b23cb8a Clarify why you would want transform_sql() 2020-09-23T20:16:01Z 2020-09-23T20:16:01Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0cdceb9244a21fbd1e70a6ca0a76b2ed2ce4dd3f github-to-sqlite commits command, refs #17 2020-03-10T21:55:36Z 2020-03-10T21:55:36Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 207052882 9599 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 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0cfd7ce59d9018eb07af8f9e20f7d04308c9d01d Allow WITH query (previously we required SELECT at start) Fixes #161 2017-12-04T04:51:31Z 2017-12-04T04:51:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0d10402f7b0428c6bb275a106b628298c6d0201d table.create_index(..., analyze=True), refs #378 2022-01-10T20:00:24Z 2022-01-10T20:00:24Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0d1763fb2fdabcdde321646721703df1dfcb8597 More datasette.urls usage, refs #1025 2020-10-20T04:24:47Z 2020-10-20T04:24:47Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0d2a47eab99f625be7ef4f77c6e9803177d13a2c .reset_counts() method and reset-counts command, closes #219 2021-01-03T20:59:31Z 2021-01-03T20:59:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0d2e4f49f324de01bcd8257d0adeea3ebf391791 db.schema and 'sqlite-utils schema' command, closes #268 2021-06-11T20:51:49Z 2021-06-11T20:51:49Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0d339a4897c808903e34fa6be228cdaaa5a29c55 Removed text about executing SQL, refs #1384 2021-06-26T23:04:39Z 2021-06-26T23:04:39Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0d3479ba320e5a5d15f029838744c5219a9e2987 Release notes for 0.13 2017-11-25T03:32:24Z 2017-11-25T03:32:24Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0d4145d0f4d8b2a7edc1ba4aac1be56cd536a10a Additional test for #625 2021-12-16T20:30:31Z 2021-12-16T20:30:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0d5cc20aeffa3537cfc9296d01ec24b9c6e23dcf Revert "asyncio_run helper to deal with a 3.10 warning, refs #1482" This reverts commit 98dcabccbbf9c0800efa74df9b7d1fee81c3cd0c. 2021-10-10T01:25:33Z 2021-10-10T01:25:33Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0d63128c40aec15a958dddf181c13e0db1c7908b Preparing v0.2, first release to PyPI 2018-07-29T00:42:41Z 2018-07-29T00:42:41Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 140912432 9599 9599
0d7ba1ba676828dc7c8dda78ebe7921f7986fc18 Default to _labels=on on JSON/CSV links with foreign keys, refs #266 2018-06-17T22:56:55Z 2018-06-17T22:56:55Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0da7f49b24e429e81317e370cb01de941f1b873e Rename RequestParameters to MultiParams, refs #799 2020-06-05T17:52:50Z 2020-06-05T17:52:50Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0dad111d24856ee6012850dac19929a48dc0a59f New introspection endpoint: /-/databases - closes #470 Refs #419 and #465 2019-05-16T14:49:34Z 2019-05-16T14:49:34Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0dca784dbe6b75de6e4c0da4869c0b2b9574dde4 Release 3.1.1 Refs #209. Also updated copyright footer in documentation. 2021-01-01T23:56:20Z 2021-01-01T23:56:20Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0df7f3d1f5db162375415e42c8b14c6bd404a789 Release 0.4 Refs #3 #9 #10 #11 2020-09-03T21:02:46Z 2020-09-03T21:02:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 197431109 9599 19864447
0dfb9241718139f8ad626d22aac25bcebd3a9c9c Temporarily reverting buildx support I need to push a container for 0.57 using this action, and I'm not ready to ship other architecture builds until we have tested them in #1344. 2021-06-05T22:55:07Z 2021-06-05T22:55:07Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0e1e89c6ba3d0fbdb0823272952cf356f3016def Release 0.51a1 Refs #1056, #1039, #998, #1045, #1033, #1036, #1034, #976, #1057, #1058, #1053, #1064, #1066 2020-10-30T05:34:52Z 2020-10-30T05:35:23Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0e49842e227a0f1f69d48108c87d17fe0379e548 datasette/actor_auth_cookie.py coverae to 100%, refs #841 2020-06-13T18:29:14Z 2020-06-13T18:29:14Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0e58ae7600212c075f5b8ae4b52d2af0e1acd4f1 Release 0.50.2 Refs #1011 2020-10-10T03:53:47Z 2020-10-10T03:53:47Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0e5b6025c6f9823ff81aa8aae1cbff5c45e57baf Can now fetch data from Foursquare API, closes #1 Also made createdAt field the original unix timestamp and added a new created field which is the ISO formatted version. 2019-08-30T18:16:20Z 2019-08-30T18:19:20Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 205429375 9599 9599
0e5f51adfeff24a120bbdf0e5ac5669b18124400 Three more news items 2018-03-30T07:03:45Z 2018-03-30T07:03:45Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0e60f3c80cd6df5c177d8405afc54d014addebd0 Better error message if table has no columns, closes #424 2022-04-13T22:39:48Z 2022-04-13T22:39:48Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0e62744da9a429093e3409575c1f881376b0361f Correct import path for AlterError exception 2020-09-02T20:29:46Z 2020-09-02T20:29:46Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0e797033f96a1c61b173a3d8af2ff36905687a2e .transform() on rowid (non-pk) tables bug fix, closes #284 2021-06-19T15:28:26Z 2021-06-19T15:28:26Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0e7b461eb3e925aef713206c15794ceae9259c57 Fixed typo 2019-08-04T04:13:31Z 2019-08-04T04:13:31Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0eda638d81280c7e585db071c35444e14b0b00f6 table.exists() now a documented method, closes #83 2020-02-08T23:56:03Z 2020-02-08T23:56:03Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599
0f1b951c5131d16f3c8559a8e4d79ed5c559e3cb Applied Black 2020-09-18T22:20:55Z 2020-09-18T22:20:55Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 197431109 9599 9599
0f1e47287cf2185e140bd87a03c985c2a7afb450 Fixed bug with detect_fts for table with single quote in name, closes #1257 2021-06-02T03:27:04Z 2021-06-02T03:27:04Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0f2626868bd635f44f2c04d57a5e8ced1229737e Much improved column menu display logic, refs #981 * Menu links now take into account existing querystring * No longer shows facet option for primary key columns * Conditionally displays sort/sort-desc if already sorted * Does not show facet option if already faceted by this 2020-09-30T23:01:19Z 2020-09-30T23:01:37Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0f41db1ba8a8a49a4adc1046a25ccf32790e863f Avoid error sorting by relationships if related tables are not allowed Refs #1306 2021-06-02T04:25:27Z 2021-06-02T04:25:27Z 0645c24f7846578adea9d68f3e37a7e15a9bd1dd cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 416374 19864447
0f782dd8dfd7c53a9c20bbd2cb8734bb806d928b Additional test asserts 2018-04-16T20:22:04Z 2018-04-18T01:13:02Z cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b 2946d096d0cdefdc017559e6b57e87658736e843 107914493 45057 9599
0f8b042b47ab4516829a2e56a2668fff0c5329e6 Release 2.11 Refs #118, #120 2020-07-08T17:28:29Z 2020-07-08T17:28:29Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 140912432 9599 19864447
0f8e91c68f2d2ad48efc8324b12762bf8b58facd Documentation fix 2020-02-26T07:13:39Z 2020-02-26T07:13:39Z 13ae486343ea6454a93114c6f558ffea2f2c6874 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
0fa177269767e5e55c863382333fde627d2b7074 Allow ?sql= argument against database e.g. /database-234324?sql=select * from table limit 1 2017-10-24T02:48:56Z 2017-10-24T02:48:56Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0fc8afde0eb5ef677f4ac31601540d6168c8208d Changelog for 0.29.3 release 2019-09-03T00:40:53Z 2019-09-03T00:40:53Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
0fdbf004843850f200e077a3c87427fe16c18b85 Rework the `--static` documentation Rework the `--static` documentation to better differentiate between the filesystem and serving locations. Closes #1457 Co-authored-by: Simon Willison <swillison@gmail.com> 2021-10-14T18:39:55Z 2021-10-14T18:39:55Z 3674171304d76a7883c9278baae6eb636e00e08d cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 51016 19864447
0fe0f476a73ddbb3fea879bdb6bfef3ba4b97768 Fix for mypy error, closes #396 Should help tests pass for #395 and #79 2022-02-04T06:10:09Z 2022-02-04T06:10:28Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 140912432 9599 9599