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) 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) 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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Dan Kubb (dkubb)
Piotr Solnica (solnic)