openstack team mailing list archive

[Clay Gerrard <clay.gerrard@xxxxxxxxx>]

On Thu, Apr 12, 2012 at 7:35 AM, J. Daniel Schmidt <jdsn@xxxxxxx> 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