Foreign keys
AssessTechniques
A database integrity mechanism that enforces relationships between tables.
Why it's here
Placed in Assess: 2 article(s) of evidence from 2 source(s), led by framework updates, with 1 in the last 30 days. Confidence 43%.
Evidence (2)
- 6InfoQ·9/28/2026product_launchAWS Adds Foreign Key Constraints to Aurora DSQL
AWS has announced support for foreign key constraints in Aurora DSQL, enabling applications to enforce referential integrity directly in the database. The update also includes referential actions such as CASCADE and SET NULL, closing a gap that users had identified as a blocker to adoption.
- 4Simon Willison·7/12/2026framework_updatesqlite-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.