But what's the point? You're complicating the data for no apparent gain. Only te... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

bjourne 5 months ago | parent | context | favorite | on: You'll regret using natural keys

But what's the point? You're complicating the data for no apparent gain. Only terrible RDBMSes which don't support multi-column keys require surrogate keys.

konschubert 5 months ago [–]

Because you can remove or change the uniqueness constraint without having to worry about foreign key relationships.

bjourne 5 months ago | [–]

Eh, that's a feature of natural keys. If you try to fuck up your model your RDBMS will complain.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact