[Openstack] Using Foreign Keys
Clay Gerrard
clay.gerrard at gmail.com
Thu Apr 12 15:12:57 UTC 2012
On Thu, Apr 12, 2012 at 7:35 AM, J. Daniel Schmidt <jdsn at suse.de> wrote:
> In our point of view foreign keys should be used in all possible places. This
> would not harm any database that does not support them but helps all of us to
> find data inconsistencies and related bugs, which leads to faster development
> with fewer bugs.
>
FWIW, I recently learned that you can enforce foreign keys in sqlite >
3.6.19 with a pragma by setting up and event/listener on session
create.
http://www.sqlite.org/foreignkeys.html
We've had some good success with it.
-clayg
More information about the Openstack
mailing list