datasette 1.0a31

2026-05-29 · Source: Simon Willison's Weblog · Field: Technology & Digital — Data Science & Analytics, Software Development & Engineering · Depth: Intermediate, quick

Summary

Datasette 1.0a31, released on May 29th, 2026, introduces significant new features to this open-source multi-tool for exploring and publishing data. This alpha release now allows users with appropriate permissions to execute SQL write queries directly against their databases. Additionally, it enables users to save "stored queries" (formerly "canned queries") for private use or to share with other members of their Datasette instance. The update enhances data interaction capabilities, moving beyond read-only operations to include templated insert, update, and delete functionalities, as demonstrated in a recent blog post. This marks a notable expansion of Datasette's utility for data management.

Key takeaway

For data professionals managing and sharing datasets with Datasette, this release significantly enhances your operational capabilities. You can now directly modify data and save frequently used queries, streamlining workflows and improving collaboration within your instance. Consider updating to 1.0a31 to utilize these new write and query management features, enabling more dynamic data interaction and reducing reliance on external tools for basic data manipulation.

Key insights

Datasette 1.0a31 expands data interaction by enabling SQL write queries and persistent query storage.

Method

Users can execute templated insert/update/delete queries via a new interface, selecting actions and then "Execute write SQL" from a database page.

In practice

• Execute templated INSERT/UPDATE/DELETE queries
• Save queries for private or shared use

Topics

• Datasette
• SQL Write Queries
• Stored Queries
• Data Exploration
• Open-Source
• Data Publishing

Best for: Data Scientist, Data Engineer, Software Engineer

Related on AIssential

• datasette 1.0a32 — Minor releases are crucial for maintaining system stability and addressing specific integration challenges.
• datasette-extract 0.3a0 — Datasette-extract 0.3a0 integrates with datasette-llm for configurable unstructured data extraction.
• Firestore Adds Pipeline Operations with Over 100 New Query Features — Firestore Enterprise now offers advanced pipeline queries and optional indexing, enhancing its NoSQL capabilities.
• Database Performance Strategies and Their Hidden Costs — Database optimization involves inherent tradeoffs where improving one metric often negatively impacts another.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Simon Willison's Weblog.