Mechanism◆Article
Table.delete_where() never wraps its DELETE in a transaction, so it fails to commit and leaves the database connection permanently poisoned, causing silent data loss on subsequent operations.
Claude Fable · Simon Willison's Weblog
AnecdoteArticle
As I worked through the backlog of issues and PRs with a combination of Claude Fable 5 and GPT-5.5, the changelog since rc2 kept getting bigger, so I couldn't release sqlite-utils 4.0 stable this weekend as hoped.
The author intended to ship sqlite-utils 4.0 stable this weekend, but working through the backlog with Claude Fable 5 and GPT-5.5 kept expanding the changelog, pushing the release back to rc3. ✦ AI generated
Simon Willison · Simon Willison's Weblog · 2026-07-06 · original ↗
I hoped to release sqlite-utils 4.0 stable this weekend, but as I worked through the backlog of issues and PRs with a combination of Claude Fable 5 and GPT-5.5 the changeling since rc2 kept getting bigger.
Read full article ↗excerpt · fair-use quotation
Related moments
Fact◆Article
The biggest new feature in this release is support for introspecting and creating compound foreign keys, and because that involves a subtle breaking change to table.foreign_keys, it had to land before the 4.0 stable release.
Simon Willison · Simon Willison's Weblog
Fact◆Article
sqlite-utils now follows SQLite's own convention for treating column names as case insensitive, a change that turned out to touch a bunch of different places in the codebase.
Simon Willison · Simon Willison's Weblog