Simon Willison has released datasette 1.0a34, an alpha version of his open-source data exploration tool that finally introduces native row editing capabilities. This update adds functionality to insert, edit, and delete rows directly within the application interface, a feature long anticipated by the community. The new tools are accessible from table pages, while individual row pages now display action items for modifying specific entries. Willison cites the recent addition of SQL write support to Datasette Agent as the primary catalyst for this change, noting the inconsistency of allowing data manipulation through a chat interface while the standard UI remained read-only.
This development matters because it bridges a significant gap between datasette’s traditional role as a static viewer and its potential as a full-stack data management platform. By enabling direct data modification, the tool allows developers and analysts to prototype databases and manage small datasets without needing to deploy separate backend services or write custom code. It aligns the user experience with modern expectations where data exploration and manipulation occur in the same environment, reducing friction for rapid iteration. The move signals a shift towards making datasette a more robust solution for personal projects and internal tools where simplicity and speed are prioritised over enterprise-grade security features.
* Native row editing and deletion are now available directly within the datasette interface for the first time.
* The feature addresses the previous inconsistency where data could be modified via the Agent chat interface but not the standard UI.
* Users can now manage small datasets more efficiently without requiring additional backend infrastructure.
