2,203 rows where committer = 9599 sorted by message

View and edit SQL

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

sha message ▼ author_date committer_date raw_author raw_committer repo author committer
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
fba8ff6e76253af2b03749ed8dd6e28985a7fb8f "$env": "X" mechanism now works with nested lists, closes #837 2020-06-12T00:21:48Z 2020-06-12T00:21:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c0d1b4c32297453adaa4c159edee9be0a9617f2b "datasette inspect foo.db" now just calculates table counts Refs #462 * inspect command now just outputs table counts * test_inspect.py is now only tests for that CLI command * Updated some relevant documentation * Removed docs for /-/inspect since that is about to change 2019-05-11T21:36:57Z 2019-05-11T21:36:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1fb518618c1c246c58daf5085247b430f2aea29f "datasette publish heroku" improvements * Fixed bug where --title= didn't work if -m not provided * Now using Python 3.6.6 instead of Python 3.6.3 2018-07-26T05:43:01Z 2018-07-26T05:43:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f853d5592ec7f901a50381de22a26a9ab098f885 "python3 -m pip" is clearer (thanks @jaap3) (#368) 2019-05-03T18:18:42Z 2019-05-03T18:18:42Z Jaap Roes 93b11f15fd4dc15002baf3d9160dc6eb928bd883 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 jaap3 48517 simonw 9599
236aa065b2ecfbe5a77870689bae432b89a48b23 "sort" and "sort_desc" metadata properties, closes #702 2020-03-22T02:28:35Z 2020-03-22T02:28:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
309ae84336fd1d0262cad49adef7ce3dc72c531c '-f' must now always be specified as '--fmt', refs #194 2020-11-07T00:17:15Z 2020-11-07T00:19:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
51d788114035458d8f860d9ea6d74078e6c0ea0d 'Show all columns' menu item if any _col= set, closes #1341 Refs #615 2021-05-27T04:31:12Z 2021-05-27T04:31:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
9680a0291c7f5692076c468985c71f7fc6f5f199 'Soundness check' is better 2020-09-08T22:24:39Z 2020-09-08T22:24:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
623c552ff4e2eda9cc710063a7cc674aa49264f4 'Try Datasette without installing anything using Glitch' Also new 'Play with a live demo' section, both at the top of the Getting Started documentation page. https://datasette.readthedocs.io/en/latest/getting_started.html Closes #464 2019-05-16T04:57:26Z 2019-05-16T04:57:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
bd1db56936d7aa09f5ee87ac8146e19b71ae8b42 'Usage: datasette', not 'Usage: cli' - refs #336 2018-07-24T16:03:07Z 2018-07-24T16:03:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
47032636b55718dd711670f19b753f4ada9e8f2f 'datasette serve -i immutable.db' option, refs #419 2019-03-17T23:25:15Z 2019-03-17T23:25:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
8c9a9498159c4dfa1dff0593427cc3ee7df9a83c 'github-to-sqlite repos' command, closes #3 2019-09-17T00:17:42Z 2019-09-17T00:17:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 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
b320f58d13e510d51e07187c8a75db856205b88f 'publish now' uses force_https_urls:on - closes #333 2018-07-24T01:51:43Z 2018-07-24T01:51:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1eb04e2ecb764d2e76a0e5731e16c3833df04c93 'releases' command to fetch releases, closes #11 2019-11-09T22:56:53Z 2019-11-09T22:56:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 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
ce042ff1f0a398d9ad46532636e438dbe4efc0f1 'sqlite-utils enable-counts' command, closes #214 2021-01-03T04:26:39Z 2021-01-03T04:26:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
9e74289397e28f797290158c27e1dca2083c4e95 'sqlite-utils insert tablename file.json' command 2019-01-25T05:06:41Z 2019-01-25T05:06:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
5b246d17a0b1c8b5e122da2f1d9974f53b50978e 'sqlite-utils triggers' command, closes #218 2021-01-03T03:03:15Z 2021-01-03T03:03:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
13426d1b232b1a570ac81717be351026ca36cfff --accept option for get, refs #50 2020-10-19T05:00:50Z 2020-10-19T05:00:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
3e21277c76b86b54fb5cc8dd41a3eb14b6164947 --attach and --sql for users-lookup, refs #8 2019-09-08T21:24:27Z 2019-09-08T21:24:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
1e6995a362e5b8f23331aafb84e631392eb81492 --auth is now optional, closes #9 2019-11-11T05:30:41Z 2019-11-11T05:30:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c3aba4aa986fdba39705a35de02d446db80a26b8 --cors for /name.db downloads, refs #1057 2020-10-27T20:39:07Z 2020-10-27T20:39:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1b666f9315d4ea6bb332b2e75e48480c26100199 --delimiter and --quotechar, closes #223 2021-02-06T01:34:47Z 2021-02-06T01:34:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
2c541fac352632e23e40b0d21e3f233f7a744a57 --encoding option for non-utf8 CSV/TSV, closes #182 2020-10-16T17:18:46Z 2020-10-16T17:18:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
7684bbf0976431371541bc91136779b4948dbabf --encoding option for sqlite-utils memory, closes #280 Refs #272 2021-06-18T15:29:41Z 2021-06-18T15:29:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
45414f8412a8333d70a11bf8f0677ed9efc3c1fc --get now calls startup() plugin hooks, closes #934 2020-08-15T20:38:15Z 2020-08-15T20:52:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
bba6e241be0e4aa596da0d5d4ae787d9d4cde92e --ignore for sqlite-utils drop-table and drop-view, closes #237 2021-02-25T17:11:37Z 2021-02-25T17:11:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ddd3d3ac3587afa0e67cdbe65be803d5c8945090 --image-url-prefix and --image-url-suffix, closes #24 2020-05-19T22:27:24Z 2020-05-19T22:27:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-photos 256834907 simonw 9599 simonw 9599
c3f7fc6925c6c34d64c26d436356ab917da0917d --install=py-gfm 2020-03-25T05:17:20Z 2020-03-25T05:17:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
251e4730412210e7fdb1efd476c730ed3ff10e81 --json-cols option for outputting nested JSON, closes #20 2019-05-25T00:56:44Z 2019-05-25T00:56:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
cef9a9a8701af86cc7df8b7939398185f0a76f5f --limit= mechanism plus new limits for facets Replaced the --max_returned_rows and --sql_time_limit_ms options to "datasette serve" with a new --limit option, which supports a larger list of limits. Example usage: datasette serve --limit max_returned_rows:1000 \ --limit sql_time_limit_ms:2500 \ --limit default_facet_size:50 \ --limit facet_time_limit_ms:1000 \ --limit facet_suggest_time_limit_ms:500 New docs: https://datasette.readthedocs.io/en/latest/limits.html Closes #270 Closes #264 2018-05-18T05:08:26Z 2018-05-18T05:08:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7e9aad7e1c09d1cf80d0b4d17d6157212a4b857d --load-extension option for sqlite-utils query, closes #134 2020-08-21T20:54:11Z 2020-08-21T20:54:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
21ff60e3b119af48bb9b8c9635bc701576dd1b1d --load-extension= for many more commands, closes #137 Also added --load-extension=spatialite shortcut, closes #136 2020-10-16T19:14:22Z 2020-10-16T19:14:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
6aa5886379dd9017215904fb28567b80018902f9 --load-extension=spatialite shortcut, closes #1028 2020-10-19T22:37:31Z 2020-10-19T22:37:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ddd11b3ddd886d16867c134d73105895c5726cc7 --memory option for publish cloudrun, refs #694 2020-03-05T23:34:21Z 2020-03-05T23:34:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
50d2096f5ed718df5a6704c2ea265f44d6e9907f --no-headers option for sqlite-utils insert --csv, closes #228 2021-02-14T22:25:03Z 2021-02-14T22:25:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
208f56fbaf173fdd8cb03a840e218f85d414a144 --not-null and --default options to insert/update, closes #24 2019-06-13T06:30:16Z 2019-06-13T06:30:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
2fed87da6ea990d295672e4db2c8ae97b787913e --not-null-default and not_null_default=, refs #24 2019-06-13T01:35:02Z 2019-06-13T01:35:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
bc8409941fb609eba646c29ae3ec40b8cdd122a4 --raw option, refs #123 2020-07-26T16:43:45Z 2020-07-26T16:43:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
eac08f0dfc61a99e8887442fc247656d419c76f8 --reload now also reloads if databases change on disk 2018-12-20T15:51:08Z 2018-12-20T15:51:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
515eaa8ccba0603de5b14679b74402f3ddf02bd7 --reload now reloads on metadata changes too 2017-12-07T16:42:28Z 2017-12-07T16:42:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
9f3d4aba31baf1e2de1910a40bc9663ef53b94e9 --root option and /-/auth-token view, refs #784 2020-06-01T01:03:17Z 2020-06-01T01:16:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c53bd21b66b24558b0e219f93eceed4021c36939 --service github-to-sqlite 2020-03-25T05:09:04Z 2020-03-25T05:09:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
fced2a9b67d2cbdf9817f1eb75f7c28e413c963b --since and --since_id options for user-timeline, closes #19 Refs #20 Also added some initial rate limit error handling code. 2019-10-16T19:12:41Z 2019-10-16T19:12:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
e981ac7d4d1e1603257369eb5edba0fc4fdf5ae9 --static option for datasette serve You can now tell Datasette to serve static files from a specific location at a specific mountpoint. For example: datasette serve mydb.db --static extra-css:/tmp/static/css Now if you visit this URL: http://localhost:8001/extra-css/blah.css The following file will be served: /tmp/static/css/blah.css Refs #160 2017-12-03T16:33:36Z 2017-12-03T16:33:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
afee15f04b060a557897fa876f6e5d37f6d898cb --tsv output option, closes #193 2020-11-07T00:09:42Z 2020-11-07T00:09:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
180c7a5328457aefdf847ada366e296fef4744f1 --uds option for binding to Unix domain socket, closes #1388 2021-07-10T23:37:30Z 2021-07-10T23:37:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
db1e6bc182d11f333e6addaa1a6be87625a4e12b --version-note for datasette, datasette publish and datasette package This is a relatively obscure new command-line argument that helps solve the problem of showing accurate version information in deployed instances of Datasette even if they were deployed directly from source code. You can pass --version-note to datasette publish and package and it will then in turn be passed to datasette when it starts: datasette --version-note=hello fixtures.db Now if you visit /-/versions.json you will see this: { "datasette": { "note": "hello", "version": "0+unknown" }, "python": { "full": "3.6.5 (default, Jun 6 2018, 19:19:24) \n[GCC 6.3.0 20170516]", "version": "3.6.5" }, ... } I plan to use this in some Travis CI configuration, refs #313 2018-06-17T20:14:55Z 2018-06-17T21:19:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
433992eebd54af69c36c4491f0e1a6b0ebc4d2ca -d option to run indexer only against specific databases 2020-09-09T00:37:21Z 2020-09-09T00:37:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
f5dbe61a4568c0915ec6be820095c2960cf0857c -o now opens to most relevant page, closes #976 2020-10-26T05:06:20Z 2020-10-26T05:06:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
814d4a7f90991be865d38aac45ff12e36df1c67d -p for passing named params to query, closes #124 2020-07-27T03:53:51Z 2020-07-27T03:53:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
3ffb8f3b98252531d11897fd431711e9b8045ace .add_database() and .remove_database() methods, refs #671 Also made a start on the Datasette class documentation, refs #576 2020-02-14T01:25:27Z 2020-02-14T01:27:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7ac4936cec87f5a591e5d2680f0acefc3d35a705 .add_message() now works inside plugins, closes #864 Refs #870 2020-06-29T00:25:35Z 2020-06-29T00:25:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b6840646baf97e4d324d2c53c036ffeeedab9822 .add_missing_columns() is now case insensitive, closes #221 2021-01-12T23:17:27Z 2021-01-12T23:17:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
178b7e8749f14300363af5961e9f8964595264d9 .csv now links to .blob downloads Closes #1063, closes #1034 2020-10-29T22:47:32Z 2020-10-29T22:47:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
29a3896fe1e09d5c35a90d55690c9f71fae81e24 .database_url(database) no longer needs inspect, refs #420 2019-03-31T23:55:38Z 2019-03-31T23:55:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
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
ecb50c8f76535754f76bffdf77bf99e8f829b832 .enable_fts(..., replace=True) argument, closes #160 2020-09-20T22:05:46Z 2020-09-20T22:05:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
c611ed80d2e9f721fc7848fd74e6e6baebe5adde .indexes property for introspecting indexes 2018-08-01T01:31:29Z 2018-08-01T01:31:29Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
64799df78b14a12084d1def91c561abdcbcd8773 .optimize() no longer cleans up _docsize This isn't necessary any more since the new .rebuild_fts() method can achieve the same thing. Refs #155, #153 2020-09-08T22:18:12Z 2020-09-08T22:18:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
03933b30841470d05769807828cdcfffbb7a5780 .prettierrc, refs #1166 2020-12-31T21:25:44Z 2020-12-31T21:25:44Z 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
7d0f668556b6d9a6c3d70a7b8a07a542857bbb56 .resolve_db_name() and .execute() work without inspect Refs #420 2019-03-31T23:51:52Z 2019-03-31T23:51:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
125c625fbc46244a4b4025732e1526fb13c55843 .rows_where(..., order_by=) argument, closes #76 2020-04-16T03:12:55Z 2020-04-16T03:12:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
7c22a64fb60fdf50c8a5f521ecd2c320143341d5 .search() now works differently for FTS4 v.s. FTS5 2020-11-05T18:01:58Z 2020-11-06T18:30:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
d411fba1f4124047429ac9d1175a04b36bf5bee9 .search() works for FTS4, yields dicts Closes #198, refs #197 2020-11-06T18:23:16Z 2020-11-06T18:30:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
c5a798c15fa6ee694890c5f8e87e2c7a6001a4f4 .search_sql() fully respects columns=, closes #201 Refs #192 and #197 2020-11-08T16:53:53Z 2020-11-08T16:53:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
515d362ad60c3dc16272c4fdca932cf0a0e9dafa .table_names and .tables properties plus expanded docs 2018-08-01T00:35:36Z 2018-08-01T00:35:36Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
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
bc9c4db34b815f5385abbf4bb491bab0e10779db .update(...) with no update argument sets last_pk 2019-07-28T14:59:52Z 2019-07-28T14:59:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
489eda92bc3b528c90b76ac90a3f9b78c8ea02a3 .upsert() and upsert_all() require pk=, closes #73 2020-01-05T17:20:11Z 2020-01-05T17:20:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
12c0bc09cc4bf9addde20f3d46613de11f27c641 /-/allow-debug tool, closes #908 2020-07-24T22:54:41Z 2020-07-24T22:55:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
807de378d08752a0f05bb1b980a0a62620a70520 /-/databases and homepage maintain connection order, closes #1216 2021-06-02T03:03:07Z 2021-06-02T03:10:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
cccea85be6aaaeadb31f3b588ec7f732628815f5 /-/databases sorts alphabetically Should fix test failure in Python 3.5 2019-05-16T14:56:13Z 2019-05-16T14:56:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
22d932fafc3fa9af5a8f5eeab908688eaeb177ea /-/logout page for logging out of ds_actor cookie Refs #840 2020-06-29T04:17:30Z 2020-06-29T04:17:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a7137dfe069e5fceca56f78631baebd4a6a19967 /-/plugins now shows details of hooks, closes #794 Also added /-/plugins?all=1 parameter to see default plugins. 2020-06-02T21:49:28Z 2020-06-02T21:49:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
04d21ccd089fcaf7a2b535d217fc541ab19aa54b /-/versions now includes SQLite fts_versions, closes #252 2018-05-11T13:19:25Z 2018-05-11T13:19:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
335f26a0f7f00134f02ae0f001946580b0edecf5 /fixtures/magic_parameters demo, refs #842 2020-06-28T03:11:01Z 2020-06-28T03:11:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ac60ce9331dc557837d879680611aca4bd6c28be 0.21.1 bugfix release 2020-04-30T18:20:43Z 2020-04-30T18:20:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
5d6252788230d168ba09f379d1d2af867e3302ab 0.22.1 bugfix release 2018-05-23T14:00:01Z 2018-05-23T14:00:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
63aac537f238239d5fb7f4934545404d37d874f6 1,442 format for facet counts, refs #255 2018-05-15T12:14:14Z 2018-05-16T15:27:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 simonw 9599 simonw 9599
86bd2bba689e25f09551d611ccfbee1e069e5b66 1.2.2 release notes 2019-06-26T04:23:45Z 2019-06-26T04:23:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
89c4ddd4828623888e91a1d2cb396cba12d4e7b4 403 for static directory listing, closes #740 2020-04-27T18:29:04Z 2020-04-27T18:29:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
97ae66ccabd0e2eae5a7880ac93bd2ac26bb355e 404s ending in slash redirect to remove that slash, closes #309 2018-06-21T15:13:07Z 2018-06-21T15:13:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
06a826c3188af82f27bb6b4e09cc89b782d30bd6 :fire: Removes DS_Store (#81) * :fire: Removes .DS_Store Signed-off-by: Jeff Triplett <jeff.triplett@gmail.com> * :snowflake: Adds .DS_Store to gitignore Signed-off-by: Jeff Triplett <jeff.triplett@gmail.com> 2017-11-13T22:16:54Z 2017-11-13T22:16:54Z Jeff Triplett 207bb2132044fa5a4fe28a579f7588c2eee6e391 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 jefftriplett 50527 simonw 9599
c5068a0972651b3e359ebc2d6c1486b8b7d2c242 :pencil: Updates my_database.py to my_database.db (#9) 2019-02-24T03:55:04Z 2019-02-24T03:55:04Z Jeff Triplett 207bb2132044fa5a4fe28a579f7588c2eee6e391 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 jefftriplett 50527 simonw 9599
a5792a8c61b9bb6a7a5295c8ec87c2567a5e39a2 <th> now gets class="col-X" - plus added col-X documentation Refs #209 2018-04-18T02:11:11Z 2018-04-18T02:11:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
9789b94da48183dabf105c6419bdcde2634b36a5 ?_facet_size=100 parameter, closes #1332 2021-05-23T00:34:33Z 2021-05-23T00:34:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7e983fede679624210c21387d5c4a2c19c141abd ?_facet_size=max, ... now links to that, closes #1337 Refs #1332 2021-05-27T16:00:58Z 2021-05-27T16:00:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a5881e105a02830d26f07e98177248d5910893da ?_filter_column=col&_filter_op=isnull__1 redirect if filter_op contains a __ the value is set to the right hand side. e.g. ?_filter_column=col&_filter_op=isnull__1&_filter_value=x Redirects to: ?col__isnull=1 Refs #86 2017-11-19T20:33:30Z 2017-11-19T20:33:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
386fb11d42767039bb2b389ce98996673d780a42 ?_filter_column=col&_filter_op=op&_filter_value=value redirect Part of implementing the filters UI (refs #86) - the following: /trees/Trees?_filter_column=SiteOrder&_filter_op=gt&_filter_value=2 Now redirects to this; /trees/Trees?SiteOrder__gt=2 2017-11-19T20:25:29Z 2017-11-19T20:25:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
db74cf0144df3e2a017c40a3a36ff5e1a78d7e92 ?_fts_table= and ?_fts_pk= arguments, closes #428 2019-04-12T04:21:17Z 2019-04-12T04:21:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
db9dbfb816e1e9e4a0845884035eeaeb3110668e ?_hash=1 no longer respected for mutable databases Closes #471, refs #419 2019-05-16T15:10:25Z 2019-05-16T15:10:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
700d83d8adfeb3859ebc93828951e5048cb0e425 ?_json_infinity=1 for handling Infinity/-Infinity - fixes #332 2018-07-24T03:07:57Z 2018-07-24T03:07:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ed631e690b81e34fcaeaba1f16c9166f1c505990 ?_labels= and ?_label=COL to expand foreign keys in JSON/CSV These new querystring arguments can be used to request expanded foreign keys in both JSON and CSV formats. ?_labels=on turns on expansions for ALL foreign key columns ?_label=COLUMN1&_label=COLUMN2 can be used to pick specific columns to expand e.g. `Street_Tree_List.json?_label=qSpecies&_label=qLegalStatus` { "rowid": 233, "TreeID": 121240, "qLegalStatus": { "value" 2, "label": "Private" } "qSpecies": { "value": 16, "label": "Sycamore" } "qAddress": "91 Commonwealth Ave", ... } The labels option also works for the HTML and CSV views. HTML defaults to `?_labels=on`, so if you pass `?_labels=off` you can disable foreign key expansion entirely - or you can use `?_label=COLUMN` to request just specific columns. If you expand labels on CSV you get additional columns in the output: `/Street_Tree_List.csv?_label=qLegalStatus` rowid,TreeID,qLegalStatus,qLegalStatus_label... 1,141565,1,Permitted Site... 2,232565,2,Undocumented... I also refactored the existing foreign key expansion code. Closes #233. Refs #266. 2018-06-16T22:18:57Z 2018-06-16T22:18:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c5ae1197a208e1b034c88882e3ac865813a40980 ?_nofacets=1 option, closes #1350 2021-05-31T02:39:14Z 2021-05-31T02:39:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
0331666e346c68b86de4aa19fbb37f3a408d37ca ?_search=x now works directly against fts virtual table Closes #135 2017-11-20T06:18:07Z 2017-11-20T06:18:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
2565d623af6222f3ed1c630f753b5f95ad749d49 ?_shape=array experimental feature 2018-05-01T17:40:33Z 2018-05-02T00:20:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 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]);