sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)
Summary
sqlite-utils 4.0rc2 was developed with help from Claude Fable (an AI coding agent) to fix critical bugs found in the previous release candidate, particularly a severe data loss issue in the delete_where() function that failed to commit transactions properly. The release introduces a new transaction model where every database write operation automatically commits before returning, eliminating the need for manual commit() calls in most cases.
Solution / Mitigation
The delete_where() bug was fixed by wrapping the DELETE operation with an atomic() wrapper, matching the correct implementation used in the delete() function. The broader solution involved comprehensive redesign of transaction handling across 30 files, documented in the PR and shared transcript referenced in the source text.
Classification
Original source: https://simonwillison.net/2026/Jul/5/sqlite-utils-fable/#atom-everything
First tracked: July 5, 2026 at 02:01 AM
Classified by LLM (prompt v3) · confidence: 95%