News for hackers. Stuff that matters.

A comment on Be Careful with UUID or GUID as Primary Keys. Parent comment

Re:Be Careful with UUID or GUID as Primary Keys by TeMPOraL on Friday June 09, 2017 @07:12PM (#14525272)
It works until it doesn't :). A lot depends on how well they're enforced. SSNs are a go-to example, but in other countries which have actual ID numbers for citizens[0], duplicates do happen every now and then because of e.g. clerical errors. Real world is messy, and something can be trivially fucked up, it will be.

--

[0] - as opposed to the way US handles the SSN, where the number was explicitly forbidden from being used for identification, but people use it for it anyway.

[ Parent | on HN ]
Re:Be Careful with UUID or GUID as Primary Keys by codedokode on Saturday June 10, 2017 @07:02AM (#14526922)
There are not only duplicates, but sometimes the documents can be reissued with another number or ID, sometimes there are people without the document that your system expects everybody to have.
[ Parent | on HN ]