Simon Willison: sqlite-utils 4.0 Released — Claude Fable 5 Found 4 Critical Blockers and Shaped the API Design

Main idea

Simon Willison documents that Claude Fable 5 during sqlite-utils 4.0 development didn't just assist with coding—it actively shaped the final API design and identified critical bugs Willison himself had missed. This is a qualitative shift from "AI writes code to spec" to "AI proposes better design."

Context

This post concludes the AI-assisted development series for sqlite-utils (after rc2 for $149 and rc3 with compound foreign keys, both in the existing dedup list). Stable 4.0 is the first major version bump since November 2020, introducing database migrations, nested transactions (db.atomic()), and compound foreign keys.

Why it matters

sqlite-utils 4.0 is one of the best-documented case studies of AI-assisted open-source development in 2026. Willison demonstrates concrete cases where an AI model didn't implement the spec but changed the spec—a valuable perspective for any developer considering AI collaboration in their workflow.

Details / arguments

• Claude Fable 5 wrote 12 testing and utility scripts
• Model identified 4 critical blockers and 10 additional issues through systematic testing
• Fable was "relentlessly proactive" in proposing API design changes that shaped the final implementation
• Stable release includes: migrations (_sqlite_migrations table), db.atomic() for nested transactions, enhanced compound foreign keys
• Total of 16 bugs identified and resolved via AI code review