An open source multi-tool for exploring and publishing data
APACHE-2.0 License
Bot releases are hidden (Show)
Published by simonw over 1 year ago
datasette publish cloudrun
where deploys all used the same Docker image tag. This was mostly inconsequential as the service is deployed as soon as the image has been pushed to the registry, but could result in the incorrect image being deployed if two different deploys for two separate services ran at exactly the same time. #2036
Published by simonw almost 2 years ago
Published by simonw almost 2 years ago
datasette --setting default_allow_sql off
. See also Controlling the ability to execute arbitrary SQL. (#1409)<select>
elements in the table filter form now show an outline when they are currently focused. (#1771)Published by simonw almost 2 years ago
datasette --root
, when running in Docker, would only output the URL to sign in as root when the server shut down, not when it started up. (#1958)await datasette.invoke_startup()
has been called in order for Datasette to start correctly serving requests - this is now handled automatically the first time the server receives a request. This fixes a bug experienced when Datasette is served directly by an ASGI application server such as Uvicorn or Gunicorn. It also fixes a bug with the datasette-gunicorn plugin. (#1955)Published by simonw almost 2 years ago
The third Datasette 1.0 alpha release adds upsert support to the JSON API, plus the ability to specify finely grained permissions when creating an API token.
See Datasette 1.0a2: Upserts and finely grained permissions for an extended, annotated version of these release notes.
/db/table/-/upsert
API, documented here. upsert is an update-or-insert: existing rows will have specified keys updated, but if no row matches the incoming primary key a brand new row will be inserted instead. (#1878)/db/-/create
API for creating a table now accepts "ignore": true
and "replace": true
options when called with the "rows"
property that creates a new table based on an example set of rows. This means the API can be called multiple times with different rows, setting rules for what should happen if a primary key collides with an existing row. (#1927)"permissions"
key can be used to specify which actors should have which permissions. See Other permissions in metadata for details. (#1636)/-/create-token
page can now be used to create API tokens which are restricted to just a subset of actions, including against specific databases or resources. See API Tokens for details. (#1947)/db/-/create
API now requires actor to have insert-row
permission in order to use the "row"
or "rows"
properties. (#1937)Published by simonw almost 2 years ago
--cors
mode. See the full list of CORS headers in the documentation. (#1922)_memory
database could be written to even though writes were not persisted. (#1917)ephemeral
database which can be used to test Datasette's write APIs, using the new datasette-ephemeral-tables plugin to drop any created tables after five minutes. This database is only available if you sign in as the root user using the link on the homepage. (#1915)GET
request returned a 500 error. It now returns a 405 (method not allowed) error instead. (#1916)"ignore": true
and "replace": true
options for the insert API are now documented. (#1924)Published by simonw almost 2 years ago
This first alpha release of Datasette 1.0 introduces a brand new collection of APIs for writing to the database (#1850), as well as a new API token mechanism baked into Datasette core. Previously, API tokens have only been supported by installing additional plugins.
This is very much a preview: expect many more backwards incompatible API changes prior to the full 1.0 release.
Feedback enthusiastically welcomed, either through issue comments or via the Datasette Discord community.
/-/create-token
page allowing authenticated users to create signed API tokens that can act on their behalf, see API Tokens. (#1852)datasette create-token
command for creating tokens from the command line: datasette create-token./-/api
for trying out the API. (#1871)/db/-/create
API for Creating a table. (#1882)/db/table/-/insert
API for Inserting rows. (#1851)/db/table/-/drop
API for Dropping tables. (#1874)/db/table/pk/-/update
API for Updating a row. (#1863)/db/table/pk/-/delete
API for Deleting a row. (#1864)Published by simonw almost 2 years ago
datasette publish heroku
where deployments failed due to an older version of Python being requested. (#1905)datasette publish heroku --generate-dir <dir>
option for generating a Heroku deployment directory without deploying it.Published by simonw almost 2 years ago
<textarea>
if a query exceeds a time limit. (#1876)Published by simonw almost 2 years ago
See Datasette 0.63: The annotated release notes for more background on the changes in this release.
datasette publish
and datasette package
both now use that version of Python. (#1853)--load-extension
option now supports entrypoints. Thanks, Alex Garcia. (#1789)facet_size
table metadata option. (#1804)settings.json
file used in Configuration directory mode is now validated on startup. (#1816)/* ... */
or -- ...
syntax. Thanks, Charles Nepote. (#1860).sqlite
or .sqlite3
are now automatically added to the Datasette instance. (#1646)datasette
argument. Hook implementations can also now return an async
function which will be awaited automatically. (#1809)Database(is_mutable=)
now defaults to True
. (#1808)permissions=
list, allowing it to take multiple permissions into account at once when deciding if something should be shown as public or private. This has been used to correctly display padlock icons in more places in the Datasette interface. (#1829)Published by simonw almost 2 years ago
.sqlite
or .sqlite3
are now automatically added to the Datasette instance. (#1646)permissions=
list, allowing it to take multiple permissions into account at once when deciding if something should be shown as public or private. This has been used to correctly display padlock icons in more places in the Datasette interface. (#1829)Published by simonw about 2 years ago
datasette
argument. Hook implementations can also now return an async
function which will be awaited automatically. (#1809)--load-extension
option now supports entrypoints. Thanks, Alex Garcia. (#1789)facet_size
table metadata option. (#1804)truncate_cells_html
setting now also affects long URLs in columns. (#1805)Database(is_mutable=)
now defaults to True
. (#1808)settings.json
file used in Configuration directory mode is now validated on startup. (#1816)Published by simonw about 2 years ago
Datasette can now run entirely in your browser using WebAssembly. Try out Datasette Lite, take a look at the code or read more about it in Datasette Lite: a server-side Python web application running in a browser.
Datasette now has a Discord community for questions and discussions about Datasette and its ecosystem of projects.
_facet_results.html
and _suggested_facets.html
. Thanks, M. Nasimul Haque. (#1759)--nolock
option for ignoring file locks when opening read-only databases. (#1744)+
rather than ~20
. (#1701)<Binary: 2427344 bytes>
is now displayed as <Binary: 2,427,344 bytes>
and is accompanied by tooltip showing "2.3MB". (#1712)datasette publish cloudrun
, datasette package
and the official Datasette image has been upgraded to 3.10.6-slim-bullseye
. (#1768)datasette publish cloudrun
has a new --timeout
option which can be used to increase the time limit applied by the Google Cloud build environment. Thanks, Tim Sherratt. (#1717)datasette publish cloudrun
has new --min-instances
and --max-instances
options. (#1779)row
argument, representing the sqlite3.Row
object that is being rendered. (#1300)datasette.config_dir
, making it available to plugins. Thanks, Chris Amico. (#1766)?_sort
and ?_sort_desc
now work if the column that is being sorted has been excluded from the query using ?_col=
or ?_nocol=
. (#1773)?_sort_desc
was duplicated in the URL every time the Apply button was clicked. (#1738)Request.fake()
method is now documented, see Request object.Published by simonw over 2 years ago
row
argument, representing the sqlite3.Row
object that is being rendered. (#1300)--nolock
option for ignoring file locks when opening read-only databases. (#1744)_facet_results.html
and _suggested_facets.html
. Thanks, M. Nasimul Haque. (#1759)Published by simonw over 2 years ago
datasette publish cloudrun
has a new --timeout
option which can be used to increase the time limit applied by the Google Cloud build environment. Thanks, Tim Sherratt. (#1717)+
rather than ~20
. (#1701)<Binary: 2427344 bytes>
is now displayed as <Binary: 2,427,344 bytes>
and is accompanied by tooltip showing "2.3MB". (#1712)Request.fake()
method is now documented, see Request object.Published by simonw over 2 years ago
Published by simonw over 2 years ago
In preparation for Datasette 1.0, this release includes two potentially backwards-incompatible changes. Hashed URL mode has been moved to a separate plugin, and the way Datasette generates URLs to databases and tables with special characters in their name such as /
and .
has changed.
Datasette also now requires Python 3.7 or higher.
See also the annotated release notes.
a-zA-Z0-9_-
. This scheme is explained here: Tilde encoding. (#1657)datasette-hashed-urls
plugin can be used to achieve the same result, see datasette-hashed-urls for details. (#1661)db.route
property. (#1668)<link rel="alternate" type="application/json+datasette" href="...">
element and return a Link: URL; rel="alternate"; type="application/json+datasette"
HTTP header pointing to the JSON version of those pages. (#1533)Access-Control-Expose-Headers: Link
is now added to the CORS headers, allowing remote JavaScript to access that header.sqlite_stat
tables are now hidden by default. (#1587)data_licenses
, KNN
and KNN2
are now hidden by default. (#1601)asyncio
sub-tasks, such as those created by asyncio.gather()
. (#1576)datasette
package, see Import shortcuts. Those symbols are Response
, Forbidden
, NotFound
, hookimpl
, actor_matches_allow
. (#957)/-/versions
page now returns additional details for libraries used by SpatiaLite. (#1607)/opt/homebrew
- thanks, Dan Peterson. (#1649)n
. (#1228)Published by simonw over 2 years ago
datasette-hashed-urls
plugin can be used to achieve the same result, see datasette-hashed-urls for details. (#1661)db.route
property. (#1668)a-zA-Z0-9_-
. This scheme is explained here: Tilde encoding. (#1657)<link rel="alternate" type="application/json+datasette" href="...">
element and return a Link: URL; rel="alternate"; type="application/json+datasette"
HTTP header pointing to the JSON version of those pages. (#1533)Access-Control-Expose-Headers: Link
is now added to the CORS headers, allowing remote JavaScript to access that header.sqlite_stat
tables are now hidden by default. (#1587)data_licenses
, KNN
and KNN2
are now hidden by default. (#1601)asyncio
sub-tasks, such as those created by asyncio.gather()
. (#1576)datasette
package, see Import shortcuts. Those symbols are Response
, Forbidden
, NotFound
, hookimpl
, actor_matches_allow
. (#957)/-/versions
page now returns additional details for libraries used by SpatiaLite. (#1607)/opt/homebrew
- thanks, Dan Peterson. (#1649)Published by simonw over 2 years ago