[UPHPU] Table Relationships

[Scott Hill]

On 4/6/07, Daniel C. <dcrookston at gmail.com> wrote:
>
> Isn't InnoDB in MySQL a database that allows it?  In what
> circumstances would it be the wrong thing to do?


Of course.  But InnoDB sucks and (IMHO) I thought it was a mistake to add it
to MySQL.  If you must, just use postgres or something more expensive.
Also, I wouln't say "wrong" but instead maybe "just not necessary".  For
simple projects MySQL has always sufficed. And I've never had any "cracks"
to deal with in any database project I've worked on.  Also, I have seen
large Oracle and Sybase implementations where, because of business rule
constraints, referential integrity was not enforced in some groups of
related tables.  Now, before I get flamed out of existence, I would just
like to say that I love referential integrity and use it (almost) all the
time.  Just not with MySQL.

-- 
Scott Hill

"May you solve interesting problems" - Author Unknown
"A fanatic is one who can't change his mind and won't change the subject." -
Sir Winston Churchill