note 54775 deleted from ref.sqlite by cmb
| From: | cmb@php.net | 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!