mirror
/
datasette
kopia lustrzana https://github.com/simonw/datasette
1
0
Forkuj 0
Kod Zgłoszenia Packages Projekty Wydania Wiki Aktywność
2 382 Commity
134 Gałęzie
158 Tagi
6,5 GiB
Wykres commitów

915 Commity (python-3.8-minimum)

Autor SHA1 Wiadomość Data
Simon Willison c5ae1197a2 ?_nofacets=1 option, closes #1350 2021-05-30 22:39:14 -04:00
Simon Willison 4545120c92 Test and docs for ?_facet_size=max, refs #1337 2021-05-27 09:04:26 -07:00
Simon Willison f1c29fd6a1
?_col=/?_nocol= to show/hide columns on the table page 
Closes #615

* Cog icon for hiding columns
* Show all columns cog menu item
* Do not allow hide column on primary keys
* Allow both ?_col= and ?_nocol=
* De-duplicate if ?_col= passed multiple times
* 400 error if user tries to ?_nocol= a primary key
* Documentation for ?_col= and ?_nocol=
 2021-05-26 21:17:43 -07:00
Simon Willison c0a748e5c3
Markup fix, refs #1320 2021-05-24 11:15:15 -07:00
Simon Willison 56af118fc1
How to apt-get install in Docker container, refs #1320 2021-05-24 11:14:45 -07:00
Simon Willison 2bd9d54b27 Fix Jinja warnings, closes #1338, refs #1331 2021-05-23 18:41:50 -07:00
Simon Willison a443dba82f Release 0.57a0 
Refs #1281, #1282, #1289, #1290, #1308, #1313, #1314, #1321, #1323, #1325, #1330, #1332, #1335
 2021-05-22 17:45:54 -07:00
Simon Willison 9789b94da4 ?_facet_size=100 parameter, closes #1332 2021-05-22 17:34:33 -07:00
Abdussamet Koçak 459259175e
Fix small typo (#1335) 2021-05-22 16:53:34 -07:00
Simon Willison 0a7621f96f
Use pytest-xdist to speed up tests (#1290) 
* Run tests in CI using pytest-xdist
* Documentation for pytest-xdist

Closes #1289
 2021-04-02 20:42:28 -07:00
Simon Willison 59ef4a20cb
© 2017-2021 2021-04-02 13:27:03 -07:00
Simon Willison 87b583a128 Clearer help text for --reload 
Immutable databases are not commonly used, but it's useful to clarify
that --reload will pick up on changes to metadata.
 2021-04-02 13:20:51 -07:00
Simon Willison af5a7f1c09 Release 0.56 
Refs #1005, #1031, #1141, #1229, #1236, #1239, #1246, #1247, #1252, #1266, #1276, #1278
 2021-03-28 17:41:12 -07:00
Campbell Allen f92d823766
ensure immutable databses when starting in configuration directory mode with (#1229) 
* check if immutables is empty list of None
* update docs on how to create the inspect-data.json
 2021-03-28 17:17:31 -07:00
vincent d warmerdam c96a3826cf
Added `--app` to fly install command. (#1279) 2021-03-28 17:11:55 -07:00
Simon Willison 3fcfc85134 Fix links in SpatiaLite tutorial, closes #1278 2021-03-27 09:16:45 -07:00
Simon Willison 8ebdcc916d Remove obsolete note about building SpatiaLite from source, refs #1249 2021-03-26 21:33:15 -07:00
Simon Willison 6ad544df5e Fixed master -> main in a bunch of places, mainly docs 2021-03-23 09:19:41 -07:00
Simon Willison c4f1ec7f33 Documentation for Response.asgi_send(), closes #1266 2021-03-20 14:32:23 -07:00
Jean-Baptiste Pressac a1bcd2fbe5
Minor typo in IP adress (#1256) 
127.0.01 replaced by 127.0.0.1
 2021-03-10 10:26:39 -08:00
David Boucha 4f9a2f1f47
Fix small typo (#1243) 
Thanks, @UtahDave
 2021-03-03 21:46:10 -08:00
Simon Willison 7c87532acc New .add_memory_database() method, closes #1247 2021-02-28 20:02:18 -08:00
Simon Willison afed51b1e3 Note about where to find plugin examples, closes #1244 2021-02-26 09:27:09 -08:00
Simon Willison 42caabf7e9
Fixed typo 2021-02-22 09:35:41 -08:00
Simon Willison cb8a293bd7 Release 0.55 
Refs #1205, #1207, #1214, #1221, #1226, #1227, #1232, #1235
 2021-02-18 18:01:06 -08:00
Simon Willison 73bed17563
Corrected documentation for datasette.urls.static_plugins 2021-02-18 15:25:01 -08:00
Simon Willison 6f41c8a2be
--crossdb option for joining across databases (#1232) 
* Test for cross-database join, refs #283
* Warn if --crossdb used with more than 10 DBs, refs #283
* latest.datasette.io demo of --crossdb joins, refs #283
* Show attached databases on /_memory page, refs #283
* Documentation for cross-database queries, refs #283
 2021-02-18 14:09:12 -08:00
Simon Willison 4df548e766 Update documentation, refs #1226 2021-02-18 10:32:04 -08:00
Simon Willison d2d53a5559 New :issue: Sphinx macro, closes #1227 2021-02-17 17:20:15 -08:00
Simon Willison eda652cf6e
--ssl-keyfile and --ssl-certfile options to "datasette serve" 
Closes #1221
 2021-02-11 16:52:16 -08:00
Simon Willison 3a3de76009 Release 0.54.1 
Refs #1214
 2021-02-02 13:24:05 -08:00
Simon Willison beb98bf454
Fixed typo in code example 2021-01-31 00:49:09 -08:00
Simon Willison dde3c500c7
Using pdb for errors thrown inside Datasette 
Closes #1207
 2021-01-28 18:12:32 -08:00
Simon Willison 1600d2a3ec Renamed /:memory: to /_memory, with redirects - closes #1205 2021-01-28 14:48:56 -08:00
Simon Willison 382e9ecd1d Removed a rogue full-stop 2021-01-25 09:35:06 -08:00
Simon Willison 0b9ac1b2e9
Release 0.54 
Refs #509, #1091, #1150, #1151, #1166, #1167, #1178, #1181, #1182, #1184, #1185, #1186, #1187, #1194, #1198
 2021-01-25 09:33:29 -08:00
Simon Willison a5ede3cdd4 Fixed bug loading database called 'test-database (1).sqlite' 
Closes #1181.

Also now ensures that database URLs have special characters URL-quoted.
 2021-01-24 21:13:05 -08:00
Simon Willison f3a1555318 Contributing docs for Black and Prettier, closes #1167 
Refs #1203
 2021-01-24 17:58:15 -08:00
Simon Willison b6a7b58fa0 Initial docs for _internal database, closes #1154 2021-01-24 16:08:29 -08:00
Simon Willison f78e956eca Plugin testing documentation on using pytest-httpx 
Closes #1198
 2021-01-24 12:38:29 -08:00
Simon Willison 5378f02352
Better tool for extracting issue numbers 2021-01-19 12:50:12 -08:00
Simon Willison 57f4d7b82f Release 0.54a0 
Refs #1091, #1145, #1151, #1156, #1157, #1158, #1166, #1170, #1178, #1182, #1184, #1185, #1186, #1187
 2021-01-19 12:47:30 -08:00
Simon Willison 7e3cfd9cf7
Clarify the name of plugin used in /-/static-plugins/ 2021-01-19 12:27:45 -08:00
Simon Willison c38c42948c extra_body_script module support, closes #1187 2021-01-13 18:14:33 -08:00
Simon Willison fa0c3777b8 script type=module support, closes #1186 2021-01-13 17:50:52 -08:00
Simon Willison 640ac7071b Better PRAGMA error message, closes #1185 2021-01-12 14:26:19 -08:00
Simon Willison ef2ecc1b89 Standardize on 'query string', not 'querystring', in docs 
The request property is request.query_string so this is more consistent.
 2021-01-11 13:33:54 -08:00
Simon Willison 649f48cd70 request.full_path property, closes #1184 2021-01-11 13:32:58 -08:00
Simon Willison ed15c9908e Shrunk ecosystem docs in favour of datasette.io, closes #1182 2021-01-09 14:17:18 -08:00
Simon Willison 4c0995ed60
Fixed bug in example nginx config, refs #1091 2021-01-07 15:42:14 -08:00
Simon Willison 8df116b24c sqlite-utils now lives at sqlite-utils.datasette.io 2020-12-29 13:38:53 -08:00
Simon Willison 8919f99c2f Improved .add_database() method design 
Closes #1155 - _internal now has a sensible name

Closes #509 - Support opening multiple databases with the same stem
 2020-12-22 12:04:18 -08:00
Simon Willison 5e9895c67f Database(memory_name=) for shared in-memory databases, closes #1151 2020-12-17 17:01:18 -08:00
Simon Willison 0c616f732c Release 0.53 
Refs #1132, #1135, #1133, #1138, #1137
 2020-12-10 17:44:36 -08:00
Simon Willison 02bb373194 Updated release process 2020-12-10 17:38:16 -08:00
Simon Willison 2c0aca4887 _header=off option for CSV export, closes #1133 2020-12-10 15:28:44 -08:00
Simon Willison e0b54d0911 No longer using Wiki for examples 2020-12-10 15:20:43 -08:00
Simon Willison 4c6407cd74 Releasing bug fixes from a branch, closes #1136 2020-12-09 12:14:33 -08:00
Simon Willison 387b471b88 Release 0.52.5 
Refs #1134
 2020-12-09 12:13:14 -08:00
Simon Willison fe86d85308 datasette serve --create option, closes #1135 2020-12-09 11:45:45 -08:00
Simon Willison 4c25b035b2 arraynotcontains filter, closes #1132 2020-12-07 14:41:03 -08:00
Simon Willison e3143700a2 Custom template for docs, linking to datasette.io 2020-12-07 11:00:10 -08:00
Simon Willison e5930e6f88 Typo fix in release notes 2020-12-05 11:42:42 -08:00
Simon Willison 2dc281645a Release 0.52.4 
Refs #1125, #1131, #1094
 2020-12-05 11:41:40 -08:00
Simon Willison 4cce551666 Release 0.52.3 
Refs #1124
 2020-12-03 11:07:05 -08:00
Simon Willison e048791a9a Release 0.52.2 
Refs #1116, #1115, #1100, #749, #1121
 2020-12-02 16:57:40 -08:00
Simon Willison 242bc89fdf Release 0.52.1 
Refs #1098, #1102, #1114
 2020-11-29 11:38:29 -08:00
Simon Willison 12877d7a48
Plugin testing docs now recommend datasette.client, closes #1102 2020-11-28 23:44:57 -08:00
Simon Willison a8e66f9065 Release 0.52 
Refs #992, #1103, #1104, #1107, #1077, #1110, #1089, #1086, #1088, #1084
 2020-11-28 15:54:35 -08:00
Simon Willison 50cc6af016 Fixed some broken internal links, refs #1106 2020-11-28 15:34:56 -08:00
Jeff Triplett bbde835a1f
Fix --metadata doc usage (#1112) 
Thanks, @jefftriplett.
 2020-11-28 11:53:48 -08:00
Simon Willison 37d18a5bce datasette publish cloudrun --apt-get-install, closes #1110 2020-11-24 19:05:35 -08:00
Simon Willison f2e2bfcdd9 Renamed datasette.config() to .setting(), closes #1107 2020-11-24 14:06:32 -08:00
Simon Willison 5a77f7a649 Updated docs renaming config to settings 
- config.html is now settings.html
- ConfigOption in app.py is now Setting
- updated documentation unit tests

Refs #1106
 2020-11-24 13:22:33 -08:00
Simon Willison 33eadb8782 config.json is now settings.json, closes #1104 2020-11-24 12:37:29 -08:00
Simon Willison 2a3d5b720b Redirect /-/config to /-/settings, closes #1103 2020-11-24 12:19:14 -08:00
Simon Willison 3159263f05 New --setting to replace --config, closes #992 2020-11-24 12:01:47 -08:00
Simon Willison 6fd35be64d
Fixed invalid JSON in exampl 2020-11-15 08:45:26 -08:00
Simon Willison 200284e1a7
Clarified how --plugin-secret works 2020-11-15 08:43:13 -08:00
Simon Willison 5eb8e9bf25 Removed words that minimize involved difficulty, closes #1089 2020-11-12 12:07:19 -08:00
Simon Willison 13d1228d80
/dbname/tablename/-/modify-table-schema is OK after all 
Refs #1053, #296
 2020-11-02 12:02:50 -08:00
Simon Willison 7b19492070 database_actions() plugin hook, closes #1077 2020-11-02 10:27:25 -08:00
Simon Willison 4785172bbc Release 0.51.1 2020-10-31 20:33:47 -07:00
Simon Willison 7788d62fa6
Expanded the Binary plugins section 2020-10-31 20:28:16 -07:00
Simon Willison f0bd2d05f5 Link to global-power-plants demo instead of sf-trees 2020-10-31 15:24:54 -07:00
Simon Willison d53d747e6a Release 0.51 
Refs #1014, #1016, #1019, #1023, #1027, #1028, #1033, #1034, #1036, #1039

Closes #1076
 2020-10-31 15:21:49 -07:00
Simon Willison fa4de7551c Binary data documentation, closes #1047 2020-10-31 14:37:58 -07:00
Simon Willison 1fe15f4dc1 Docs: Running Datasette behind a proxy, closes #1027 2020-10-31 14:13:57 -07:00
Simon Willison 84bc7244c1 datasette.client now applies base_url, closes #1026 2020-10-31 12:29:42 -07:00
Simon Willison 7a67bc7a56 datasette.urls methods will not apply base_url prefix twice, refs #1026 2020-10-31 12:11:40 -07:00
Simon Willison 11eb1e026f datasette.urls.table(..., format="json"), closes #1035 
Also improved tests for datasette.urls and added format= to some other methods
 2020-10-31 11:16:28 -07:00
Simon Willison f0a740ac21 Remove load_plugin hook - closes #1073 
Refs #1042

This reverts commit 81dea4b07a.
 2020-10-31 09:21:22 -07:00
Simon Willison 59ab24af6b Release 0.51a2 
Refs #1068, #1042, #1054
 2020-10-30 10:56:02 -07:00
Simon Willison a7d9e24ece Update release process with explicit version, refs #1054 2020-10-30 10:52:45 -07:00
Simon Willison 81dea4b07a
load_template() plugin hook 
Closes #1042
 2020-10-30 10:47:18 -07:00
Simon Willison 222f79bb4c debug-menu permission, closes #1068 
Also added tests for navigation menu logic.
 2020-10-30 08:41:57 -07:00
Simon Willison 0e1e89c6ba Release 0.51a1 
Refs #1056, #1039, #998, #1045, #1033, #1036, #1034, #976, #1057, #1058, #1053, #1064, #1066
 2020-10-29 22:35:23 -07:00
Simon Willison 2f7731e9e5 table_actions() plugin hook plus menu, closes #1066 
Refs #690
 2020-10-29 22:16:41 -07:00
Simon Willison 18a64fbb29
Navigation menu plus menu_links() hook 
Closes #1064, refs #690.
 2020-10-29 20:45:15 -07:00
Simon Willison 78b3eeaad9
.blob output renderer 
* _blob_hash= checking plus refactored to use new BadRequest class, refs #1050
* Replace BlobView with new .blob renderer, closes #1050
* .blob downloads on arbitrary queries, closes #1051
 2020-10-29 15:01:38 -07:00
Simon Willison d6f9ff7137 Docs on Designing URLs for your plugin - closes #1053 2020-10-29 12:35:25 -07:00
Simon Willison 42f4851e3e Documentation for .absolute_url(request, path), refs #1034 2020-10-24 18:17:30 -07:00
Simon Willison a96ad967e4 Cleaned up some rogue full-stops 2020-10-24 16:11:14 -07:00
Simon Willison 5a15197960
/db/table/-/blob/pk/column.blob download URL, refs #1036 2020-10-24 16:09:18 -07:00
Simon Willison 10c35bd371 urls.static_plugins() method, closes #1033 
Also documented how to package static assets and templates in plugins, closes #575
 2020-10-24 13:03:40 -07:00
Simon Willison d3e9b0aecb Document render_template() can take a Template, refs #1045 2020-10-23 17:26:15 -07:00
Simon Willison 8148c9e265 Document render_template(templates) list, closes #1045 2020-10-23 17:22:00 -07:00
gerrymanoim 6e26b05799
Fix syntax error in register_routes docs (#1038) 
Thanks, @gerrymanoim
 2020-10-21 15:44:16 -07:00
Simon Willison 66120a7a1c Release 0.51a0 
Refs #1023, #904, #814, #1014, #1016, #1019, #1028
 2020-10-19 22:31:14 -07:00
Simon Willison 091441a444 Fixed remaining places that needed datasette.urls, closes #1025 2020-10-19 22:21:19 -07:00
Simon Willison 0d1763fb2f More datasette.urls usage, refs #1025 2020-10-19 21:24:47 -07:00
Simon Willison 837d0bc995 Tiny typo, refs #904 2020-10-19 18:04:43 -07:00
Simon Willison 5aacc021b5 Docs for datasette.urls, closes #904 2020-10-19 17:51:39 -07:00
Simon Willison c440ffc65a Updated serve help, refs #1028 2020-10-19 17:33:04 -07:00
Simon Willison 6aa5886379 --load-extension=spatialite shortcut, closes #1028 2020-10-19 15:37:43 -07:00
Simon Willison f7147260a4
Added datasette-atom and datasette-ics 2020-10-18 13:56:35 -07:00
Taylor Hodge 568bd7bbf5
Fix broken link in publish docs (#1029) 2020-10-17 13:05:03 -07:00
Jacob Fenton 4f7c0ebd85
Fix table name in spatialite example command (#1022) 
The example query for creating a new point geometry seems to be using a table called 'museums' but at one point it instead uses 'events'. I *believe* it is intended to be museums.
 2020-10-14 16:46:46 -07:00
Simon Willison e34e84901d Link: HTTP header pagination, closes #1014 2020-10-10 17:18:45 -07:00
Simon Willison 7e70643852 Removed --debug option, which didn't do anything - closes #814 2020-10-10 16:39:38 -07:00
Simon Willison 822260fb30
Improved homebrew instructions 2020-10-10 16:19:39 -07:00
Simon Willison 0e58ae7600 Release 0.50.2 
Refs #1011
 2020-10-09 20:53:47 -07:00
Simon Willison 6fe30c348c Release 0.50.1 
Refs #1010
 2020-10-09 17:41:35 -07:00
Simon Willison 549a007683
Clarify that datasette.client HTTP calls are simulated 2020-10-09 16:13:41 -07:00
Simon Willison 99488de329
Link to 0.50 annotated release notes 2020-10-09 14:50:19 -07:00
Simon Willison 1bdbc8aa7f Datasette now supports Python 3.9 2020-10-09 10:57:55 -07:00
Simon Willison a61f0e4e15 Release 0.50 
Refs #1001, #514, #891, #943, #969, #970, #978, #980, #996, #997

Closes #1002
 2020-10-09 10:52:44 -07:00
Simon Willison c12b7a5def Documentation for datasette.client, closes #1006 
Refs #1000
 2020-10-09 10:20:25 -07:00
Simon Willison 703439bdc3 Don't suggest datasette-graphql in bulidpacks demo 
Refs #997 - it's not a great suggestion because the fivethirtyeight.db
database has so many tables.
 2020-10-08 16:50:43 -07:00
Simon Willison 7a029d1eda Link to hosting providers, refs #997 2020-10-08 16:36:22 -07:00
Simon Willison e4f18fbd37 Deploying using buildpacks docs, closes #997 2020-10-08 16:32:04 -07:00
Simon Willison e4554c37b7 datasette publish heroku --tar option, closes #969 2020-10-08 16:30:46 -07:00
Simon Willison 2458d7b766 Docs on deploying with systemd, refs #514 2020-10-08 15:47:37 -07:00
Simon Willison 14982bd900 Release 0.50a1 
Refs #995, #993, #989
 2020-10-06 13:50:54 -07:00
Geoffrey Hing ca5ba6b77b
Document setting Google Cloud SDK properties (#995) 
Document setting Google Cloud SDK properties to avoid having to respond to interactive prompts when running `datasette publish cloudrun`.

Thanks, @ghing!
 2020-10-06 09:25:37 -07:00
Simon Willison 5a184a5d21 Display column type in column action menu, closes #993 
Also added new documented db.table_column_details() introspection method.
 2020-10-05 17:32:10 -07:00
Simon Willison b68cc1c6d4 Release 0.50a0 
Refs #891, #970, #978, #980, #981
 2020-10-01 16:35:04 -07:00
Simon Willison 9a6d0dce28
datasette-json-html as render_cell example 2020-09-23 22:25:06 -07:00
Simon Willison a980199e61 New -o option for opening Datasette in your browser, closes #970 2020-09-22 07:26:47 -07:00
Simon Willison a258339a93
Fixed typo 2020-09-18 23:33:09 -07:00
Simon Willison 368be14c8b Link to annotated release notes 2020-09-15 17:01:11 -07:00
Simon Willison d456b25032 Release 0.49.1 
Refs #967, #966, #956
 2020-09-15 13:20:15 -07:00
Simon Willison 853c5fc370
Fixed incorrect canned query example, closes #966 2020-09-14 20:52:44 -07:00
Simon Willison c0249525d7 Release 0.49 
Refs #880, #944, #945, #947, #948, #953, #958, #962, #963, #964, #965
 2020-09-14 14:38:24 -07:00
Simon Willison 72ac2fd32c JSON API for writable canned queries, closes #880 2020-09-14 14:23:18 -07:00
Simon Willison 1552ac931e Documented custom error pages, closes #965 2020-09-14 11:47:16 -07:00
Simon Willison 699be7dea9 raise_404() function for use in custom templates, closes #964 2020-09-14 10:39:25 -07:00
Simon Willison c18117cf08 Release notes for 0.49a1 
Refs #948 #958 #962 #947 #963 #944
 2020-09-13 19:40:10 -07:00
Simon Willison cc77fcd133 Optional path parameters for custom pages, closes #944 2020-09-13 19:34:43 -07:00
Simon Willison d02f6151da datasette --get status code for error pages, closes #947 2020-09-11 14:32:54 -07:00
Simon Willison 77521c6cd7
Documentation for --pdb, refs #962 2020-09-11 11:40:39 -07:00
Simon Willison ca5c405d0f New 'datasette --pdb' option, closes #962 2020-09-11 11:37:55 -07:00
Simon Willison f65c45674d Notes on upgrading CodeMirror, refs #948 2020-08-30 11:11:04 -07:00
Simon Willison 7178126d90 Release notes for 0.49a0 
Refs #953, #945
 2020-08-28 16:12:47 -07:00
Simon Willison 799ecae948 register_output_renderer can now return Response, closes #953 2020-08-27 21:02:50 -07:00
Simon Willison 86aefc39c5 Fixed undefined reference in index.rst 2020-08-19 10:22:33 -07:00
Simon Willison 69033c6ec4 datasette install --upgrade option, closes #945 2020-08-19 10:20:41 -07:00
Simon Willison 5e0b72247e
Run CI on GitHub Actions, not Travis 
* Run CI on GitHub Actions, not Travis - refs #940
* Update documentation refs to Travis
* Release action now runs parallel tests, then pushes to PyPI, then Docker Hub
 2020-08-17 22:09:34 -07:00
Simon Willison 52eabb019d Release 0.48 
Refs #939, #938, #935, #914
 2020-08-16 11:56:31 -07:00
Simon Willison 3a4c8ed36a Added columns argument to various extra_ plugin hooks, closes #938 2020-08-16 11:09:53 -07:00
Simon Willison e3639247cd Standard arguments for extra_ plugin hooks, closes #939 2020-08-16 09:50:23 -07:00
Simon Willison 41ddc19756
Docs now live at docs.datasette.io (#937) 2020-08-15 16:57:05 -07:00
Simon Willison af12f45c2b Documentation and tests for db.is_mutable 2020-08-15 16:27:32 -07:00
Simon Willison 13b3b51087 Release 0.47.3 
Refs #934, https://github.com/simonw/latest-datasette-with-all-plugins/issues/3
 2020-08-15 13:56:08 -07:00
Simon Willison 7702ea6021 Release 0.47.2 
Refs #931
 2020-08-12 13:54:33 -07:00
Simon Willison b8c09a9334
Suggest "allow": false instead of "allow": {} 2020-08-11 22:56:52 -07:00
Simon Willison 309d7191a1
Fixed broken rST link 2020-08-11 22:11:08 -07:00
Simon Willison cd8c79d30a Release 0.47.1 
Refs #930
 2020-08-11 19:37:24 -07:00
Simon Willison 03418ee037 Release 0.47 
Refs #335, #923, #925, #926, #928
 2020-08-11 17:42:47 -07:00
Simon Willison 1a805288ab Updating homebrew plugin installation instructions 
This will start working as soon as Datasette 0.47 ships. Refs #923
 2020-08-11 17:31:56 -07:00
Simon Willison e139a7619f
'datasette --get' option, closes #926 
Also made a start on the datasette.utils.testing module, refs #898
 2020-08-11 17:24:40 -07:00
Simon Willison 83eda049af Fixed rST bug 2020-08-11 17:10:12 -07:00
Simon Willison 5126ecb126 Re-arranged installation docs, added Homebrew - closes #923 2020-08-11 15:52:41 -07:00
Simon Willison 01fe5b7401 datasette install / datasette uninstall commands, closes #925 2020-08-11 15:32:06 -07:00
Simon Willison 3fa261d1d2
Removed Python 3.5 installation instructions 
Suggested here: https://github.com/simonw/datasette/discussions/921#discussioncomment-49362
 2020-08-10 20:26:42 -07:00
Simon Willison e21face1d7
Link to discussions forum 2020-08-10 19:49:22 -07:00
Simon Willison fca723ab2a
Fixed order of master and main in release notes 2020-08-09 12:30:55 -07:00
Simon Willison b597aa07e6 Fixed link in release notes, refs #918 2020-08-09 09:09:07 -07:00
Simon Willison f25391de1f Release 0.46 
Refs #849, #908, #896, #897, #905, #909, #456, #887, #890
 2020-08-09 09:06:34 -07:00
Simon Willison 6d29210cf4 Updated docs on what happens when a release goes out 2020-08-09 09:05:09 -07:00
Simon Willison de90b7568c Fixed incorrect link reference 2020-08-09 08:41:16 -07:00
Simon Willison dc86ce7d3a
Added datasette-graphql 2020-08-06 21:32:46 -07:00
Simon Willison d71b0c0cb9
Publishing to Vercel section 
Closes #912
 2020-07-31 10:06:32 -07:00
Simon Willison 3c33b42132
Documenting both false and {} for "deny all" is confusing 
Refs #906
 2020-07-25 14:44:42 -07:00
Simon Willison 092874202c 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-24 17:04:06 -07:00
Simon Willison 12c0bc09cc /-/allow-debug tool, closes #908 2020-07-24 15:55:10 -07:00
Simon Willison 028f193dd6
How to use a custom domain with Cloud Run 2020-07-22 11:17:05 -07:00
Simon Willison 02dc6298bd permission_allowed resource can be a tuple 2020-07-21 08:22:36 -07:00
Simon Willison 1f6a134369 await request.post_body() method, closes #897 2020-07-17 13:12:35 -07:00
Simon Willison 4691228a81
Fix for version color in nav, refs #892 2020-07-12 13:00:16 -07:00
Simon Willison ee0ef01652 Added new logo to the documentation 2020-07-12 12:53:29 -07:00
Simon Willison cd231e97cd
Updated example for asgi_wrapper 2020-07-07 19:01:13 -07:00
Simon Willison ba739b2457
An open source multi-tool for exploring and publishing data 2020-07-07 12:54:54 -07:00
Simon Willison f1f581b7ff Release notes for 0.45 
Refs #687, #807, #812, #832, #834, #835, #840, #842, #846, #852, #854, #863, #864, #870
 2020-07-01 14:43:07 -07:00
Simon Willison f7c3fc978c
datasette-auth-tokens improved description 
Refs https://github.com/simonw/datasette-auth-tokens/issues/1
 2020-07-01 12:26:30 -07:00
Simon Willison 676bb64c87 Release 0.45a5 
Refs #840, #832, #835, #812
 2020-06-30 21:25:35 -07:00
Simon Willison 549b1c2063 New forbidden() plugin hook, closes #812 2020-06-30 21:17:38 -07:00
Simon Willison cfd69593f7 Removed hashes from examples on docs/pages - closes #879 2020-06-30 16:45:34 -07:00
Simon Willison 22d932fafc /-/logout page for logging out of ds_actor cookie 
Refs #840
 2020-06-28 21:17:58 -07:00
Simon Willison 968ce53689
Added datasette-write to plugins list on Ecosystem 2020-06-28 20:49:45 -07:00
Simon Willison 265483173b Release 0.45a4 
Refs #864, #871
 2020-06-28 19:31:16 -07:00
Simon Willison 0991ea75cc Renamed _timestamp to _now, refs #842, closes #871 2020-06-28 12:47:28 -07:00
Simon Willison 99fba0fad3 Link to datasette-init plugin hook, refs #834 2020-06-28 12:37:50 -07:00
Simon Willison 8b25b14de1 Added note about unit testing the startup() hook 2020-06-28 09:09:48 -07:00
Simon Willison b28657672f Added register_magic_plugins hook to changelog, refs #842 2020-06-27 20:29:24 -07:00
Simon Willison 1f55a4a2b6 Release notes for 0.45a3 2020-06-27 20:22:49 -07:00
Simon Willison 563f5a2d3a
Magic parameters for canned queries 
Closes #842

Includes a new plugin hook, register_magic_parameters()
 2020-06-27 19:58:16 -07:00
Simon Willison 4b142862f2 Support non-async view functions, closes #867 2020-06-27 11:30:34 -07:00
Simon Willison 1a5b7d318f Fixed test I broke in #863 2020-06-23 21:17:30 -07:00
Simon Willison c5916cbffb Release notes for 0.45a2 2020-06-23 20:28:50 -07:00
Simon Willison eed116ac05
render_template needs await 2020-06-23 20:06:30 -07:00
Simon Willison 000528192e New 'Testing plugins' page, closes #687 2020-06-21 20:53:42 -07:00
Simon Willison 74889aa92e How to use the datasette-plugin template, refs #687, closes #855 2020-06-21 19:51:26 -07:00
Simon Willison c32af6f693 Split out new 'Writing plugins' page, refs #687 2020-06-21 19:37:48 -07:00
Simon Willison 1f42379089 Improved intro on plugin_hooks.rst page, refs #687 
https://datasette.readthedocs.io/en/latest/plugin_hooks.html
 2020-06-21 17:52:58 -07:00
Simon Willison 36e77e1006 Move plugin hooks docs to plugin_hooks.rst, refs #687 2020-06-21 17:34:10 -07:00
Simon Willison e4216ff503 Fixed rST warning 2020-06-21 17:34:10 -07:00
Simon Willison d1640ba76b Don't show prereleases on changelog badge 2020-06-20 08:48:39 -07:00
Simon Willison 55a6ffb93c Link to datasette-saved-queries plugin, closes #852 2020-06-19 20:08:30 -07:00
Simon Willison 0807c4200f Release notes for 0.45a1, refs #852 2020-06-18 16:40:45 -07:00
Simon Willison 9216127ace Documentation tweak, refs #852 2020-06-18 16:39:43 -07:00
Simon Willison 6c26345836 New plugin hook: canned_queries(), refs #852 2020-06-18 16:35:15 -07:00
Simon Willison d2f387591b Better rST label for alpha release, refs #807 2020-06-18 14:01:36 -07:00
Simon Willison dda932d818 Release notes for 0.45a0 
Refs #834 #846 #854 #807
 2020-06-18 13:58:09 -07:00
Simon Willison c81f637d86 Documentation for alpha/beta release process, refs #807 2020-06-18 13:49:52 -07:00
Simon Willison 0c27f10f9d
Updated plugin examples to include datasette-psutil 2020-06-13 16:41:26 -07:00
Simon Willison ae99af2536 Fixed rST code formatting, refs #834 2020-06-13 10:59:35 -07:00
Simon Willison 09a3479a54 New "startup" plugin hook, closes #834 2020-06-13 10:55:41 -07:00
Simon Willison b906030235 Release Datasette 0.44 
Refs #395, #519, #576, #699, #706, #774, #777, #781, #784, #788, #790, #797,
#798, #800, #802, #804, #819, #822, #825, #826, #827, #828, #829, #830,
#833, #836, #837, #839

Closes #806.
 2020-06-11 18:19:30 -07:00
Simon Willison 793a52b317 Link to datasett-auth-tokens and datasette-permissions-sql in docs, refs #806 2020-06-11 17:43:51 -07:00
Simon Willison 1d2e8e09a0 Some last touches to the 0.44 release notes, refs #806 2020-06-11 17:33:16 -07:00
Simon Willison fba8ff6e76 "$env": "X" mechanism now works with nested lists, closes #837 2020-06-11 17:21:48 -07:00
Simon Willison 09bf3c6322 Documentation for publish --secret, refs #787 2020-06-11 09:14:30 -07:00
Simon Willison fcc7cd6379 rST formatting 2020-06-11 09:05:15 -07:00
Simon Willison 98632f0a87
--secret command for datasette publish 
Closes #787
 2020-06-11 09:02:03 -07:00
Simon Willison ce4958018e Clarify that view-query also lets you execute writable queries 2020-06-10 17:10:28 -07:00
Simon Willison 198545733b Document that "allow": {} denies all 
https://github.com/simonw/datasette/issues/831#issuecomment-642324847
 2020-06-10 16:56:53 -07:00
Simon Willison 9f236c4c00 Warn that register_facet_classes may change, refs #830 
Also documented policy that plugin hooks should not be shipped without a real example. Refs #818
 2020-06-10 13:06:46 -07:00
Simon Willison 57e812d5de ds_author cookie can now expire, closes #829 
Refs https://github.com/simonw/datasette-auth-github/issues/62#issuecomment-642152076
 2020-06-10 12:39:54 -07:00
Simon Willison d828abadde Fix horizontal scrollbar on changelog, refs #828 2020-06-09 21:20:07 -07:00
Simon Willison f3951539f1 Hopefully fix horizontal scroll with changelog on mobile 2020-06-09 18:19:11 -07:00
Simon Willison d94fc39e33 Crafty JavaScript trick for generating commit references 2020-06-09 16:43:58 -07:00
Simon Willison b3919d8059 Mostly complete release notes for 0.44, refs #806 2020-06-09 16:03:42 -07:00
Simon Willison b5f04f42ab ds_actor cookie documentation, closes #826 2020-06-09 15:32:24 -07:00
Simon Willison 008e2f63c2 response.set_cookie(), closes #795 2020-06-09 15:19:37 -07:00
Simon Willison f240970b83 Fixed tests/fixtures.py, closes #804 2020-06-09 12:58:12 -07:00
Simon Willison 56eb80a459 Documented CSRF protection, closes #827 2020-06-09 12:32:52 -07:00
Simon Willison 7633b9ab24 unauthenticated: true method plus allow block docs, closes #825 2020-06-09 10:01:03 -07:00
Simon Willison 70dd14876e Improved documentation for permissions, refs #699 2020-06-09 09:04:46 -07:00
Simon Willison 3aa87eeaf2 Documentation no loger suggests that actor["id"] is required, closes #823 2020-06-09 07:58:12 -07:00
Simon Willison fa87d16612 Clearer docs for actor_matches_allow 2020-06-09 07:10:46 -07:00
Simon Willison 5a6a73e319 Replace os.urandom(32).hex() with secrets.token_hex(32) 2020-06-08 21:37:35 -07:00
Simon Willison fac8e93815 request.url_vars property, closes #822 2020-06-08 20:40:00 -07:00
Simon Willison db660db463 Docs + unit tests for Response, closes #821 2020-06-08 20:32:10 -07:00
Simon Willison f5e79adf26
register_routes() plugin hook (#819) 
Fixes #215
 2020-06-08 20:12:06 -07:00
Simon Willison 49d6d2f7b0 allow_sql block to control execute-sql upermission in metadata.json, closes #813 
Also removed the --config allow_sql:0 mechanism in favour of the new allow_sql block.
 2020-06-08 17:05:44 -07:00
Simon Willison e0a4664fba Better example plugin for permission_allowed 
Also fixed it so default permission checks run after plugin permission checks, refs #818
 2020-06-08 15:09:57 -07:00
Simon Willison 8205d58316 Corrected documentation for resource in view-query 2020-06-08 13:10:40 -07:00
Simon Willison 5437085382 Documentation for allow blocks on more stuff, closes #811 2020-06-08 12:32:27 -07:00
Simon Willison c7d145e016 Updated example for extra_template_vars hook, closes #816 2020-06-08 12:06:05 -07:00
Simon Willison 799c5d5357 Renamed resource_identifier to resource, refs #817 2020-06-08 11:59:53 -07:00
Simon Willison c9f1ec616e Removed resource_type from permissions system, closes #817 
Refs #811, #699
 2020-06-08 11:51:03 -07:00
Simon Willison 177059284d New request.actor property, refs #811 2020-06-08 10:05:32 -07:00
Simon Willison 613fa551a1 Removed view-row permission, for the moment - refs #811 
https://github.com/simonw/datasette/issues/811#issuecomment-640338347
 2020-06-07 20:14:27 -07:00
Simon Willison 5ed2853cf3 Fix permissions documenation test 2020-06-07 14:01:22 -07:00
Simon Willison a1e801453a Renamed execute-query permission to execute-sql, refs #811 2020-06-07 13:20:59 -07:00
Simon Willison 4340845754 Nested permission checks for all views, refs #811 2020-06-07 13:03:08 -07:00
Simon Willison 86dec9e8ff Added permission check to every view, closes #808 2020-06-06 22:30:36 -07:00
Simon Willison bd4de0647d Improved permissions documentation 2020-06-06 19:09:59 -07:00
Simon Willison 7dc23cd71a Whitespace 2020-06-06 13:05:09 -07:00
Simon Willison f1daf64e72 Link to canned query permissions documentation 2020-06-06 12:46:40 -07:00
Simon Willison 14f6b4d200 actor_matches_allow utility function, refs #800 2020-06-06 11:39:11 -07:00
Simon Willison d4c7b85f55 Documentation for "id": "*", refs #800 2020-06-06 11:23:54 -07:00
Simon Willison 30a8132d58 Docs for authentication + canned query permissions, refs #800 
Closes #786
 2020-06-06 11:18:46 -07:00
Simon Willison 0da7f49b24 Rename RequestParameters to MultiParams, refs #799 2020-06-05 10:52:50 -07:00
Simon Willison 0c064c5fe2 More things you can do with plugins 2020-06-04 20:10:40 -07:00
Simon Willison 2074efa5a4 Another actor_from_request example 2020-06-04 18:38:32 -07:00
Simon Willison 8524866fdf Link to authentication docs 2020-06-04 16:58:19 -07:00
Simon Willison 9cb44be42f Docs and tests for "params", closes #797 2020-06-03 14:04:40 -07:00
Simon Willison aa82d03704
Basic writable canned queries 
Refs #698. First working version of this feature.

* request.post_vars() no longer discards empty values
 2020-06-03 08:16:50 -07:00
Simon Willison a7137dfe06 /-/plugins now shows details of hooks, closes #794 
Also added /-/plugins?all=1 parameter to see default plugins.
 2020-06-02 14:49:28 -07:00
Simon Willison 4fa7cf6853 Flash messages mechanism, closes #790 2020-06-02 14:12:18 -07:00
Simon Willison 1d0bea157a New request.cookies property 2020-06-02 14:11:41 -07:00
Simon Willison dfdbdf378a Added /-/permissions debug tool, closes #788 
Also started the authentication.rst docs page, refs #786.

Part of authentication work, refs #699.
 2020-05-31 22:00:36 -07:00
Simon Willison 9f3d4aba31 --root option and /-/auth-token view, refs #784 2020-05-31 18:16:42 -07:00
Simon Willison 7690d5ba40 Docs for --secret/DATASETTE_SECRET - closes #785 2020-05-31 18:16:42 -07:00
Simon Willison fa27e44fe0 datasette.sign() and datasette.unsign() methods, refs #785 2020-05-31 18:16:42 -07:00
Simon Willison 1fc6ceefb9 Added /-/actor.json - refs #699 
Also added JSON highlighting to introspection documentation.
 2020-05-31 18:16:42 -07:00
Simon Willison 9315bacf6f Implemented datasette.permission_allowed(), refs #699 2020-05-31 18:16:42 -07:00
Simon Willison 461c82838d Implemented actor_from_request with tests, refs #699 
Also added datasette argument to permission_allowed hook
 2020-05-31 18:16:42 -07:00
Simon Willison 060a56735c actor_from_request and permission_allowed hookspecs, refs #699 2020-05-31 18:16:42 -07:00
Simon Willison c4fbe50676 Documentation for Database introspection methods, closes #684 
Refs #576
 2020-05-30 11:40:30 -07:00
Simon Willison 3c5afaeb23 Re-arranged internals documentation 
Request is more useful to most people than Database.
 2020-05-30 11:06:13 -07:00
Simon Willison 5ae14c9f20 Improved documentation for RequestParameters class 2020-05-30 10:54:22 -07:00
Simon Willison 31fb006a9b Added datasette.get_database() method 
Refs #576
 2020-05-30 07:29:59 -07:00
Simon Willison 81be31322a New implementation for RequestParams 
- no longer subclasses dict
- request.args[key] now returns first item, not all items
- removed request.raw_args entirely

Closes #774
 2020-05-29 16:22:22 -07:00
Simon Willison 84616a2364 request.args.getlist() returns [] if missing, refs #774 
Also added some unit tests for request.args
 2020-05-29 15:51:30 -07:00
Simon Willison 7ccd55a163 Views do support sorting now, refs #508 2020-05-29 15:44:22 -07:00
Simon Willison 3c1a60589e Consistent capitalization of SpatiaLite in the docs 2020-05-28 11:27:44 -07:00
Simon Willison 21a8ffc82d
Tip about referencing issues in release notes commit 2020-05-28 10:49:58 -07:00
Simon Willison 40885ef24e
Noted tool for converting release notes to Markdown 2020-05-28 07:41:22 -07:00
Simon Willison d56f402822 Release notes for 0.43 
Refs #581, #770, #729, #706, #751, #706, #744, #771, #773
 2020-05-28 07:11:06 -07:00
Simon Willison 5ab411c733 can_render mechanism for register_output_renderer, closes #770 2020-05-27 22:57:05 -07:00
Simon Willison 75cd432e5a Ability to set custom table/view page size in metadata, closes #751 2020-05-27 22:00:04 -07:00
Simon Willison 57f48b8416 Made register_output_renderer callback optionally awaitable, closes #776 2020-05-27 19:43:30 -07:00
Simon Willison 52c4387c7d Redesigned register_output_renderer plugin hook, closes #581 2020-05-27 19:21:41 -07:00
Simon Willison 4b96857f17 Link to request object documentation, refs #706 2020-05-27 15:35:25 -07:00
Simon Willison 50652f474b Stop using .raw_args, deprecate and undocument it - refs #706 2020-05-27 15:29:42 -07:00
Simon Willison 6d7cb02f00 Documentation for request object, refs #706 2020-05-27 15:17:53 -07:00
Simon Willison ad88c9b3f3 Mechanism for adding a default URL fragment to a canned query 
Closes #767
 2020-05-27 14:52:03 -07:00
Simon Willison af5702220c Added datasette-media plugin to the docs 2020-05-27 13:34:12 -07:00
Simon Willison 9e6075d21f rST fixes for register_output_renderer docs 2020-05-27 11:35:31 -07:00
Simon Willison af6c6c5d6f Release 0.42, refs #685 2020-05-08 10:38:27 -07:00
Simon Willison 2694ddcf14 Test for .execute_fn(), refs #685 2020-05-08 10:29:17 -07:00
Simon Willison 5ab848f0b8
RST fix 2020-05-08 10:04:47 -07:00
Simon Willison 545c71b604
Small cleanup 2020-05-08 09:57:01 -07:00
Simon Willison ec9cdc3ffa
Documentation for .execute_fn(), refs #685 2020-05-08 09:52:53 -07:00
Simon Willison 4433306c18
Improvements + docs for db.execute() and Results class 
* Including new results.first() and results.single_value() methods. Closes #685
 2020-05-08 09:05:46 -07:00
Simon Willison 182e5c8745 Release Datasette 0.41 
Refs #648 #731 #750 #151 #761 #752 #719 #756 #748
 2020-05-06 11:20:58 -07:00
Simon Willison 9212f0c9c3
Removed note about virtual environments 
Simplifies things now that we also talk about pipx.
 2020-05-04 12:35:28 -07:00
Simon Willison 0cdf111ae6
Move pip/pipx to top of installation instructions 
Less intimidating than Docker, hopefully.
 2020-05-04 12:31:13 -07:00
Simon Willison 7e2bb31464
Documented installation using pipx, closes #756 2020-05-04 12:10:31 -07:00
Simon Willison 9424687e9e Consistently return charset utf-8, closes #752 2020-05-04 10:42:10 -07:00
Simon Willison d996d4122b
Add badges to documentation index 2020-05-03 08:46:49 -07:00
Simon Willison b3aa5f4313 Added 'not like' table filter, refs #750 2020-05-02 12:04:54 -07:00
Simon Willison 4df1b4d8b0 Re-arranged full-text search docs 
Also documented ?_searchmode=raw - closes #748
 2020-04-30 14:06:00 -07:00
Simon Willison cf2d547ffc Documentation for #747 2020-04-30 12:02:28 -07:00
Simon Willison 25014ca25e
Configuration directory mode, closes #731 2020-04-27 09:30:24 -07:00
Simon Willison 304e7b1d9f
Mechanism for creating custom pages using templates 
Closes #648
 2020-04-26 11:46:43 -07:00
Simon Willison 227bb3e91f
Added more example plugins 2020-04-22 06:47:20 -07:00
Simon Willison 8da108193b Fixed a couple of spelling errors 2020-04-21 21:06:39 -07:00
Simon Willison edb39c91f7 Release Datasette 0.40 2020-04-21 21:00:34 -07:00
Simon Willison 15e2321804 Extra body CSS class for canned queries, closes #727 2020-04-15 14:07:28 -07:00
Simon Willison e0e7a0facf Removed Zeit Now v1 support, closes #710 2020-04-04 16:04:33 -07:00
Simon Willison 6717c719dd
--metadata accepts YAML as well as JSON - closes #713 2020-04-02 12:30:53 -07:00
Simon Willison 2aaad72789 Refactor template setup into Datasette constructor 
Closes #707
 2020-03-26 18:12:43 -07:00
Simon Willison 99b1e91965 Fixed RST bug 2020-03-24 21:46:52 -07:00
Simon Willison dedd775512 Release 0.39 2020-03-24 21:02:37 -07:00
Simon Willison 7656fd64d8
base_url configuration setting, closes #394 
* base_url configuration setting
* base_url works for static assets as well
 2020-03-24 17:18:43 -07:00
Simon Willison 5f4aeb1f19 Removed documentation for Zeit Now v1, refs #710 2020-03-24 15:45:24 -07:00
Simon Willison c0aa929cdd Added datasette-publish-fly plugin to docs, closes #704 2020-03-24 15:38:58 -07:00
Simon Willison 3b3cb3e8df Added example plugins to plugin hooks docs, closes #709 2020-03-24 15:29:34 -07:00
Simon Willison 236aa065b2 "sort" and "sort_desc" metadata properties, closes #702 2020-03-21 19:28:35 -07:00
Simon Willison 3d656f4b31 Updated documentation formatting 2020-03-21 18:31:54 -07:00
Simon Willison fd2a74dc09
Updated publish_subcommand example 2020-03-18 17:47:53 -07:00
Simon Willison 7e357abbc3 Release 0.38 2020-03-08 16:26:50 -07:00
Simon Willison af9cd4ca64 Fixes for new --memory option, refs #694 2020-03-05 17:44:15 -06:00
Simon Willison be20e6991e Changelog for 0.37.1 2020-03-02 19:43:08 -08:00
Simon Willison 4933035b75
RST fix 2020-03-02 08:10:16 -08:00
Simon Willison 613f6fad72
Improved extra_template_vars documentation 2020-03-02 07:12:34 -08:00