# Simon Willison — sqlite-utils 4.0rc2, mostly written by Claude Fable

> 37 prompts, 34 commits, one data-loss bug caught — Simon Willison's field report on shipping a real library with Claude Fable.

- Org: Simon Willison
- Date: 2026-07-05
- Category: article
- Source: https://simonwillison.net/2026/Jul/5/sqlite-utils-fable/
- Canonical page: https://ai-tldr.dev/releases/simonw-sqlite-utils-4-0-rc2-jul5/

## In short

Simon Willison shipped sqlite-utils 4.0rc2 with Claude Fable doing most of the work — 37 prompts, 34 commits, 30 files, $149.25 at unsubsidized API rates — and caught a data-loss bug in delete_where() during pre-release review.

## What it is

sqlite-utils 4.0rc2 is the release candidate for the next major version of Simon Willison's widely-used Python library for building and querying SQLite databases. In this post he documents how much of the pre-release work — code review, refactors, docs, and the release notes themselves — was done by Claude Fable rather than by hand.

## How it works

Across 37 conversation turns, Claude Fable ran the full test suite, hunted for missing transaction guards, and landed 34 commits across 30 files. One of those commits fixed a bug in delete_where() where a failed batch could silently drop rows outside its own transaction — a data-loss issue Simon Willison had not spotted in his own review.

## Why it matters

$149.25 at unsubsidized Anthropic API rates is a concrete price tag on 'have an agent review your library before you cut a release'. For maintainers deciding whether to spend a weekend on the same work themselves, this post is a rare public data point — with the prompts, the diffs, and the resulting cost all shown.

## Who it's for

Open-source maintainers, Python developers, teams evaluating coding-agent spend

## Try it

pip install sqlite-utils==4.0rc2

## Links

- [Simon's post](https://simonwillison.net/2026/Jul/5/sqlite-utils-fable/)
- [sqlite-utils on PyPI](https://pypi.org/project/sqlite-utils/)
- [sqlite-utils repo](https://github.com/simonw/sqlite-utils)
