Simon Willison — Week of 2026-04-11 to 2026-04-17#

Highlight of the Week#

This week’s most striking revelation came from Simon’s infamous “pelican riding a bicycle” SVG generation benchmark, where a 21GB quantized local model (Qwen3.6-35B-A3B) unexpectedly outperformed Anthropic’s brand-new Claude Opus 4.7 flagship. Running locally on a MacBook Pro via LM Studio, Qwen generated a better bicycle frame and even won a secret unicycle backup test, leading Simon to conclude that his joke benchmark’s long-standing correlation with general model utility has finally broken down.

Simon Willison — Week of 2026-05-22 to 2026-05-29#

Highlight of the Week#

This week’s most significant milestone is the release of Datasette 1.0a31, which fundamentally shifts the project’s paradigm by introducing UI support for executing write queries directly against the database. This officially bridges Datasette from a purely read-only tool to one that embraces secure data mutation, allowing developers to save and template insert, update, and delete operations.

Key Posts#

[I think Anthropic and OpenAI have found product-market fit] · Source Simon analyzes the shift in enterprise pricing to argue that AI coding agents have crossed the threshold into massive usage and real revenue generation. He points to Anthropic’s staggering $1.25 billion monthly compute spend and notes that labs are pivoting to capture enterprise value directly from heavy agent users rather than relying on middlemen.

Simon Willison — Week of 2026-05-29 to 2026-06-05#

Highlight of the Week#

The single most impactful update this week is the release of Datasette 1.0a31, which marks a massive paradigm shift by introducing UI support for executing write queries directly against the database. By allowing developers with the right permissions to set up templated insert, update, and delete operations as “stored queries,” Simon is aggressively evolving Datasette from a purely read-only tool into one that embraces secure data mutation.

Simon Willison — 2026-04-11#

Highlight#

The standout update today centers on the release of SQLite 3.53.0, where Simon highlights highly anticipated native ALTER TABLE constraint improvements and showcases his classic rapid-prototyping workflow by using Claude Code on his phone to build a WebAssembly-powered playground for the database’s new Query Result Formatter.

Posts#

SQLite 3.53.0 · Source This is a substantial release following the withdrawal of SQLite 3.52.0, packed with accumulated user-facing and internal improvements. Simon specifically highlights that ALTER TABLE can now directly add and remove NOT NULL and CHECK constraints, a workflow he previously had to manage using his own sqlite-utils transform() method. The update also introduces json_array_insert() (alongside its jsonb equivalent) and brings significant upgrades to the CLI mode’s result formatting via a new Query Results Formatter library. True to form, Simon leveraged AI assistance—specifically Claude Code on his phone—to compile this new C library into WebAssembly to build a custom playground interface.

Simon Willison — 2026-05-29#

Highlight#

Today’s most significant update is the release of Datasette 1.0a31, a massive paradigm shift for the project that introduces UI support for executing write queries directly against the database.

Posts#

datasette 1.0a31 Simon has released a major alpha for Datasette, bringing a highly-requested evolution: users with the right permissions can now execute write queries and save “stored queries” (formerly “canned queries”) directly in the UI. This allows developers to set up templated insert, update, and delete operations against their databases. This release also marks the third post on the recently launched Datasette blog, highlighting his ongoing push for better project documentation.