News for hackers. Stuff that matters.

A comment on UUIDs are popular, but bad for performance (2019). Parent comment

Re:UUIDs are popular, but bad for performance (2019) by rwoerz on Saturday January 08, 2022 @03:46PM (#29856026)
From RFC4122: "A UUID is an identifier that is unique across both space and time, with respect to the space of all UUIDs."

Hard to achieve if everyone starts from 00000000-0000-0000-0000-000000000000.

[ Parent | on HN ]
Re:UUIDs are popular, but bad for performance (2019) by rco8786 on Saturday January 08, 2022 @07:18PM (#29858252)
Right that’s why nobody starts at 0. And you don’t have to only add 1 to be ordered, no DB I’m aware of just adds 1 to sequential UUIDs. There’s always randomness/entropy involved.
[ Parent | on HN ]
Re:UUIDs are popular, but bad for performance (2019) by ztorkelson on Saturday January 08, 2022 @05:41PM (#29857274)
Sequential UUIDs don’t start at 0. They are a 128-bit composite of two integers; a temporal component in the high order bits and a random component in the low order bits.
[ Parent | on HN ]