Simon Willison 7/12/2026

sqlite-utils 4.1

Read Original

This article announces the release of sqlite-utils 4.1, a Python CLI utility and library for manipulating SQLite databases. Key new features include: --code option for sqlite-utils insert and upsert to define rows via Python code blocks; --type option to override column types (e.g., ZIP codes as TEXT); new table.drop_index() method and sqlite-utils drop-index command; ability to read SQL queries from stdin; upsert now infers primary key from existing tables; transform commands now support strict=True/False to change strict mode. The release also includes minor bug fixes and improvements inspired by community feedback and Codex suggestions.

sqlite-utils 4.1

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

No top articles yet