sqlite-utils 4.0rc1: Migration & Nested Transactions
Decision Brief
What changedsqlite-utils 4.0rc1 adds database migration support via sqlite-migrate and nested transaction mechanism with db.atomic().
Why it mattersAs a Python library and CLI for SQLite, new features enhance automation and reliability in AI data management.
Who should careAI coding tool users
Affected stackNo specific stack identified
Builder actionMonitor
Source confidenceMedium · Reliable media or first-hand reporting
sqlite-utils 4.0rc1 introduces two major features: database migrations and nested transactions. Migrations, ported from sqlite-migrate package, are supported via Python or CLI but lack rollback. Nested transactions use db.atomic() to simplify savepoints. Breaking changes include upsert using INSERT...ON CONFLICT SET, dropped Python 3.8 support, default float type REAL, and enabled type detection for CSV/TSV import.
Summary basis: official / RSS sourceUnless it says 'full article read', this summary is based only on publicly available content — it never pretends to have read restricted originals.
Sources
- Simon Willison：Blog
Hands-on notes on LLM tools, local models, and practical AI engineering.
- Simon Willison：Blog