sqlite-utils 4.0, now with database schema migrations

·Simon Willison··

This morning I released sqlite-utils 4.0, the 124th release of that project and the first major version bump since 3.0 in November 2020. In addition to some small but significant breaking changes (described in this upgrade guide), this version introduces three major features: database migrations, nested transactions (via a new db.atomic() method), and support for compound foreign keys. Database schema migrations using sqlite-utils Schema migrations define a sequence of changes to be made to a SQ...

Read full article →

Related Articles

PostgreSQL Benchmark: AWS RDS vs. Self-Hosted on Hetzner (2026)
pv1337 · Hacker News · 11h ago
Should I run plain Docker Compose in production in 2026?
pmig · Hacker News · 2mo ago
Computer Use is 45x more expensive than structured APIs
palashawas · Hacker News · 2mo ago
Bun is being ported from Zig to Rust
SergeAx · Hacker News · 2mo ago
Show HN: Tilde.run – Agent sandbox with a transactional, versioned filesystem
ozkatz · Hacker News · 2mo ago