Datasette 1.0a35 — table creation and alteration APIs
Datasette 1.0a35 adds two major JSON APIs for schema management: Create Table and Alter Table, both with web UI backing.
• Create table interface via /<database>/-/create API; supports columns, primary keys, custom types, NOT NULL, defaults, foreign keys
• Alter table via /<database>/<table>/-/alter API; add, rename, reorder, drop columns; change types, defaults, constraints, keys
• New template context documentation for custom template variables