Simon Willison • 7/12/2026

sqlite-utils 4.1.1

This article announces the release of sqlite-utils version 4.1.1, a Python command-line utility and library for manipulating SQLite databases. The main fix addresses an edge case where table.transform() now raises a TransactionError if called during an open transaction with PRAGMA foreign_keys enabled and the table is referenced by foreign keys with destructive ON DELETE actions (CASCADE, SET NULL, SET DEFAULT). Previously, dropping the old table could silently delete or modify referencing rows. The update also improves documentation by adding cross-references between CLI and Python API sections.

0 comments

#Python #cli #sqlite