Summary & Key Takeaways ​

• sqlite-utils 4.0 has been released, a major version update.
• The key new feature is robust database schema migrations.
• It also introduces support for nested transactions.
• Compound foreign keys are now supported.
• The table.transform() method enables advanced schema changes.
• Migrations are defined in Python files.
• This release significantly enhances SQLite database management.
• It's the first major version bump since 2020.

Our Commentary ​

Simon Willison just keeps delivering essential tools. sqlite-utils getting schema migrations in 4.0 is a huge deal for anyone working with SQLite. We've all wrestled with schema changes, and having a solid, Python-based solution built into such a reliable tool is fantastic. This is a significant DX improvement, making SQLite even more powerful for complex projects. I'm genuinely excited about this.