Datasette 1.0a35 ships two new JSON APIs and a full schema management UI. The /<database>/-/create endpoint lets you define columns, primary keys, custom column types, NOT NULL constraints, literal and expression defaults, and single-column foreign keys. The /<database>/<table>/-/alter endpoint covers the full lifecycle: add, rename, reorder, and drop columns; change types, defaults, constraints, and foreign keys; rename the table; and drop it entirely.
The third major addition is formal Template Context documentation, listing every variable available to custom templates for Datasette's core pages. Those variables are now treated as a stable API until Datasette 2.0. The docs are generated directly from dataclass definitions in the view code and validated by tests that compare documented fields against live-rendered contexts for the database, table, query, and row pages.
The full release notes and a video walkthrough of the create and alter table UI are worth your time. This is the release where Datasette starts looking like a serious database management tool, not just a read-only data browser. The stable template API decision alone has consequences for every plugin author building on the platform.
[READ ORIGINAL →]