datasette 1.0a35
Simon Willison · Simon Willison · 2026-06-23
Simon Willison releases Datasette 1.0a35, adding a new Create table interface, an Alter table interface with full schema modification capabilities, and stable Template context documentation for custom templates.
Appears in
Extraction
Topics: datasettesqliteopen-source-toolsweb-development
Claims
- Datasette 1.0a35 introduces a new Create table interface backed by a JSON API that supports columns, primary keys, custom column types, NOT NULL constraints, defaults, and single-column foreign keys.
- The new Alter table feature allows adding, renaming, reordering, and dropping columns; changing types, defaults, constraints, and primary/foreign keys; and renaming or dropping the table entirely.
- Template context documentation now defines a stable API of variables available to custom templates until Datasette 2.0, generated from dataclass definitions with test coverage.
Key quotes
I'll write more about this one tomorrow, but it's a big release.
Variables documented there are treated as a stable API for custom templates until Datasette 2.0.