Simon Willison • 7/6/2026

sqlite-utils 4.0rc3

This article announces the release of sqlite-utils 4.0rc3, a Python CLI utility and library for manipulating SQLite databases. The release introduces support for introspecting and creating compound foreign keys, a subtle breaking change to table.foreign_keys. It also adopts SQLite's convention for case-insensitive column names, affecting multiple areas. The author used AI tools like Claude Fable 5 and GPT-5.5 to work through issues and PRs, aiming for a stable 4.0 release soon.

0 comments

#Python #cli #sqlite