2,772 rows

View and edit SQL

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
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
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
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
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
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
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
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
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
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
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
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
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
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
0d3479ba320e5a5d15f029838744c5219a9e2987 Release notes for 0.13 2017-11-25T03:32:24Z 2017-11-25T03:32:24Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0d63128c40aec15a958dddf181c13e0db1c7908b Preparing v0.2, first release to PyPI 2018-07-29T00:42:41Z 2018-07-29T00:42:41Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 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 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0da7f49b24e429e81317e370cb01de941f1b873e Rename RequestParameters to MultiParams, refs #799 2020-06-05T17:52:50Z 2020-06-05T17:52:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0dad111d24856ee6012850dac19929a48dc0a59f New introspection endpoint: /-/databases - closes #470 Refs #419 and #465 2019-05-16T14:49:34Z 2019-05-16T14:49:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0dca784dbe6b75de6e4c0da4869c0b2b9574dde4 Release 3.1.1 Refs #209. Also updated copyright footer in documentation. 2021-01-01T23:56:20Z 2021-01-01T23:56:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0df7f3d1f5db162375415e42c8b14c6bd404a789 Release 0.4 Refs #3 #9 #10 #11 2020-09-03T21:02:46Z 2020-09-03T21:02:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep-beta 197431109 simonw 9599 web-flow 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 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 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 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0e49842e227a0f1f69d48108c87d17fe0379e548 datasette/actor_auth_cookie.py coverae to 100%, refs #841 2020-06-13T18:29:14Z 2020-06-13T18:29:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0e58ae7600212c075f5b8ae4b52d2af0e1acd4f1 Release 0.50.2 Refs #1011 2020-10-10T03:53:47Z 2020-10-10T03:53:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 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 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 swarm-to-sqlite 205429375 simonw 9599 simonw 9599
0e5f51adfeff24a120bbdf0e5ac5669b18124400 Three more news items 2018-03-30T07:03:45Z 2018-03-30T07:03:45Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
0e62744da9a429093e3409575c1f881376b0361f Correct import path for AlterError exception 2020-09-02T20:29:46Z 2020-09-02T20:29:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0e797033f96a1c61b173a3d8af2ff36905687a2e .transform() on rowid (non-pk) tables bug fix, closes #284 2021-06-19T15:28:26Z 2021-06-19T15:28:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0e7b461eb3e925aef713206c15794ceae9259c57 Fixed typo 2019-08-04T04:13:31Z 2019-08-04T04:13:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0eda638d81280c7e585db071c35444e14b0b00f6 table.exists() now a documented method, closes #83 2020-02-08T23:56:03Z 2020-02-08T23:56:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0f1b951c5131d16f3c8559a8e4d79ed5c559e3cb Applied Black 2020-09-18T22:20:55Z 2020-09-18T22:20:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 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 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 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 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 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 Guy Freeman 0645c24f7846578adea9d68f3e37a7e15a9bd1dd GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 slygent 416374 web-flow 19864447
0f782dd8dfd7c53a9c20bbd2cb8734bb806d928b Additional test asserts 2018-04-16T20:22:04Z 2018-04-18T01:13:02Z Russ Garrett cd9d55c7c0a7cc0ee69155676fd5e9fc6e1b884b Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 russss 45057 simonw 9599
0f8b042b47ab4516829a2e56a2668fff0c5329e6 Release 2.11 Refs #118, #120 2020-07-08T17:28:29Z 2020-07-08T17:28:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 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
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 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
0fc8afde0eb5ef677f4ac31601540d6168c8208d Changelog for 0.29.3 release 2019-09-03T00:40:53Z 2019-09-03T00:40:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0fe3b38290e1bb2d92746d90318d8662b57218bd Added db-to-sqlite to "Related projects" 2019-06-29T21:34:24Z 2019-06-29T21:34:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
0fe96bc50fb3d7b1c7e4577db0ddf207eaeebbb9 Release 0.2 2019-09-14T21:31:17Z 2019-09-14T21:31:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
100911b9cfaa7a555065f99bd41ad12232fb273c Applied Black, refs #21 2020-09-17T22:55:27Z 2020-09-17T22:55:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
105a2c10fdb5134e7ba141e872636aee47cdcf1d Fix z-index issue with dropdown menu, closes #1052 2020-10-26T02:19:21Z 2020-10-26T02:19:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
107d0887a61d2fb3d61e9471863ad665633c321b datasette publish heroku now uses Python 3.8.6 2020-10-08T23:22:11Z 2020-10-08T23:22:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
107d47567dedd472eebec7f35bc34f5b58285ba8 Black 2019-07-04T05:56:13Z 2019-07-04T05:56:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1091a9cbd804504efa8e1126226759e736e3ccdf Add sqlite-utils memory to the README, refs #272 2021-06-19T03:14:12Z 2021-06-19T03:14:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
109c5a430d53fe38b1300e0daa20f5cef047a08e Update janus requirement from ~=0.4.0 to >=0.4,<0.6 (#734) Updates the requirements on [janus](https://github.com/aio-libs/janus) to permit the latest version. - [Release notes](https://github.com/aio-libs/janus/releases) - [Changelog](https://github.com/aio-libs/janus/blob/master/CHANGES.rst) - [Commits](https://github.com/aio-libs/janus/compare/v0.4.0...v0.5.0) Signed-off-by: dependabot-preview[bot] <support@dependabot.com> Co-authored-by: dependabot-preview[bot] <27856297+dependabot-preview[bot]@users.noreply.github.com> 2020-05-04T16:48:03Z 2020-05-04T16:48:03Z dependabot-preview[bot] 2edd38cb3801aa07f709f083eba7cbe4f16e0978 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 dependabot-preview[bot] 27856297 web-flow 19864447
10a34f995c70daa37a8a2aa02c3135a4b023a24c Removed rogue print() call 2018-04-16T15:38:09Z 2018-04-16T15:38:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10b9d85edaaf198879344aa1c498000cfb27dff8 datasette-csvs on Glitch now uses sqlite-utils It previously used csvs-to-sqlite but that had heavy dependencies. See https://support.glitch.com/t/can-you-upgrade-python-to-latest-version/7980/33 2019-11-09T02:15:13Z 2019-11-09T02:15:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
10c35bd371faaa0f3c98067c08f26334c9f5ea52 urls.static_plugins() method, closes #1033 Also documented how to package static assets and templates in plugins, closes #575 2020-10-24T20:03:40Z 2020-10-24T20:03:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
10c6fbc3689311091a18ad4f8d1098e6761c35bc Applied Black 20.8b1, refs #142 2020-08-28T22:30:57Z 2020-08-28T22:30:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
10ce9ce3bcfd1ea967df8da63a4774f4afef3035 Include templates/ in MANIFEST, refs #930 2020-08-12T02:34:39Z 2020-08-12T02:34:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
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
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

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