sqlite-utils 4.2 Makes table.transform() Preserve Check and Unique Constraints — and 4.2.1 Ships Hours Later for a Missing Dependency

Simon Willison·low signalXBlueskyLinkedInCopy link

Simon Willison released sqlite-utils 4.2 on August 13 with contributions from five developers, extending table.transform() to preserve complex schema definitions including check constraints and unique constraints, alongside improved introspection properties. A crashing bug from a missing typing-extensions dependency forced 4.2.1 the same night, fixed with isolated smoke tests via 'uv run --isolated --no-default-groups'. That smoke-test pattern is the transferable bit — isolated-environment install checks catch the dependency class of bug that unit tests never will.