undefined | Better HN

0 pointsTostino2mo ago0 comments

Not OP, but UUID v7 is what you want for most database workloads (other than something like Spanner)

0 comments

4 comments · 2 top-level

tossandthrow2mo ago· 2 in thread

I use the null uuid as primary key - never had any DB scaling issues.

petalmind2mo ago

Yeah, no NULL is ever equal to any other NULL, so they are basically unique.

Groxx2mo ago

You are also guaranteed to be able to retrieve your data, just query for '... is null'. No complicated logic needed!

RedShift12mo ago

Me still using bigints... Which haven't given me any problems. Wouldn't use it for client generated IDs but that is not what most applications require anyway.

j / k navigate · click thread line to collapse