Simon Willison — 2026-06-23#

Highlight#

The standout news today is a massive step forward for Datasette’s mutation capabilities in the 1.0a35 release, introducing powerful new graphical interfaces for creating and altering tables. This shifts Datasette further from its read-only roots toward a full-fledged database management UI.

Posts#

datasette 1.0a35 Simon dropped a major pre-release for Datasette that introduces powerful new “Create table” and “Alter table” graphical interfaces, complete with their own backing JSON APIs. Users can now seamlessly define columns, NOT NULL constraints, and foreign keys, or modify existing tables by adding, dropping, or reordering columns directly from the UI. Additionally, the release formalizes the template context variables, generated directly from dataclass definitions, into a stable API for custom template authors to use until Datasette 2.0. Simon also shared a quick video demo walking through the new table mutation features.

Simon Willison — Week of 2026-06-18 to 2026-06-25#

Highlight of the Week#

This week’s absolute standout is the launch of the datasette-apps plugin, which fundamentally transforms how we build micro-applications over local databases. By utilizing tightly constrained iframe sandboxes and Content-Security-Policy headers, developers and LLMs alike can safely run custom HTML/JS interfaces against a persistent Datasette backend. It brilliantly merges Simon’s ongoing experiments with AI-assisted “vibe coding” and robust security architectures into a core ecosystem feature, effectively bridging the gap between Claude Artifacts and secure data environments.