Simon Willison released sqlite-utils 4.0rc3, introducing support for introspecting and creating compound foreign keys, which necessitates a subtle breaking change to the table.foreign_keys API. The update also aligns with SQLite's convention for case-insensitive column names, expanding the scope of changes beyond the initial release candidate.
Background
sqlite-utils is a popular Python CLI utility and library designed to simplify the manipulation of SQLite databases. Version 4.0 represents a significant update to the tool's capabilities regarding database schema management.
- Source
- Simon Willison
- Published
- Jul 6, 2026 at 01:40 PM
- Score
- 6.0 / 10