UUIDs are so funny today because almost all of their deployments is "we take a string of mostly-random bits but give it structure for no apparent reason"

it's true that you could populate some of those bits with predictable sequences to avoid clashing (a la snowflake) but guess what: you can do this to a hex string or a number (as does snowflake). i think the only reason UUIDs are as popular as they are today is Microsoft?

Follow

@whitequark I'm a big fan of using UUIDs and encoding information into them, such as tenant ids, timestamp, object type as well as a random portion.

So much more useful than a sequential big integer primary key.

The formatting is mostly irrelevant to me, just a useful standard for systems to know that it's a 16 byte id.

Even did a conference talk online for POSETTE last year about they're cool and not as bad as a lot of people think.

Sign in to participate in the conversation
Mastodon

Time for a cuppa... Earl Grey please!