php-general Digest 4 Jul 2013 10:42:45 -0000 Issue 8283
Topics (messages 321521 through 321521):
Web dev, DB and "proper db design".
321521 by: Richard Quadling
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
Hi.
I've just had a conversation regarding DB, foreign keys and their benefits.
I was told "I've never worked on a web application where foreign keys were
used in the database".
As someone who has spent 25 years working on accounting/epos systems on MS
SQL Server (yep, windows) and now in a web environment and hearing the
above, ... well, ... slightly concerned.
So, in the biggest broadest terms, what do you lot do?
DBs with no foreign keys (constrainted or not).
ORM builders with manual definition of relationships between the tables.
Inline SQL where you have to just remember all the relationships.
Views for simple lookups? How do you handle updatable views (does mysql
support them?)
etc.
Is there a difference in those in 'startups' and web only situations, or
those doing more traditional development (split that as you like - I'm just
trying to get an understanding and not go off on one!).
No definitive answers, and I hope I get some wide experiences here.
Thanks for looking.
Richard.
--- End Message ---
