#database-triggers
- Enforce Foreign Key Integrity in SQLite with Triggers
https://justatheory.com/2004/11/sqlite-foreign-key-triggers/
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.
Follow #database-triggers
on RSS or use the
JSON API
curl -X GET \
-H "Content-type: application/json" \
-H "Accept: application/json" \
"https://octothorp.es/~/database-triggers"