Foreign keys

Assess

Techniques

A database integrity mechanism that enforces relationships between tables.

Why it's here

Placed in Assess: 1 article(s) of evidence from 1 source(s), led by framework updates, with 0 in the last 30 days. Confidence 24%. Low accumulated evidence, so it defaults conservatively pending more signal.

Evidence (1)

4Simon Willison·7/12/2026framework_update
sqlite-utils 4.1.1 adds safer table transforms
sqlite-utils 4.1.1 changes table.transform() to raise a TransactionError when it is used inside an open transaction with foreign key enforcement enabled and destructive ON DELETE actions could be triggered. This prevents silent row deletions or modifications during table replacement, and the release also improves cross-linking between the CLI and Python API documentation.