{"uri":"https://octothorp.es/","term":"database-triggers","thorpes":[{"uri":"https://justatheory.com/2004/11/sqlite-foreign-key-triggers/","title":"Enforce Foreign Key Integrity in SQLite with Triggers","description":"After some some Googling and experimentation, I’ve figured out how to enforce foreign key constraints in SQLite. I got most of the code from Cody Pisto’s sqlite_fk utility. I couldn’t get it to work, but the essential code for the triggers was in its fk.c file, so I just borrowed from that (public domain) code to figure it out."}],"bookmarks":[]}