#Python

sqlite-utils 4.0, released on July 7, 2026, introduces three major features: database schema migrations, nested transactions via a new db.atomic() method, and support for compound foreign keys. This release significantly enhances sqlite-utils as a tool for managing SQLite databases, addressing common needs for schema versioning and transactional safety. Developers using Python for data management will benefit from easier migration workflows and more robust transaction handling. Migrations are defined in Python files using the Migrations class and the table.transform() method, which implements SQLite's recommended pattern of creating a temporary table. Nested transactions use SQLite savepoints under the hood, and compound foreign keys allow referencing multiple columns.

sqlite-utils 4.0rc2, a release candidate for the popular SQLite database utility, has been released. The majority of the code changes in this release were written by Anthropic's Claude Fable AI model, costing approximately $149.25. This release demonstrates the growing capability of AI-assisted software development, as Claude Fable identified and fixed critical bugs like a data loss bug in deletewhere() that would have otherwise shipped. It shows that AI can not only write code but also perform code review that catches subtle, high-impact issues. The AI assistant conducted a review of the 4.0rc1 release and identified 5 release-blocking issues, including a severe data loss bug. Over 37 prompts, 34 commits, and +1321/-190 code changes across 30 files, the team worked through all feedback, with the AI generating most of the code and fixes.