Foreign key constraints in SQLite

(not sure what the right category is… maybe this is a documentation issue? ) For backwards compatibility, foreign keys are disabled in SQLite by default (SQLite Foreign Key Support), and you need to enable them explicitly: Foreign key constraints are disabled by default (for backwards compatibility), so must be enabled separately for each database connection. (Note, however, that future releases of SQLite might change so that foreign key constraints enabled by default. Careful developers will...