sqlite-utils 4.2
Mirrored from Simon Willison for archival readability. Support the source by reading on the original site.
13th August 2026
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
This is a beat by Simon Willison, posted on 13th August 2026.
releases sqlite sqlite-utilsMonthly 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!
Discussion (0)
Sign in to join the discussion. Free account, 30 seconds — email code or GitHub.
Sign in →No comments yet. Sign in and be the first to say something.