Datasette 1.0a31 Enables Write Queries and Stored Queries
Enable write queries and stored queries for users with permissions.
Grant write permissions and test new UI.
Summary
Datasette 1.0a31 introduces the ability for users with the necessary permissions to execute write SQL queries directly from the interface. The release also adds a feature to save stored queries—formerly called canned queries—either privately or for sharing with other members of the Datasette instance. Permission checks prevent users without create‑table rights from executing CREATE TABLE statements.
The new UI guides users through templated insert, update, and delete queries, and the feature is documented in a blog post with an animated demo. The update expands Datasette’s functionality from read‑only data exploration to full CRUD operations, making it more suitable for collaborative data projects.
Key changes
- Users with permission can execute write SQL queries via new UI.
- Stored queries (renamed from canned queries) can be saved privately or shared.
- Permission checks prevent unauthorized CREATE TABLE statements.
- UI shows insert/update/delete templates for editable tables.
- Feature documented in blog post and animated demo.