Release: sqlite-utils 4.2
Simon Willison’s Weblog
Subscribe
13th August 2026
Release
sqlite-utils 4.2 — Python CLI utility and library for manipulating SQLite databases
Lots of improvements in this one relating to the table.transform() feature, which adds support for complex alter table operations by creating a fresh table, copying across the data and then dropping and replacing the old one.
transform() now preserves a much larger array of edge-case schema definitions, including check constraints, unique constraints and even comments describing the columns.
There are also new introspection properties for check constraints, and a whole lot of other smaller changes.
Includes contributions from Bunlong Heng, ethanhawkes-gif, Rami Abdelrazzaq, nyxst4ck, and ikatyal2110.
(It later turned out 4.2 had a crashing bug, fixed in 4.2.1.)
Recent articles
Now we have a timeline of the OpenAI accidental attack against Hugging Face - 7th August 2026
One-shotting a Raccoon Heist game using Claude Fable 5 - 5th August 2026
New release of LLM adds support for reasoning traces, OpenAI Responses, server-side tools, and smarter logging - 4th August 2026
This is a beat by Simon Willison, posted on 13th August 2026.
releases 30
sqlite 484
sqlite-utils 237
Monthly briefing
Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.
Pay me to send you less!
Sponsor & subscribe
Disclosures
Colophon
©
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026