News for hackers. Stuff that matters.
Re:SQL Keys in Depth by wvenable on Tuesday January 02, 2018 @03:59PM (#16055565)
I feel like an ISO country code is more of a surrogate key anyway; it's a mnemonic made-up value specifically designed to be used as key.
Re:SQL Keys in Depth by dragonwriter on Tuesday January 02, 2018 @04:07PM (#16055638)
An ISO country code isn't a surrogate key; it's not db-specific, and it has domain meaning (assuming you are using it for it's intended purpose). It's ususlly, when used, a representation chosen for natural domain information, so if it's a key, it's a natural key.
Re:SQL Keys in Depth by brlewis on Wednesday January 03, 2018 @10:18AM (#16061630)
From the article:

The naturalness or artificiality of unique properties in a database is relative to the outside world. A key which was artificial at birth in some standards body or government agency becomes natural to us because it’s generally agreed upon in the world at large, and/or imprinted on objects.