News for hackers. Stuff that matters.
Re:SQL is 43 years old – Here’s why we still use it today by cheez on Tuesday May 02, 2017 @01:15PM (#14248320)
Natural keys can be composite which makes it a pain to manage cross-table relationships. I typically have a unique constraint on the actual composite key and a auto inc id.
Re:SQL is 43 years old – Here’s why we still use it today by gnaritas on Tuesday May 02, 2017 @05:58PM (#14251009)
That is the correct solution, a surrogate key.
Re:SQL is 43 years old – Here’s why we still use it today by cheez on Tuesday May 02, 2017 @07:45PM (#14251781)
Good to know, thanks!