Simon Willison • 7/12/2026

sqlite-utils 4.1

This article announces the release of sqlite-utils 4.1, a Python CLI utility and library for manipulating SQLite databases. New features include a --code option for inserting rows via Python code blocks, --type for overriding column types (e.g., ZIP codes as TEXT), a table.drop_index() method and drop-index command, reading SQL queries from stdin, inferring primary keys for upsert, and support for strict table mode via transform. These enhancements improve flexibility and usability for developers working with SQLite databases.

0 comments

#Python #cli #sqlite