Release: datasette 1.0a31 (https://github.com/simonw/datasette/releases/tag/1.0a31)

    Another significant alpha release, with two new headline features.

Datasette now offers users with the necessary permissions the ability to both execute write queries against their database and to save stored queries (renamed from “canned queries”) both privately and for use by other members of their Datasette instance.

There’s more detail in SQL write queries and stored queries in Datasette 1.0a31 (https://datasette.io/blog/2026/sql-write-queries/) on the Datasette blog, which now has three posts introducing new features (https://datasette.io/blog/) since the blog launched two weeks ago.

Here’s an animated demo from the blog post (https://datasette.io/blog/2026/sql-write-queries/) showing how the new execute query interface lets people get started with templated insert/update/delete queries from tables they have permission to edit:

    Tags: projects (https://simonwillison.net/tags/projects), sql (https://simonwillison.net/tags/sql), sqlite (https://simonwillison.net/tags/sqlite), datasette (https://simonwillison.net/tags/datasette), annotated-release-notes (https://simonwillison.net/tags/annotated-release-notes)