Simon Willison
84391763a8
Clarify that magic parameters don't work for custom SQL
2022-01-25 10:39:03 -08:00
Simon Willison
ffca55dfd7
Show link to /stable/ on /latest/ pages, refs #1608
2022-01-20 14:40:44 -08:00
Simon Willison
e1770766ce
Return plugins and hooks in predictable order
2022-01-19 21:14:04 -08:00
Simon Willison
43c30ce023
Use cog to maintain default plugin list in plugins.rst, closes #1600
...
Also fixed a bug I spotted where datasette.filters showed the same hook three times.
2022-01-19 21:04:09 -08:00
Simon Willison
fae3983c51
Drop support for Python 3.6, closes #1577
...
Refs #1606
2022-01-19 20:31:22 -08:00
Simon Willison
cb29119db9
Release 0.60
...
Refs #473 , #625 , #1527 , #1544 , #1547 , #1551 , #1552 , #1555 , #1556 , #1557 ,
#1563 , #1564 , #1568 , #1570 , #1575 , #1579 , #1588 , #1594
2022-01-13 17:36:51 -08:00
Simon Willison
3664ddd400
Replace update-docs-help.py with cog, closes #1598
2022-01-13 16:47:53 -08:00
Simon Willison
ab7d6a7179
Updated settings help URL to avoid redirect
2022-01-13 16:38:16 -08:00
Simon Willison
714b4df1b1
Fixed reStructuredText warning, refs #1594
2022-01-13 16:36:28 -08:00
Simon Willison
76d66d5b2b
Tweak order of documentation contents
2022-01-13 16:30:00 -08:00
Simon Willison
515f8d38eb
Help summaries for publish cloudrun/heroku
2022-01-13 16:12:54 -08:00
Simon Willison
8cf4b77a92
Better copy for 'datasette plugins --help'
2022-01-13 16:11:07 -08:00
Simon Willison
8f5c44a166
Better --help summaries for install and uninstall
2022-01-13 16:09:38 -08:00
Simon Willison
88bc2ceae1
--help summary for 'datasette inspect', closes #1597
2022-01-13 16:07:30 -08:00
Simon Willison
5698e2af01
Promote Datasette Desktop in installation docs, closes #1466
2022-01-13 13:55:13 -08:00
Simon Willison
4b23f01f3e
CLI reference docs, maintained by cog - refs #1594
2022-01-13 13:35:54 -08:00
Simon Willison
8c401ee0f0
Fixed remaining code and docs for new block=True default, closes #1579
2021-12-23 11:18:20 -08:00
Simon Willison
75153ea9b9
Updated db.execute_write_fn() docs for block=True default, refs #1579
2021-12-23 11:16:31 -08:00
Simon Willison
00a2895cd2
execute_write defaut is now block=True, closes #1579
2021-12-23 11:03:49 -08:00
Simon Willison
6b1384b2f5
Track plausible for docs.datasette.io not datasette.io
2021-12-20 15:55:17 -08:00
Simon Willison
554aae5c51
Plausible analytics for the documentation
2021-12-20 09:23:05 -08:00
Simon Willison
dbaac79946
Release 0.60a1
...
Refs #1547 , #1555 , #1562 , #1563 , #1564 , #1567 , #1568 , #1569 , #1570 , #1571 , #1572
2021-12-19 14:08:10 -08:00
Simon Willison
5cadc24489
db.execute_write_script() and db.execute_write_many(), closes #1570
...
Refs #1555
2021-12-18 10:57:22 -08:00
Simon Willison
9e094b7c9d
db.execute_write(executescript=True) option, closes #1569
2021-12-18 10:34:15 -08:00
Simon Willison
85c22f4fbc
Corrected Datasette(files=) example from #1563
2021-12-18 10:10:37 -08:00
Simon Willison
7c8f8aa209
Documentation for Datasette() constructor, closes #1563
2021-12-17 18:19:36 -08:00
Simon Willison
0c91e59d2b
datasette-leaflet-freedraw is an example of filters_from_request
2021-12-17 15:55:06 -08:00
Simon Willison
92a5280d2e
Release 0.60a0
...
Refs #473 , #625 , #1544 , #1551 , #1552 , #1556 , #1557
2021-12-17 11:13:51 -08:00
Simon Willison
aa7f0037a4
filters_from_request plugin hook, now used in TableView
...
- New `filters_from_request` plugin hook, closes #473
- Used it to extract the logic from TableView that handles `_search` and
`_through` and `_where` - refs #1518
Also needed for this plugin work: https://github.com/simonw/datasette-leaflet-freedraw/issues/7
2021-12-17 11:02:14 -08:00
Simon Willison
95d0dd7a1c
Fix for colliding facet types bug, closes #625
...
Refs #830
2021-12-16 12:12:04 -08:00
Simon Willison
992496f261
?_nosuggest=1 parameter for table views, closes #1557
2021-12-16 11:24:54 -08:00
Simon Willison
20a2ed6bec
Fixed bug with metadata config of array/date facets, closes #1552
...
Thanks @davidbgk for spotting the fix for the bug.
2021-12-16 10:47:40 -08:00
Simon Willison
40e5b0a5b5
How to create indexes with sqlite-utils
2021-12-16 10:03:10 -08:00
Simon Willison
7c02be2ee9
Release 0.59.4
...
Refs #1525 , #1527
2021-11-29 22:45:37 -08:00
dependabot[bot]
3303514a52
Update docutils requirement from <0.18 to <0.19 ( #1508 )
...
Updates the requirements on [docutils](http://docutils.sourceforge.net/ ) to permit the latest version.
---
updated-dependencies:
- dependency-name: docutils
dependency-type: direct:production
...
Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
2021-11-29 18:35:18 -08:00
Simon Willison
48f11998b7
Release 0.59.3
...
Refs #448 , #838 , #1519
2021-11-20 15:40:21 -08:00
Simon Willison
d8c79b1340
Link to Apache proxy demo from documentation, closes #1524
2021-11-20 15:33:58 -08:00
Simon Willison
502c02fa6d
Pin to docutils<0.18 in ReadTheDocs, refs #1507
2021-11-13 21:37:40 -08:00
Simon Willison
de1e031713
Release 0.59.2
...
Refs #1497 , #1503 , #1506
2021-11-13 21:14:43 -08:00
Simon Willison
e6e44372b3
Release 0.59.1
...
Refs #1482 , #1496
2021-10-24 15:29:56 -07:00
Simon Willison
15a9d4abff
Docs on named parameters with cast as real/integer, closes #1496
2021-10-22 12:34:23 -07:00
Simon Willison
a1b20852db
Unwrapped some documentation text
2021-10-22 12:00:00 -07:00
Simon Willison
e5d01ca583
Fixed typo in release notes
2021-10-22 11:56:27 -07:00
Simon Willison
ff9ccfb031
Fixed typo in release notes
2021-10-14 12:23:43 -07:00
Simon Willison
8934507cdc
Release 0.59
...
Refs #942 , #1404 , #1405 , #1416 , #1420 , #1421 , #1422 , #1423 , #1425 , #1431 , #1443 , #1446 , #1449 , #1467 , #1469 , #1470 , #1488
2021-10-14 12:22:19 -07:00
Simon Willison
81bf9a9f3c
Updated --cors documentation, refs #1467
2021-10-14 12:19:03 -07:00
C. Titus Brown
0fdbf00484
Rework the `--static` documentation
...
Rework the `--static` documentation to better differentiate between the filesystem and serving locations. Closes #1457
Co-authored-by: Simon Willison <swillison@gmail.com>
2021-10-14 11:39:55 -07:00
Michael Tiemann
31352914c4
Update full_text_search.rst ( #1474 )
...
Change "above" to "below" to correct correspondence of reference to example.
2021-10-13 14:10:23 -07:00
Rhet Turnbull
68087440b3
Added instructions for installing plugins via pipx
...
Closes #1486
2021-10-13 14:09:10 -07:00
Simon Willison
63886178a6
Describe a common mistake using csrftoken()
2021-09-22 15:44:28 -07:00
Simon Willison
b28b6cd2fe
Warn that execute_write_fn(fn) should be a non-async function
2021-09-12 13:13:52 -07:00
Simon Willison
67cbf0ae72
Example for register_commands, refs #1449
2021-08-28 04:17:03 -07:00
Simon Willison
50c35b66a4
Added missing space
2021-08-28 04:14:38 -07:00
Simon Willison
d3ea367131
Release 0.59a2
...
Refs #942 , #1421 , #1423 , #1431 , #1443 , #1446 , #1449
2021-08-27 18:55:54 -07:00
Simon Willison
30c18576d6
register_commands() plugin hook, closes #1449
2021-08-27 18:39:42 -07:00
Tim Sherratt
93c3a7ffbf
Remove underscore from search mode parameter name ( #1447 )
...
The text refers to the parameter as `searchmode` but the `metadata.json` example uses `search_mode`. The latter doesn't actually seem to work.
2021-08-24 18:28:58 -07:00
Simon Willison
7e15422aac
Documentation for datasette.databases property, closes #1443
2021-08-19 14:23:43 -07:00
Simon Willison
d84e574e59
Ability to deploy demos of branches
...
* Ability to deploy additional branch demos, closes #1442
* Only run tests before deploy on main branch
* Documentation for continuous deployment
2021-08-19 14:09:38 -07:00
Simon Willison
77f46297a8
Rename --help-config to --help-settings, closes #1431
2021-08-12 18:01:57 -07:00
Simon Willison
e837095ef3
Column metadata, closes #942
2021-08-12 16:53:23 -07:00
Simon Willison
ad90a72afa
Release 0.59a1
...
Refs #1425
2021-08-08 18:13:03 -07:00
Simon Willison
3bb6409a6c
render_cell() can now return an awaitable, refs
2021-08-08 16:05:00 -07:00
Simon Willison
de5ce2e563
datasette-pyinstrument
2021-08-08 10:37:51 -07:00
Simon Willison
61505dd0c6
Release 0.59a0
...
Refs #1404 , #1405 , #1416 , #1420 , #1422
2021-08-06 22:40:07 -07:00
Simon Willison
6dd14a1221
Improved links to example plugins
2021-08-06 22:38:47 -07:00
Simon Willison
66e143c76e
New hide_sql canned query option, refs #1422
2021-08-06 22:17:36 -07:00
Simon Willison
acc2243662
Quotes around '.[test]' for zsh
2021-08-05 08:47:18 -07:00
Simon Willison
a1f3830356
--cpu option for datasette publish cloudrun, closes #1420
2021-08-03 22:20:50 -07:00
Simon Willison
2208c3c68e
Spelling corrections plus CI job for codespell
...
* Use codespell to check spelling in documentation, refs #1417
* Fixed spelling errors spotted by codespell, closes #1417
* Make codespell a docs dependency
See also this TIL: https://til.simonwillison.net/python/codespell
2021-08-03 09:36:38 -07:00
Simon Willison
a679d0de87
Fixed spelling of 'receive' in a bunch of places
2021-08-03 09:11:18 -07:00
Simon Willison
121e10c29c
Doumentation and test for utils.parse_metadata(), closes #1405
2021-07-29 16:30:12 -07:00
Simon Willison
eccfeb0871
register_routes() plugin hook datasette argument, closes #1404
2021-07-26 16:16:46 -07:00
Simon Willison
6f1731f305
Updated cookiecutter installation link
2021-07-23 12:38:09 -07:00
Simon Willison
c73af5dd72
Release 0.58.1
...
Refs #1231 , #1396
2021-07-16 12:50:06 -07:00
Simon Willison
e27dd7c12c
Release 0.58
...
Refs #1365 , #1371 , #1377 , #1384 , #1387 , #1388 , #1389 , #1394
2021-07-14 17:33:04 -07:00
Simon Willison
7ea678db22
Warn about potential changes to get_metadata hook, refs #1384
2021-07-14 17:19:31 -07:00
Simon Willison
ba11ef27ed
Clarify when to use systemd restart
2021-07-13 22:43:13 -07:00
Simon Willison
2c4cd7141a
Consistently use /my-datasette in examples
2021-07-13 16:15:48 -07:00
Simon Willison
7f4c854db1
rST fix
2021-07-13 11:45:32 -07:00
Aslak Raanes
d71cac4981
How to configure Unix domain sockets with Apache
...
Example on how to use Unix domain socket option on Apache. Not testet.
(Usually I would have used [`ProxyPassReverse`](https://httpd.apache.org/docs/current/mod/mod_proxy.html#proxypassreverse ) in combination with `ProxyPass` , i.e.
```apache
ProxyPass /my-datasette/ http://127.0.0.1:8009/my-datasette/
ProxyPassReverse /my-datasette/ http://127.0.0.1:8009/my-datasette/
```
and
```apache
ProxyPass /my-datasette/ unix:/tmp/datasette.sock|http://localhost/my-datasette/
ProxyPassReverse /my-datasette/ unix:/tmp/datasette.sock|http://localhost/my-datasette/
```
2021-07-13 11:32:49 -07:00
Aslak Raanes
4054e96a39
Update deploying.rst ( #1392 )
...
Use same base url for Apache as in the example
2021-07-13 10:42:27 -07:00
Simon Willison
d792fc7cf5
Simplified nginx config examples
2021-07-10 17:29:42 -07:00
Simon Willison
180c7a5328
--uds option for binding to Unix domain socket, closes #1388
2021-07-10 16:37:30 -07:00
Simon Willison
83f6799a96
searchmode: raw table metadata property, closes #1389
2021-07-10 11:33:08 -07:00
Simon Willison
c8feaf0b62
systemctl restart datasette.service, closes #1390
2021-07-09 09:32:32 -07:00
Simon Willison
dbc61a1fd3
Documented ProxyPreserveHost On for Apache, closes #1387
2021-07-02 10:33:03 -07:00
Simon Willison
ea627baccf
Removed fallback parameter from get_metadata, refs #1384
2021-06-26 17:02:42 -07:00
Simon Willison
0d339a4897
Removed text about executing SQL, refs #1384
2021-06-26 16:04:39 -07:00
Simon Willison
089278b8db
rST fix, refs #1384
2021-06-26 15:49:07 -07:00
Brandon Roberts
baf986c871
New get_metadata() plugin hook for dynamic metadata
...
The following hook is added:
get_metadata(
datasette=self, key=key, database=database, table=table,
fallback=fallback
)
This gets called when we're building our metdata for the rest
of the system to use. We merge whatever the plugins return
with any local metadata (from metadata.yml/yaml/json) allowing
for a live-editable dynamic Datasette.
As a security precation, local meta is *not* overwritable by
plugin hooks. The workflow for transitioning to live-meta would
be to load the plugin with the full metadata.yaml and save.
Then remove the parts of the metadata that you want to be able
to change from the file.
* Avoid race condition: don't mutate databases list
This avoids the nasty "RuntimeError: OrderedDict mutated during
iteration" error that randomly happens when a plugin adds a
new database to Datasette, using `add_database`. This change
makes the add and remove database functions more expensive, but
it prevents the random explosion race conditions that make for
confusing user experience when importing live databases.
Thanks, @brandonrobertz
2021-06-26 15:24:54 -07:00
Simon Willison
ff17970ed4
Release 0.58a1
...
Refs #1365 , #1377
2021-06-24 09:24:59 -07:00
Simon Willison
b1fd24ac9f
skip_csrf(datasette, scope) plugin hook, refs #1377
2021-06-23 15:40:09 -07:00
Simon Willison
3a50015566
datasette-publish-now is now called datasette-publish-vercel
2021-06-23 12:51:19 -07:00
Simon Willison
403e370e5a
Fixed reference to default publish implementation
2021-06-23 12:50:19 -07:00
Simon Willison
cd7678fde6
Release 0.58a0
...
Refs #1371
2021-06-09 21:51:14 -07:00
Simon Willison
d23a267138
Make request available to menu plugin hooks, closes #1371
2021-06-09 21:45:24 -07:00
Simon Willison
a3faf37883
Release 0.57.1
...
Refs #1364 , #1367
2021-06-08 09:26:45 -07:00
Simon Willison
58746d3c51
Release 0.57
...
Refs #263 , #615 , #619 , #1238 , #1257 , #1305 , #1308 , #1320 , #1332 , #1337 , #1349 , #1353 , #1359 , #1360
2021-06-05 15:06:55 -07:00
Simon Willison
ff29dd55fa
?_trace=1 now depends on trace_debug setting, closes #1359
2021-06-05 13:18:37 -07:00
louispotok
368aa5f1b1
Update docs: explain allow_download setting ( #1291 )
...
* Update docs: explain allow_download setting
This fixes one possible source of confusion seen in #502 and clarifies
when database downloads will be shown and allowed.
2021-06-05 12:48:51 -07:00
Simon Willison
ff45ed0ce5
Updated --help output for latest Click, closes #1354
2021-06-01 09:16:58 -07:00
Simon Willison
fd368d3b2c
New _nocount=1 option, used to speed up CSVs - closes #1353
2021-06-01 09:12:32 -07:00
Simon Willison
8bde6c5461
Rename ?_nofacets=1 to ?_nofacet=1, refs #1353
2021-06-01 08:56:00 -07:00
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