Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Agreed. The simplest example is names. People don't have unique names so you combine it with some other stuff (birthdate, SSN) and call it a primary key. Then someone gets married and changes their name. To anyone doing this for a short amount of time this example is obvious. The point is that almost everything you might think of as a "natural key" is not good enough and you'll get burned when you find out what the reasons are.


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

Search: