sqlite-utils 4.0rc3
Mirrored from Simon Willison for archival readability. Support the source by reading on the original site.
6th July 2026
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 changelog since rc2 kept getting bigger.
The biggest new feature is support for introspecting and creating compound foreign keys - a feature that involves a subtle breaking change to table.foreign_keys and hence needed to land for the 4.0 stable release.
sqlite-utils also now follows SQLite's convention for case insensitive column names, which turned out to touch a bunch of different places at once.
Recent articles
This is a beat by Simon Willison, posted on 6th July 2026.
projects 544 sqlite 475 sqlite-utils 227 annotated-release-notes 58 gpt 127 claude-mythos-fable 23Monthly briefing
Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.
Pay me to send you less!
Discussion (0)
Sign in to join the discussion. Free account, 30 seconds — email code or GitHub.
Sign in →No comments yet. Sign in and be the first to say something.