Simon Willison has released sqlite-utils 4.0, introducing native database schema migrations, nested transactions via db.atomic(), and compound foreign key support. The migration feature leverages a powerful table.transform() method to handle complex schema changes that SQLite's native ALTER TABLE does not support.
Background
sqlite-utils is a popular Python library designed to simplify working with SQLite databases, often used in conjunction with Datasette. This update marks the first major version bump since 2020, addressing long-standing limitations in schema management.
- Source
- Simon Willison
- Published
- Jul 8, 2026 at 03:32 AM
- Score
- 7.0 / 10