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, and follows SQLite's convention for case-insensitive column names. The author intended to release 4.0 stable but continued working through issues and PRs using AI tools like Claude Fable 5 and GPT-5.5. This is a technical update for developers using SQLite and Python.

0 comments

#Python #cli #sqlite