UUID Primary Keys Debate
Comments debate the use of UUID variants (v4, v7, ULID) versus sequential auto-increment IDs or bigints as database primary keys, focusing on advantages like uniqueness and sortability against drawbacks in indexing, storage, and performance.
Activity Over Time
Top Contributors
Keywords
Sample Comments
Why did you not want to use UUID's?
What's the use case here over a UUID?
If you don't think that's a concern then UUID8 is for you!
Care to example some usage cases? And why uuid over auto-increment sequenced number?
What is the use case for UUIDv4/v7 when bigint is faster and uses less storage space?
Yeah, just use uuidv4 and another "ULID" if thats the casewhich is pointless
What are the advantages of sortable UUIDs with embedded timestamps over random 128 bits and a created_at column?
tl;drUse UUIDv4 and get on with your day.
Isn't this the reason UUIDs were invented?
Could you switch from UUIDv4s (what I assume you mean by “pure UUIDs”) to UUIDv1s?