News for hackers. Stuff that matters.

A comment on Auto increment is a terrible idea.

Re:Auto increment is a terrible idea by johnlbevan2 on Thursday November 30, 2017 @09:32AM (#15815925)
A UUID is not always non-predictable / entirely random. For example: `NEWSEQUENTIALID()` in MS SQL Server uses a randomly generated UUID, then auto-increments from there. More info on this function's usage here: https://www.codeproject.com/Tips/125526/Using-ROWGUIDCOL-in-...
[ Parent | on HN ]
Re:Auto increment is a terrible idea by pwinnski on Thursday November 30, 2017 @10:39AM (#15816528)
This is why the writer specifically called out UUIDv4, which is random by definition. That's what type 4 means.
[ Parent | on HN ]