telexed ~ c / 9b119a90-5d6radar:60 · infra_saasLIVE
← back
NO.
#9b119a90
Topic
INFRA & SAAS
Source
Simon Willison
Published
2026-05-29 03:32:02
Importance
★ 6/10 — radar 60

`Datasette` `1.0a31` adds write SQL and stored queries

Permissions now cover insert/update/delete workflows directly in the SQL UI. Good fit for lightweight internal admin tools on SQLite, but still alpha.

[ KEY POINTS ]
  1. Users with the right permissions can run write queries against a database, turning Datasette from read-only browsing into a small data editing surface.
  2. Stored queries replace the old canned-query naming and can be saved privately or shared with other members of the same instance.
  3. The new execute-query UI starts from templated insert, update, and delete queries for editable tables, reducing hand-written SQL mistakes.
  4. Permission checks block operations like create table when the user lacks that grant, so this can back simple ops panels without opening full DB access.
Originalsimonwillison.net/2026/May/29/datasette/#atom-everythingRead original →

// related