datasette 1.0a31
Datasette 1.0a31 adds permission-gated write SQL execution and stored queries.
Simon Willison released Datasette 1.0a31, a significant alpha release with two headline features: write SQL execution and stored queries. Users with the right permissions can now run database-changing queries and save queries privately or for other members of a Datasette instance. The new interface can generate templated insert, update, and delete queries for editable tables while blocking unauthorized actions such as creating tables without permission.
Simon Willison announced Datasette 1.0a31, another important alpha release on Datasette's path toward 1.0. The focus of this update is not AI models, but an expansion of the data tool's own capabilities, especially for use cases that require operating on the database directly within Datasette. The new version has two main features: first, users with the necessary permissions can now execute write SQL queries against the database; second, users can save queries, a feature that has also been renamed from the previous "canned queries" to "stored queries."
Free shows the 3-line summary; Pro unlocks the full deep summary (~300 words) so you never have to click through.
See Pro plans →Want the original English / full article?
Read on Simon Willison's Weblog →Summaries are AI-generated; the original article is authoritative.