mirror
/
datasette
kopia lustrzana https://github.com/simonw/datasette
1
0
Forkuj 0
Kod Zgłoszenia Packages Projekty Wydania Wiki Aktywność
2 596 Commity
131 Gałęzie
148 Tagi
75 MiB
Wykres commitów

1032 Commity (main)

Autor SHA1 Wiadomość Data
Simon Willison c09c53f345 New handle_exception plugin hook, refs #1770 
Also refs:
- https://github.com/simonw/datasette-sentry/issues/1
- https://github.com/simonw/datasette-show-errors/issues/2
 2022-07-17 16:24:39 -07:00
Simon Willison 950cc7677f
Fix missing Discord image 
Refs https://github.com/simonw/datasette.io/issues/112
 2022-07-14 15:18:28 -07:00
Simon Willison c133545fe9
Make discord badge lowercase 
Refs https://github.com/simonw/datasette.io/issues/112
 2022-07-14 15:04:38 -07:00
Simon Willison 5d76c1f81b
Discord badge 
Refs https://github.com/simonw/datasette.io/issues/112
 2022-07-14 15:03:33 -07:00
Simon Willison 035dc5e7b9
More than 90 plugins now 2022-07-09 10:25:37 -07:00
Simon Willison 6373bb3414 Expose current SQLite row to render_cell hook, closes #1300 2022-07-07 09:30:49 -07:00
Simon Willison e780b2f5d6
Trying out one-sentence-per-line 
As suggested here: https://sive.rs/1s

Markdown and reStructuredText will display this as if it is a single paragraph, even though the sentences themselves are separated by newlines.

This could result in more useful diffs. Trying it out on this page first.
 2022-06-20 10:54:23 -07:00
Simon Willison 8dd816bc76 Applied Black 2022-05-30 15:42:38 -07:00
Simon Willison adedd85b68
Clarify that request.headers names are converted to lowercase 2022-05-28 18:42:31 -07:00
Simon Willison b010af7bb8
Updated copyright years in documentation footer 2022-05-20 15:23:09 -07:00
Simon Willison 4446075334 Append warning to the write element, refs #1746 2022-05-20 13:44:23 -07:00
Simon Willison 1d33fd03b3 Switch docs theme to Furo, refs #1746 2022-05-20 13:34:51 -07:00
Simon Willison 1465fea479 sphinx-copybutton for docs, closes #1748 2022-05-20 12:11:28 -07:00
Simon Willison 18a6e05887
Added "follow a tutorial" to getting started docs 
Closes #1747
 2022-05-20 12:05:33 -07:00
Simon Willison 0e2f6f1f82
datasette-copyable is an example of register_output_renderer 2022-05-18 17:37:46 -07:00
Simon Willison b393e164dc
ReST fix 2022-05-17 12:45:28 -07:00
Simon Willison 5555bc8aef
How to run cog, closes #1745 2022-05-17 12:43:44 -07:00
Simon Willison 3508bf7875 --nolock mode to ignore locked files, closes #1744 2022-05-17 12:40:25 -07:00
Simon Willison a5acfff4bd
Empty Datasette([]) list is no longer required 2022-05-16 17:06:40 -07:00
Simon Willison 943aa2e1f7 Release 0.62a0 
Refs #1683, #1701, #1712, #1717, #1718, #1733
 2022-05-02 14:38:34 -07:00
Simon Willison 3f00a29141
Clean up compatibility with Pyodide (#1736) 
* Optional uvicorn import for Pyodide, refs #1733
* --setting num_sql_threads 0 to disable threading, refs #1735
 2022-05-02 13:15:27 -07:00
Simon Willison 687907aa2b Remove python-baseconv dependency, refs #1733, closes #1734 2022-05-02 12:39:06 -07:00
Simon Willison 94a3171b01
.plugin_config() can return None 2022-04-28 13:29:11 -07:00
Simon Willison c101f0efee
datasette-total-page-time example of asgi_wrapper 2022-04-26 15:34:29 -07:00
Simon Willison 7463b051cf Cosmetic tweaks after blacken-docs, refs #1718 2022-04-24 09:59:20 -07:00
Simon Willison 289e4cf80a Finished applying blacken-docs, closes #1718 2022-04-24 09:17:59 -07:00
Simon Willison 498e1536f5 One more blacken-docs test, refs #1718 2022-04-24 09:08:56 -07:00
Simon Willison 92b26673d8 Fix blacken-docs errors and warnings, refs #1718 2022-04-24 09:03:14 -07:00
Simon Willison 36573638b0 Apply Black to code examples in documentation, refs #1718 
Uses blacken-docs. This has a deliberate error which I hope will fail CI.
 2022-04-24 08:50:43 -07:00
Simon Willison e64d14e413 Use type integer for --timeout, refs #1717 2022-04-24 07:09:08 -07:00
Simon Willison 4bd3a30e1e Update cog docs for publish cloudrun, refs #1717 2022-04-24 07:04:11 -07:00
Simon Willison 8338c66a57
datasette-geojson is an example of register_output_renderer 2022-04-21 11:05:43 -07:00
Simon Willison 90d1be9952 Tilde encoding now encodes space as plus, closes #1701 
Refs #1657
 2022-04-06 08:55:01 -07:00
Simon Willison df88d03298
Warn about Cloud Run and bots 
Refs #1698
 2022-04-02 23:05:10 -07:00
Simon Willison 5c5e9b3657 Request.fake(... url_vars), plus .fake() is now documented 
Also made 'from datasette import Request' shortcut work.

Closes #1697
 2022-03-31 19:01:58 -07:00
Simon Willison e73fa72917
Fixed bug in httpx_mock example, closes #1691 2022-03-26 15:46:08 -07:00
Simon Willison bd8a58ae61
Fix message_type in documentation, closes #1689 2022-03-26 13:51:20 -07:00
Simon Willison 6b99e4a66b
Added missing hookimpl import 
Useful for copying and pasting to create a quick plugin
 2022-03-25 16:44:35 -07:00
Simon Willison d431a9055e Release 0.61.1 
Refs #1682

Refs https://github.com/simonw/datasette-hashed-urls/issues/13
 2022-03-23 11:54:10 -07:00
Simon Willison d7c793d799 Release 0.61 
Refs #957, #1228, #1533, #1545, #1576, #1577, #1587, #1601, #1603, #1607, #1612, #1621, #1649, #1654, #1657, #1661, #1668, #1675, #1678
 2022-03-23 11:12:26 -07:00
Simon Willison 1a7750eb29 Documented datasette.check_visibility() method, closes #1678 2022-03-21 12:01:37 -07:00
Simon Willison e627510b76 BaseView.check_permissions is now datasette.ensure_permissions, closes #1675 
Refs #1660
 2022-03-21 10:13:16 -07:00
Simon Willison 4a4164b811 Added another note to the 0.61a0 release notes, refs #1228 2022-03-19 18:23:03 -07:00
Simon Willison cb4854a435 Fixed typo 2022-03-19 18:17:58 -07:00
Simon Willison 5471e3c491 Release 0.61a0 
Refs #957, #1533, #1545, #1576, #1577, #1587, #1601, #1603, #1607, #1612, #1621, #1649, #1654, #1657, #1661, #1668
 2022-03-19 18:14:40 -07:00
Simon Willison 7a6654a253 Databases can now have a .route separate from their .name, refs #1668 2022-03-19 17:11:17 -07:00
Simon Willison 32963018e7 Updated documentation to remove hash_urls, refs #1661 2022-03-18 17:33:06 -07:00
Simon Willison 30e5f0e67c
Documented internals used by datasette-hashed-urls 
Closes #1663
 2022-03-17 14:30:02 -07:00
Simon Willison a35393b29c
Tilde encoding (#1659) 
Closes #1657

Refs #1439
 2022-03-15 11:01:57 -07:00
Simon Willison 1baa030eca
Switch to dash encoding for table/database/row-pk in paths 
* Dash encoding functions, tests and docs, refs #1439
* dash encoding is now like percent encoding but with dashes
* Use dash-encoding for row PKs and ?_next=, refs #1439
* Use dash encoding for table names, refs #1439
* Use dash encoding for database names, too, refs #1439

See also https://simonwillison.net/2022/Mar/5/dash-encoding/
 2022-03-07 07:38:29 -08:00
David Larlet 0499f174c0
Typo in docs about default redirect status code (#1589) 2022-03-05 17:58:31 -08:00
Simon Willison dd94157f89
Link to tutorials from documentation index page 2022-02-27 10:04:03 -08:00
Simon Willison 7d24fd405f
datasette-auth-passwords is now an example of register_commands 
Refs https://github.com/simonw/datasette-auth-passwords/issues/19
 2022-02-09 09:47:54 -08:00
Simon Willison fa5fc327ad Release 0.60.2 
Refs #1632
 2022-02-07 15:34:01 -08:00
Simon Willison fdce6f29e1 Reconfigure ReadTheDocs, refs #1176 2022-02-06 22:38:27 -08:00
Simon Willison d9b508ffaa @documented decorator plus unit test plus sphinx.ext.autodoc 
New mechanism for marking datasette.utils functions that should be covered by the
documentation, then testing that they have indeed been documented.

Also enabled sphinx.ext.autodoc which can now be used to embed the documented
versions of those functions.

Refs #1176
 2022-02-06 22:31:06 -08:00
Simon Willison 9b83ff2ee4
Fixed spelling of "raise" 2022-02-05 22:46:33 -08:00
Simon Willison 8a25ea9bca Implemented import shortcuts, closes #957 2022-02-05 22:34:33 -08:00
Simon Willison d25b55ab5e Fixed rST warnings 2022-02-05 22:32:23 -08:00
Simon Willison 1c6b297e3e Link to datasette.tracer from trace_debug docs, refs #1576 2022-02-04 21:28:35 -08:00
Simon Willison da53e0360d tracer.trace_child_tasks() for asyncio.gather tracing 
Also added documentation for datasette.tracer module.

Closes #1576
 2022-02-04 21:19:49 -08:00
Simon Willison 8d5779acf0 Refactored alternate_url_json mechanism, refs #1620, #1533 2022-02-02 13:32:47 -08:00
Simon Willison b72b2423c7 rel=alternate JSON for queries and database pages, closes #1620 2022-02-02 13:22:45 -08:00
Simon Willison 3ef47a0896 Link rel=alternate header for tables and rows 
Also added Access-Control-Expose-Headers: Link to --cors mode.

Closes #1533

Refs https://github.com/simonw/datasette-notebook/issues/2

LL#	metadata.json.1
 2022-02-01 23:49:09 -08:00
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
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