The sqlite-utils 4.0rc2 release arrived after a painstaking review by Claude Fable, an Anthropic model. The author used the model to vet the code before shipping, aiming for a stable 4.0 with minimal breaking changes. The process involved 37 prompts and 34 commits across 30 files, tightening the tool’s API.

A critical bug surfaced in delete_where(): the method never commits, leaving the connection in a failed transaction and erasing subsequent inserts. The author reproduced the issue with a small database, showing that after a delete, new rows and even other tables vanished. Fixing this required redesigning the transaction wrapper for that method.

The review also highlighted transaction handling: each write now commits automatically, eliminating the need for explicit commit() calls. The author added documentation explaining the new per‑method transaction model and its limits with Python 3.12’s autocommit settings. A cost audit revealed the session spent **$