#0001
`Datasette` `1.0a31` adds write SQL and stored queries
60radar
DatasetteSQLite data tool — publishes DBs as web UI and APIs
Permissions now cover insert/update/delete workflows directly in the SQL UI. Good fit for lightweight internal admin tools on SQLite, but still alpha.
- Users with the right permissions can run write queries against a database, turning
Datasettefrom read-only browsing into a small data editing surface. - Stored queries replace the old canned-query naming and can be saved privately or shared with other members of the same instance.
- The new execute-query UI starts from templated
insert,update, anddeletequeries for editable tables, reducing hand-written SQL mistakes. - Permission checks block operations like
create tablewhen the user lacks that grant, so this can back simple ops panels without opening full DB access.
Source: simonwillison.net/2026/May/29/datasette/#atom-everythingRead original →