Simon Willison
sqlite-utils 4.1
What happened
Simon Willison released sqlite-utils 4.1, introducing several quality-of-life updates. Key features include a new `--code` option for `insert` and `upsert` commands allowing inline Python code to generate rows, a `--type` override for column creation (useful for preserving leading zeros in ZIP codes), and the ability to pipe SQL queries from stdin. Notably, Willison used Codex to review open issues and identify easy-to-implement features.
Why it matters
Streamlines local data engineering and SQLite manipulation, which are common tasks when preparing datasets or local vector stores for LLM applications.
The take
This is a solid utility update for developers managing local SQLite databases, which are increasingly common in local RAG setups, LLM caching, and small-scale agent memory systems. The inline Python execution (`--code`) is particularly handy for quick data transformation pipelines. Additionally, the author's note about using Codex to triage his backlog is a great meta-example of LLMs improving developer velocity on open-source maintenance.
Do this
Upgrade to `sqlite-utils` 4.1 if you rely on SQLite for local LLM data caching, prototyping, or RAG data preparation.
Don't read this site daily. Get it in your inbox.
The daily brief and Sunday deep dive — distilled, scored, and opinionated. For builders only.