datasette 1.0a34
Summary
Datasette 1.0a34, an alpha release of the open-source multi-tool designed for exploring and publishing data, was announced on June 16, 2026. This significant update introduces the long-awaited ability for users to insert, edit, and delete rows directly within the Datasette interface. These new data manipulation features are available on table pages and as action items on individual row pages. The inspiration for integrating these capabilities into the main UI came from Datasette Agent, which recently gained SQL write support via its chat interface. This development underscored the previous absurdity of being able to modify data through an agent but not directly within the primary Datasette user interface.
Key takeaway
For data professionals managing small to medium datasets, Datasette 1.0a34 significantly enhances its utility by enabling direct data manipulation. If you currently use Datasette for exploration, you can now perform basic insert, edit, and delete operations without external tools or SQL interfaces. This update streamlines workflows for quick data adjustments, reducing the need to switch contexts for minor modifications. Consider upgrading to this alpha to evaluate its impact on your data management efficiency.
Key insights
Datasette 1.0a34 adds direct data editing to its UI, inspired by its agent's SQL write capabilities.
In practice
- Directly modify data in Datasette tables.
- Edit and delete rows via table or row pages.
- Use Datasette for basic data management tasks.
Topics
- Datasette
- Data Publishing
- Data Exploration
- Data Management
- Open-Source Software
Code references
Best for: Data Scientist, Data Engineer, Software Engineer
Related on AIssential
Editorial summary, takeaway, and curation by AIssential. Original article published by Simon Willison's Weblog.