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

280 Commity (scan-dirs)

Autor SHA1 Wiadomość Data
Simon Willison 1c518680e9
Final steps: build stable branch of Read The Docs 2019-11-11 21:57:48 -08:00
Simon Willison 76fc6a9c73 Release notes for 0.31 2019-11-11 21:18:17 -08:00
Simon Willison cf7776d36f
Support Python 3.8, stop supporting Python 3.5 (#627) 
* Upgrade to uvicorn 0.10.4
* Drop support for Python 3.5
* Bump all dependencies to latest releases
* Update docs to reflect we no longer support 3.5
* Removed code that skipped black unit test on 3.5

Closes #622
 2019-11-11 21:09:11 -08:00
Simon Willison 10b9d85eda
datasette-csvs on Glitch now uses sqlite-utils 
It previously used csvs-to-sqlite but that had heavy dependencies.

See https://support.glitch.com/t/can-you-upgrade-python-to-latest-version/7980/33
 2019-11-08 18:15:13 -08:00
Simon Willison 9f5d19c254
Improved documentation for "publish cloudrun" 2019-11-08 18:12:20 -08:00
Simon Willison c30f07c58e Removed _group_count=col feature, closes #504 2019-11-05 21:12:55 -08:00
Simon Willison 9db22cdf18 pk__notin= filter, closes #614 2019-11-03 20:11:55 -08:00
Simon Willison c3181d9a84 Release notes for 0.30.2 2019-11-02 15:47:20 -07:00
Simon Willison ed57e4f990 Plugin static assets support both hyphens and underscores in names 
Closes #611
 2019-11-01 15:15:10 -07:00
Simon Willison ffae2f0ecd Better documentation of --host, closes #574 2019-11-01 14:57:49 -07:00
Simon Willison f5f6cbe03c Release 0.30.1 2019-10-30 11:56:04 -07:00
Simon Willison debea4f971 Release 0.30 2019-10-18 18:06:37 -07:00
Simon Willison a314b76186 Added /-/threads debugging page 2019-10-02 08:35:25 -07:00
Simon Willison 0fc8afde0e Changelog for 0.29.3 release 2019-09-02 17:40:53 -07:00
Min ho Kim 27cb29365c Fix numerous typos (#561) 
Thanks, @minho42!
 2019-07-26 13:25:44 +03:00
Simon Willison 6abe6faff6 Release 0.9.2 2019-07-13 20:04:05 -07:00
Simon Willison f2006cca80 Updated release notes 2019-07-11 09:27:28 -07:00
Simon Willison 2a94f3719f Release 0.29.1 2019-07-11 09:17:55 -07:00
Simon Willison fb7ee8e0ad Changelog for 0.29 release 2019-07-07 20:14:27 -07:00
Simon Willison 973f8f139d
--plugin-secret option for datasette publish 
Closes #543

Also added new --show-files option to publish now and publish cloudrun - handy for debugging.
 2019-07-07 19:06:31 -07:00
Simon Willison 2d04986c44 Added datasette-auth-github and datasette-cors plugins to Ecosystem 
Closes #548
 2019-07-07 19:02:27 -07:00
Simon Willison aa4cc99c02 Removed facet-by-m2m from docs, refs #550 
Will bring this back in #551
 2019-07-07 18:22:05 -07:00
Simon Willison 9998f92cc0 Updated custom facet docs, closes #482 2019-07-07 16:19:02 -07:00
Simon Willison fcfcae21e6
extra_template_vars plugin hook (#542) 
* extra_template_vars plugin hook

Closes #541

* Workaround for cwd bug

Based on https://github.com/pytest-dev/pytest/issues/1235#issuecomment-175295691
 2019-07-05 17:05:56 -07:00
Simon Willison a2d4593193
Secret plugin configuration options (#539) 
Closes #538
 2019-07-03 22:36:44 -07:00
Simon Willison 4d2fdafe39 Added asgi_wrapper plugin hook, closes #520 2019-07-02 21:06:25 -07:00
Simon Willison b9ede4c189 Updated custom template docs, refs #521 2019-07-02 20:23:05 -07:00
Simon Willison e7120d91f6 Rename _rows_and_columns.html to _table.html, refs #521 2019-07-02 20:23:05 -07:00
Simon Willison 7688283054
Typo 2019-06-25 08:36:39 -07:00
Simon Willison 9e97b725f1 pip install -e .[docs] for docs dependencies 2019-06-25 05:08:04 -07:00
Simon Willison 6341f8cbc7 Better coverage of sqlite-utils in FTS docs, closes #525 2019-06-24 09:28:42 -07:00
Simon Willison cdd24f3eaa
Added datasette-doublemetaphone to list of plugins 2019-06-23 21:23:24 -07:00
Tom MacWright aa911122fe Fix typo in install step: should be install -e (#500) 2019-06-11 11:48:40 -07:00
Simon Willison 6ccfcefb78
Added datasette-render-binary plugin to ecosystem 2019-06-09 09:49:06 -07:00
Simon Willison 0c756b8cd9
Added datasette-bplist plugin to ecosystem 2019-06-08 19:11:59 -07:00
Simon Willison 803f750309
Added datasette-jq plugin to ecosystem 2019-05-29 18:51:10 -07:00
Simon Willison bd4dbc8519 Rename InterruptedError => QueryInterrupted, closes #490 2019-05-27 17:16:36 -07:00
Simon Willison d923d84754 Facet by many-to-many, closes #365 2019-05-25 09:06:32 -07:00
Simon Willison 172da009d8 Added ?_through= table argument, closes #355 
Also added much more interesting many-to-many fixtures - roadside attractions!
 2019-05-22 22:45:12 -07:00
Simon Willison 967230c90e Facet by date, closes #481 2019-05-20 23:09:22 -07:00
Thomas Wood 70d2858067 Doc typo fix (#479) 2019-05-20 09:42:28 -07:00
Simon Willison 4246e138f9
Typo fix 2019-05-19 16:14:09 -07:00
Simon Willison 17243fc355 Release notes for 0.28 - closes #463 2019-05-19 14:24:12 -07:00
Simon Willison a9d138702c Docs for facet-by-JSON-array, closes #477 2019-05-19 14:19:35 -07:00
Simon Willison 88976d6cd6 Source, license and about docs - closes #475 2019-05-19 13:13:27 -07:00
Simon Willison 503fee891b Removed 'datasette skeleton', closes #476 2019-05-19 13:05:38 -07:00
Simon Willison 2600858388 Fixed some links 2019-05-19 11:17:35 -07:00
Simon Willison 870f6dd55f Replaced a straggling 'datasette publish now' reference 2019-05-19 11:12:53 -07:00
Simon Willison 7d8573d672 Rename "datasette publish now" to "datasette publish nowv1" 
Also added an alias so "datasette publish now" continues to work.

Closes #472
 2019-05-19 11:06:51 -07:00
Simon Willison 81ba98a509 New performance documentation, closes #421 2019-05-18 22:31:03 -07:00
Simon Willison 0dad111d24 New introspection endpoint: /-/databases - closes #470 
Refs #419 and #465
 2019-05-16 07:49:34 -07:00
Simon Willison 1937026766
Removed accidental R 2019-05-16 06:27:08 -07:00
Simon Willison f31b9fe5ca
Another link to Glitch 2019-05-16 06:26:46 -07:00
Simon Willison 7c79eb974b
It's 2019 now 2019-05-16 03:20:08 -07:00
Simon Willison a464594475
Added inline contents for installation page 2019-05-16 03:15:03 -07:00
Simon Willison a88b599cce Improved introduction copy on Plugins docs page 2019-05-15 22:18:02 -07:00
Simon Willison 725b5b6a69 Re-ordered documentation index page 2019-05-15 22:14:33 -07:00
Simon Willison 12350e8b8a Fixed broken link to global-power-plants demo 2019-05-15 22:12:36 -07:00
Simon Willison 8461b930d5 Wording tweaks 2019-05-15 22:09:06 -07:00
Simon Willison 8d639dd096 Docs on how to use sphinx-autobuild 2019-05-15 22:03:37 -07:00
Simon Willison 623c552ff4 'Try Datasette without installing anything using Glitch' 
Also new 'Play with a live demo' section, both at the top of the Getting
Started documentation page.

https://datasette.readthedocs.io/en/latest/getting_started.html

Closes #464
 2019-05-15 21:57:36 -07:00
Simon Willison c0d1b4c322 "datasette inspect foo.db" now just calculates table counts 
Refs #462

* inspect command now just outputs table counts
* test_inspect.py is now only tests for that CLI command
* Updated some relevant documentation
* Removed docs for /-/inspect since that is about to change
 2019-05-11 14:36:57 -07:00
Simon Willison 37adf32290 Changelog for 0.27.1 2019-05-11 11:34:13 -07:00
Simon Willison f825e20121 Run black and update docs for #457 2019-05-09 09:48:13 -07:00
Jaap Roes f853d5592e "python3 -m pip" is clearer (thanks @jaap3) (#368) 2019-05-03 14:18:42 -04:00
Simon Willison bade9daeb2 Docs for 'datasette publish cloudrun', refs #434 2019-05-03 12:16:58 -04:00
Russ Garrett bf229c9bd8 Pass view_name to extra_body_script hook (#443) 
At the moment it's not easy to tell whether the hook is being called
in (for example) the row or table view, as in both cases the
`database` and `table` parameters are provided.

This passes the `view_name` added in #441 to the `extra_body_script`
hook.
 2019-05-03 09:12:19 -04:00
Simon Willison ea66c45df9
Extract facet code out into a new plugin hook, closes #427 (#445) 
Datasette previously only supported one type of faceting: exact column value counting.

With this change, faceting logic is extracted out into one or more separate classes which can implement other patterns of faceting - this is discussed in #427, but potential upcoming facet types include facet-by-date, facet-by-JSON-array, facet-by-many-2-many and more.

A new plugin hook, register_facet_classes, can be used by plugins to add in additional facet classes.

Each class must implement two methods: suggest(), which scans columns in the table to decide if they might be worth suggesting for faceting, and facet_results(), which executes the facet operation and returns results ready to be displayed in the UI.
 2019-05-02 17:11:26 -07:00
Simon Willison efc93b8ab5 Entirely removed table_rows_count table property 
We were not displaying this anywhere, and it is now expensive to calculate.

Refs #419, #420
 2019-05-01 22:29:47 -07:00
Russ Garrett cf406c0754 New plugin hook: register_output_renderer hook (#441) 
Thanks @russss!

* Add register_output_renderer hook

This changeset refactors out the JSON renderer and then adds a hook and
dispatcher system to allow custom output renderers to be registered.

The CSV output renderer is untouched because supporting streaming
renderers through this system would be significantly more complex, and
probably not worthwhile.

We can't simply allow hooks to be called at request time because we need
a list of supported file extensions when the request is being routed in
order to resolve ambiguous database/table names. So, renderers need to
be registered at startup.

I've tried to make this API independent of Sanic's request/response
objects so that this can remain stable during the switch to ASGI. I'm
using dictionaries to keep it simple and to make adding additional
options in the future easy.

Fixes #440
 2019-05-01 16:01:56 -07:00
Simon Willison 9d73e3c8bd Note that trace data format is very likely to change, refs #435 2019-04-21 10:53:28 -07:00
Simon Willison 58a862cee4 ?_trace=1 now adds SQL trace info to JSON/HTML response 
Also added documentation for it. Refs #435
 2019-04-21 10:41:16 -07:00
Simon Willison 31f36e1b97
Added some guidelines 
Mainly to remind me that master needs to be releasable at all times!
 2019-04-20 11:32:40 -07:00
Simon Willison 583b22aa28 New ?column__date=yyyy-mm-dd filter 2019-04-15 15:54:54 -07:00
Simon Willison 1c6649b19b New colname__in=x,y,z filter, closes #433 2019-04-15 15:43:22 -07:00
Simon Willison 2c19a27d15 Documentation for filters, plus new documentation unit test 
https://simonwillison.net/2018/Jul/28/documentation-unit-tests/
 2019-04-15 15:41:11 -07:00
Simon Willison 9dc7a1824b
Slightly more interesting example link 2019-04-13 15:49:07 -07:00
Simon Willison f2c767c222 Fixed broken link in documentation 2019-04-12 18:57:43 -07:00
Simon Willison bc6a9b4564
?_where= parameter on table views, closes #429 
From pull request #430
 2019-04-12 18:37:22 -07:00
Simon Willison db74cf0144 ?_fts_table= and ?_fts_pk= arguments, closes #428 2019-04-11 21:21:17 -07:00
Simon Willison 53bf875483 expand_foreign_keys() no longer uses inspect, refs #420 2019-04-06 19:56:07 -07:00
Simon Willison 47032636b5 'datasette serve -i immutable.db' option, refs #419 2019-03-17 16:25:15 -07:00
Simon Willison 6f6d0ff2b4
URL hashing is now off by default - closes #418 
Prior to this commit Datasette would calculate the content hash of every
database and redirect to a URL containing that hash, like so:

    https://v0-27.datasette.io/fixtures => https://v0-27.datasette.io/fixtures-dd88475

This assumed that all databases were opened in immutable mode and were not
expected to change.

This will be changing as a result of #419 - so this commit takes the first step
in implementing that change by changing this default behaviour. Datasette will
now only redirect hash-free URLs under two circumstances:

* The new `hash_urls` config option is set to true (it defaults to false).
* The user passes `?_hash=1` in the URL
 2019-03-17 15:55:04 -07:00
joelondon 9e8c36793b Update spatialite.rst (#413) 
a line of sql added to create the idx_<table_name> in the python recipe
 2019-03-14 22:06:45 -07:00
Simon Willison 9743e1d91b Support for :memory: databases 
If you start Datasette with no files, it will connect to :memory: instead.

When starting it with files you can add --memory to also get a :memory: database.
 2019-03-14 20:54:42 -07:00
Simon Willison bf6b0f918d about and about_url metadata options 2019-03-14 20:54:42 -07:00
Simon Willison 41744d7690
Added datasette-jellyfish 2019-03-09 10:43:12 -08:00
Simon Willison 4147c388cb
Link to sqlite-utils blog entry 2019-03-07 20:30:21 -08:00
Simon Willison 1f91065b20
Added socrata2sql to the ecosystem page 
A fantastic new tool created by @achavez at the Dallas Morning News.
 2019-02-08 08:06:10 -08:00
Simon Willison d5d39da12b
Expanded section on db-to-sqlite 2019-02-07 22:23:27 -08:00
Simon Willison 436b8bc1d1 Datasette 0.27 2019-01-31 19:47:05 -08:00
Simon Willison b944bcd0f0 Added documentation on the Datasette Ecosystem 
https://datasette.readthedocs.io/en/latest/ecosystem.html
 2019-01-31 19:36:07 -08:00
Simon Willison b5dd83981a Export option: _shape=array&_nl=on for newline-delimited JSON 2019-01-27 17:40:23 -08:00
Simon Willison 909cc8fbdf New 'datasette plugins' command to list installed plugins 2019-01-26 12:01:16 -08:00
Simon Willison 4722acc73c Release 0.26.1 2019-01-10 16:51:38 -08:00
Simon Willison 8ce7866312 compile_options output in /-/versions, closes #396 2019-01-10 16:44:50 -08:00
Simon Willison 5b02611512
Corrected import path in plugin docs 2019-01-08 16:25:29 -08:00
Simon Willison 424e146697 Datasette 0.26 release notes 2019-01-02 18:53:59 -08:00
Simon Willison d95b46b09b datasette publish now --alias option 
You can now use --alias to attempt to alias after you deploy.

Also updated now.json to use version: 1
 2019-01-01 21:15:54 -08:00
Simon Willison eac08f0dfc
--reload now also reloads if databases change on disk 2018-12-20 07:51:08 -08:00