sqlite-utils 4.0rc3

Simon Willison's Blog Tools
sqlite-utils release-candidate open-source database-tools python compound-foreign-keys sqlite

Summary

sqlite-utils 4.0rc3 is a release candidate with new features including compound foreign key introspection and case-insensitive column matching.

No content available
Original Article
View Cached Full Text

Cached at: 07/06/26, 06:33 AM

# Release: sqlite-utils 4.0rc3 Source: [https://simonwillison.net/2026/Jul/6/sqlite-utils/](https://simonwillison.net/2026/Jul/6/sqlite-utils/) I hoped to release`sqlite\-utils 4\.0`stable this weekend, but as I worked through the backlog of issues and PRs with a combination of Claude Fable 5 and GPT\-5\.5 the changeling since rc2[kept getting bigger](https://sqlite-utils.datasette.io/en/latest/changelog.html#rc3-2026-07-05)\. The biggest new feature is support for introspecting and creating compound foreign keys \- a feature that involves a subtle breaking change to[table\.foreign\_keys](https://sqlite-utils.datasette.io/en/latest/python-api.html#foreign-keys)and hence needed to land for the 4\.0 stable release\. `sqlite\-utils`also now follows SQLite's convention for case insensitive column names, which turned out to touch[a bunch of different places at once](https://sqlite-utils.datasette.io/en/latest/changelog.html#case-insensitive-column-matching)\.

Similar Articles

sqlite-utils 4.0rc1

Simon Willison's Blog

sqlite-utils 4.0rc1 is a release candidate for the Python CLI tool that simplifies SQLite database manipulation.

sqlite-utils 4.2

Simon Willison's Blog

sqlite-utils 4.2 improves the transform() feature with support for complex schema definitions, new introspection properties, and other smaller changes, with contributions from multiple developers.