News for hackers. Stuff that matters.

A comment on Design better databases. Parent comment

Re:Design better databases by clavalle on Thursday April 07, 2016 @02:34PM (#11449480)
There is no way to enforce data integrity between related tables by virtue of the data model for one thing.
[ Parent | on HN ]
Re:Design better databases by gcr on Thursday April 07, 2016 @02:52PM (#11449619)
I don't get this argument. Foreign key constraints are part of the schema.

What should the primary key be if not a UUID?

[ Parent | on HN ]
Re:Design better databases by clavalle on Thursday April 07, 2016 @06:23PM (#11451172)
A natural key. It is not always possible, but when it is it should be used.
[ Parent | on HN ]
Re:Design better databases by cortesoft on Thursday April 07, 2016 @03:15PM (#11449815)
an integer id?
[ Parent | on HN ]
Re:Design better databases by billybugmaster on Thursday April 07, 2016 @02:51PM (#11449614)
isn't that what the fk are for? food_uuid for example. I concede I wouldn't call it uuid but I don't see a problem keeping the data straight.
[ Parent | on HN ]
Re:Design better databases by jtmarmon on Thursday April 07, 2016 @02:43PM (#11449548)
?? foreign keys?
[ Parent | on HN ]