ATRIUM search → argument graph

FactArticle

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. ✦ AI generated

Simon Willison · Simon Willison's Weblog · 2026-08-13 · original ↗

Share card ↓Export .md Export .txt

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

Read full article ↗excerpt · fair-use quotation

✳ sqlite-utils

Related moments

Mechanism◆Video · 53:22 · 6m

Algorithms that predict in abstract latent space rather than raw token space are significantly more sample-efficient because they build abstractions from stronger, less noisy signals.

Matthieu Wyart · Machine Learning Street Talk

Fact◆Article · 34 words

The biggest new feature in this release is support for introspecting and creating compound foreign keys, and because that involves a subtle breaking change to table.foreign_keys, it had to land before the 4.0 stable release.

Simon Willison · Simon Willison's Weblog

Mechanism◆Article · 40 words

Table.delete_where() never wraps its DELETE in a transaction, so it fails to commit and leaves the database connection permanently poisoned, causing silent data loss on subsequent operations.

Claude Fable · Simon Willison's Weblog