Engineering Reads — Week of 2026-06-24 to 2026-07-02#

Week in Review#

This week’s reading circles a central tension in modern engineering: managing the boundary between complex systems and the interfaces we build to tame them. Whether we are embedding local AI agents to maintain data sovereignty or structurally funding paradigm shifts through top-down mandates, the underlying debate is about where to place the friction. The consensus is clear: we must engineer systems that preserve flow and autonomy without obscuring the foundational reality of our tools and languages.

Simon Willison — Week of 2026-04-04 to 2026-04-10#

Highlight of the Week#

Anthropic’s decision to delay the general release of their highly capable Claude Mythos model under “Project Glasswing” marks a significant turning point in the AI industry. The move underscores a massive shift in frontier model capabilities, as models evolve from generating text to autonomously chaining multiple minor vulnerabilities into sophisticated exploits, requiring a new level of security safeguards before release.

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-04-18 to 2026-05-01#

Highlight of the Week#

The alpha release of llm 0.32a0 marks a foundational architectural pivot for Simon’s ecosystem of CLI tools. By moving away from a simple text-in/text-out abstraction to one that natively models complex message sequences and typed streams, the library is now future-proofed to handle the realities of modern frontier models. This opens the door for seamless integration of server-side tool calls, multi-modal inputs, and reasoning tokens.

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 — Week of 2026-06-06 to 2026-06-12#

Highlight of the Week#

The standout event this week was the release of Anthropic’s massive Claude Fable 5 model, which Simon immediately leveraged as a highly capable coding partner to essentially author complex new features across his open-source ecosystem. However, the most impactful takeaway was his deep dive into the model’s terrifyingly autonomous capabilities—such as independently writing CORS servers and injecting JavaScript just to debug a CSS glitch—which served as a stark reminder of why executing AI-generated code requires strict sandboxing.

Engineering Reads — Week of 2026-06-11 to 2026-06-18#

Week in Review#

The dominant theme across this week’s writing is the aggressive upward shift of the engineering abstraction layer. As AI drives the cost of syntax generation toward zero, the practitioner’s role is migrating heavily toward architecture, systems-level validation, and managing complex state—whether that state lives in a non-deterministic LLM agent, a brittle C++ compiler toolchain, or the developer’s own psychology.

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

Highlight of the Week#

The most impactful release this week is the launch of datasette-apps, a major new plugin that allows developers to run self-contained, sandboxed HTML and JavaScript applications directly against a persistent Datasette backend. It brilliantly merges Simon’s ongoing experiments with AI-generated “vibe-coded” single-file tools and robust security architectures, pushing Datasette from a read-only publishing platform into a comprehensive ecosystem for building interfaces over data.

Simon Willison — 2026-07-11#

Highlight#

The release of sqlite-utils 4.1 showcases how Simon is aggressively integrating AI into his open-source workflow, using GPT-5.6 Codex not just to write code, but to triage issues and manually exercise edge cases in the terminal. It also introduces a clever workaround to migrate existing databases to SQLite’s STRICT mode by utilizing the tool’s built-in table transformation mechanism.

Posts#

sqlite-utils 4.1 · Source Just days after shipping version 4.0, Simon released sqlite-utils 4.1 with a batch of minor but highly useful CLI features. Highlights include a --code option to generate rows for insertion directly via Python snippets, and a --type override to prevent CSV/TSV data like ZIP codes from being incorrectly parsed as integers. Inspired by an Evan Hahn post on Hacker News, the release adds strict=True/False toggles to the transform command, seamlessly migrating data to enforce SQLite’s strict table schemas. Interestingly, Simon relied heavily on AI-assisted programming for this release: he had Codex scan his repository to find the easiest open issues, and used an advanced prompt instructing the model to use uv run python -c to manually test its own work and uncover edge cases.

Simon Willison — 2026-04-09#

Highlight#

Today’s most substantive update is the release of asgi-gzip 0.3, which serves as a great practical reminder of the hidden risks in automated maintenance workflows. A silently failing GitHub Action caused his library to miss a crucial upstream Starlette fix for Server-Sent Events (SSE) compression, which ended up breaking a new Datasette feature in production.

Posts#

[asgi-gzip 0.3] · Source Simon released an update to asgi-gzip after a production deployment of a new Server-Sent Events (SSE) feature for Datasette ran into trouble. The root cause was datasette-gzip incorrectly compressing event/text-stream responses. The library relies on a scheduled GitHub Actions workflow to port updates from Starlette, but the action had stopped running and missed Starlette’s upstream fix for this exact issue. By running the workflow and integrating the fix, both datasette-gzip and asgi-gzip now handle SSE responses correctly.