SQLite default foreign key enforcement OFF: risk of silent referential integrity loss
SQLite keeps foreign key enforcement disabled by default, a setting introduced in version 3.6.19 to preserve backward compatibility with older databases that may contain inconsistent data. When foreign_keys pragma is OFF, INSERT, UPDATE, or DELETE statements that violate referential integrity succeed without error. This silent behavior can lead to undetected