#uuidv7 — Public Fediverse posts

there seems to be a lot of excitement for #uuidV7 these days (timestamp-based). it's very cool, and a good choice if you're using the #uuid or #guid as a database key (to avoid fragmentation)

https://ntietz.com/blog/til-uses-for-the-different-uuid-versions/

i also really like #ulid for this, and they can be converted to uuids/guids easily and quickly.

one thing i don't see many people talk about when they move to monotonically incrementing ids (like v7/ulid) is this: if you have a distributed database you will end up with poor balancing with these ids. not what most people do, i guess, but it's something to think about.