Summary & Key Takeaways ​

• Datasette 1.0a35 introduces a new 'Create table' interface with JSON API backing.
• Users can now define columns, primary keys, custom types, and foreign keys.
• A new 'Alter table' action allows modifying existing tables, including column changes and renaming.
• The alter table dialog also includes a 'Drop table' button.
• Stable Template context documentation is now available for custom templates.
• This documentation is generated from dataclass definitions and tested against actual contexts.

Our Commentary ​

Datasette just keeps getting better. These new create/alter table features are huge. It's moving from a data exploration tool to something you can genuinely use for light database management. I've always loved how Simon builds in public, and seeing these capabilities land is exciting. It makes Datasette even more compelling for quick data projects. We're seeing a trend of powerful, lightweight tools that just work.