source: simon willison: datasette 1.0a34
level: technical
datasette 1.0a34, the latest alpha release of the open source data exploration tool, now lets users insert, edit, and delete rows through its web interface. these write operations appear on table pages, while edit and delete are also available as actions on individual row pages. the feature was prompted by recent work on datasette agent, which added sql write support and made it clear that the main ui lacked these basic capabilities.
the update closes a long-standing gap where users could modify data via the experimental chat interface but not through the standard datasette ui. by bringing row-level editing into the core tool, datasette becomes more practical for quick data fixes and interactive data management without switching to external database clients. the change is part of the ongoing 1.0 alpha series, which has been gradually stabilizing the platform.
datasette remains a versatile tool for publishing and exploring sqlite databases, often used by journalists, researchers, and developers. this release continues its evolution toward a full-featured data workspace, blending read and write operations in a single interface. the project is maintained by simon willison, who regularly shares annotated release notes and sponsors development through a monthly briefing on llm developments.
why it matters: adding direct row editing makes datasette more useful for ai and data science workflows that need quick, in-browser data manipulation without leaving the analysis environment.
source: simon willison: datasette 1.0a34