Simon Willison·1 min·2d agoFREE

sqlite-utils 4.0rc1 has been released, introducing database migrations and nested transaction support. The migrations feature is a modified port of the sqlite-migrate package, enabling schema changes like table creation and column additions. The new db.atomic() API provides an abstraction for SQLite's savepoint-based nested transactions. This release candidate also includes several minor backwards incompatible changes, such as updated upsert behavior and a change in the default floating point column type.

Developers using sqlite-utils gain new capabilities for managing database schema changes and handling complex transaction logic.