News for hackers. Stuff that matters.
Re:Things I wished more developers knew about databases by brantam on Thursday April 23, 2020 @08:49AM (#22955347)
The article mentions auto-incrementing keys, not surrogates. Not the same thing at all. Not all incrementing keys are surrogates and not all surrogates are incrementing keys.

Also, your problem number 1 is a problem whether the natural key in question is the "primary" one or not. Certainly if you choose the wrong natural key then you'll have to fix that - that's why you should take care to make a wise choice of natural key regardless of whether you are also using a surrogate.

There are no comments on this comment yet.