[UPHPU] Table Relationships

[Scott Hill]

On 4/5/07, Daniel C. <dcrookston at gmail.com> wrote:
>
> Are you a masochist?  Why, why, WHY?  You could also just write your
> own RDBMS in PHP...


Isn't it obvious why?  When I first started using MySQL, there was no way to
enforce referential integrity.  When InnoDB came along, I felt it had
performance issues.  I also believe masochism is not an issue here.  It is
quite painless to keep track of referential links in tables yourself.  I do
use and love enforced referential integrity in other databases.  Especially
the cascading affect that can be used when updating and deleting.  If I am
using a database that allows it and the circimstances are right, it's
definitely the right thing to do.

-- 
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