#1053 suggestion
Simon Harris

SQLite3 constraints

Reported by Simon Harris | September 21st, 2009 @ 09:02 AM

Would anyone be interested in SQLite3 support for constraints? I have some code written using triggers which I could clean up and submit if there was sufficient interest.

Comments and changes to this ticket

  • Dan Kubb (dkubb)

    Dan Kubb (dkubb) September 22nd, 2009 @ 01:46 AM

    • State changed from “new” to “suggestion”

    Yes, I would really like to see something like that. Ideally I'd like to see it if it didn't result in any failing specs.

    The current idea with dm-constraints is we set up software level constraints, that if working perfectly should catch all attempts to destroy a resource when it has dependents. The DB level constraints are more of a safety net, as well as communicating intent, and also providing a backup for if (when) the DB becomes an integration point.

  • Dan Kubb (dkubb)

    Dan Kubb (dkubb) May 26th, 2010 @ 02:33 AM

    I'd just like to say that I would love to see this functionality merged into dm-constraints. I believe newer versions of SQLite 3 even support FK constraints too.

    If some of this functionality included CHECK constraints I would be doubly excited to see it merged in :)

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »