Issue 407: Create referal integrity constraints in db
Status:  WontFix
Owner: ----
Closed:  Jan 2010
Reported by Litvinov...@gmail.com, Jan 20, 2010
We are using gerrit with postgresql database backend. I have found that all
tables missing reference integrity constraints. This allows bugs to create
inconsistent data stored in database.

It would be nice to have such constraints.
Jan 21, 2010
#1 sop@google.com
I really just don't want to do this.

Our long term plan is to move off a SQL database onto a distributed Git
based database.  A medium term plan is to start supporting a clustered
database like Apache Cassandra, in addition to our SQL support.

Neither Cassandra nor Git can easily support referential integrity, and
besides, our schema isn't that complex.

In prior projects I have used integrity constraints, and they work great,
especially when there are lots of applications writing into the database.
But I just don't see enough value here to make it worth it.  We have at
least another 100 other open issues that are much more important.
Jan 21, 2010
#2 Litvinov...@gmail.com
Ok, I would agree with you: where are so much things to fix/improve with higher priority.
Jan 22, 2010
#3 sop@google.com
(No comment was entered for this change.)
Status: WontFix