note 54775 deleted from ref.sqlite by cmb

From: Date: Fri, 02 Sep 2016 14:34:22 +0000
Subject: note 54775 deleted from ref.sqlite by cmb
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-206476@lists.php.net to get a copy of this message
Note Submitter: bens at effortlessis dot com ---- Sqlite by default allows for foreign keys, but doesn't enforce them. I found a nice article on how to enforce foreign keys at http://www.justatheory.com/computers/databases/sqlite/ It would be nice if this could be handled with a wrapper class, so that adding foreign keys is done thru a wrapper API to automate the generation of the necessary enforcement triggers. If nobody's done this by the time I start coding against SqlLite/PHP5 in 6-12 months, I'll write one myself, possibly by modifying "jon at jenseng dot com"s alter table wrapper Anyway, it's not PHP specific, but anybody using Sqlite really should know this!

« previous php.notes (#206476) next »