sqlite-utils 4.0, now with database schema migrations

According to Simon Willison's Weblog, sqlite-utils has released version four point zero, the first major version bump in nearly six years for this popular Python library. The release introduces database schema migrations—letting developers track and apply database changes in sequence—nested transactions through a new atomic method, and support for compound foreign keys. The migrations feature addresses a long-standing gap in SQLite's native tooling, letting developers define changes in Python and automatically track what's been applied. This pattern, popularized by Django years ago, now brings that maturity to SQLite projects of any size.

Listen to this story

Hear this and more stories in a personalized audio briefing.

Open The Chonkerton