Simon Willison (@simonwillison.net): I released sqlite-utils 4.0, the 124th release but the first major version bump since 3.0 back in 2020 I managed to keep things backwards-compatible all the way up to version 3.39 before the accumula
Essential update for developers building Python applications with SQLite who need more sophisticated schema management and migration capabilities.
AI Summary
Simon Willison released sqlite-utils 4.0, the first major version bump since 2020, introducing database schema migrations, nested transactions via a new db.atomic() method, and support for compound foreign keys. The library provides enhanced table transformation capabilities that go beyond SQLite's native ALTER TABLE support, implementing the pattern recommended by SQLite documentation for more complex schema changes.
Excerpt
I released sqlite-utils 4.0, the 124th release but the first major version bump since 3.0 back in 2020 I managed to keep things backwards-compatible all the way up to version 3.39 before the accumulated design mistakes forced me to bump that number! simonwillison.net/2026/Jul/7/s...
