sqlite-utils 4.0, now with database schema migrations

222 · · July 7, 2026, 7:36 p.m.
Summary
This blog post announces the release of sqlite-utils 4.0, detailing new major features including database schema migrations, nested transactions, and compound foreign keys. It highlights how migrations are implemented through Python files and provides examples of migration usage. The author shares insights on the library's development, past experiences with similar migrations in Django, and the role of AI tools in enhancing the quality of this release.