Article · 2026-08-13 · 4 moments

sqlite-utils 4.2

Release: sqlite-utils 4.2 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, a ✦ AI generated

Read original ↗

HOST Simon Willison

Mechanism◆

In sqlite-utils 4.2, transform() preserves a much larger array of edge-case schema definitions, including check constraints, unique constraints, and even comments describing the columns.

A key improvement: transform() now preserves more schema edge cases — check constraints, unique constraints, and column comments — when rewriting a table.

transcript

Simon Willison: transform() now preserves a much larger array of edge-case schema definitions, including check constraints, unique constraints and even comments describing the columns.

extends · 1

Fact

It later turned out that sqlite-utils 4.2 had a crashing bug, which was fixed in 4.2.1.

A follow-up note: 4.2 turned out to contain a crashing bug, since fixed in the 4.2.1 patch release.

transcript

Simon Willison: (It later turned out 4.2 had a crashing bug, fixed in 4.2.1.)

explains mechanism · 1

Context

sqlite-utils 4.2 adds lots of improvements to the table.transform() feature, which supports complex alter table operations by creating a fresh table, copying across the data, and then dropping and replacing the old one.

The release announcement highlights table.transform() as the main focus: it now supports complex ALTER TABLE operations by rebuilding a fresh table, copying data, then dropping and replacing the old one.

transcript

Simon Willison: 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.

explains mechanism · 1

Fact

sqlite-utils 4.2 adds new introspection properties for check constraints, along with a whole lot of other smaller changes.

Beyond transform(), the release adds new introspection properties for check constraints and a number of other smaller changes.

transcript

Simon Willison: There are also new introspection properties for check constraints, and a whole lot of other smaller changes.

Highlight slides

transform() now preserves more schema edge cases✦ from: In sqlite-utils 4.2, transform() preserves a much larger array of edge-case schema definitions, including check constraints, unique constraints, and even comments describing the columns.

Related episodes

Video · Machine Learning Street Talk

In sqlite-utils 4.2, transform() preserves a much larger array of edge-case schema definitions, including check constraints, unique constraints, and even comments describing the columns.

It later turned out that sqlite-utils 4.2 had a crashing bug, which was fixed in 4.2.1.

sqlite-utils 4.2 adds lots of improvements to the table.transform() feature, which supports complex alter table operations by creating a fresh table, copying across the data, and then dropping and replacing the old one.

sqlite-utils 4.2 adds new introspection properties for check constraints, along with a whole lot of other smaller changes.

Why Deep Networks Don’t Need to Memorize Everything — Matthieu Wyart

sqlite-utils 4.1

sqlite-utils 4.0rc2, mostly written by Claude Fable (for about $149.25)