[UPHPU] Table Relationships

[Brandon Stout]

John David Anderson wrote:

> I agree with Mac. If you have to make those checks and fixes at the 
> application level anyway, what's the point of having the DB do it? I'd 
> like to hear why if anyone sees the need: to me though referential 
> integrity restraints at the DB level are as necessary as JS 
> validation. It needs to happen at the application level anyway.
>
> -- John 

I agree one should error check on the client/application level, but I 
also do whatever I can on the db level.  It's easier to write code that 
returns an error straight from the database than to write your own 
sufficiently descriptive error messages.  Even when the returned 
database error makes no sense, the documentation usually clears things up.

Brandon Stout
http://mscis.org