Comment on 5NF and Database DesignparentComments−Tostino4moNot OP, but UUID v7 is what you want for most database workloads (other than something like Spanner)−tossandthrow4moI use the null uuid as primary key - never had any DB scaling issues.−petalmindOP4moYeah, no NULL is ever equal to any other NULL, so they are basically unique.−Groxx4moYou are also guaranteed to be able to retrieve your data, just query for '... is null'. No complicated logic needed!−RedShift14moMe 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.
Comments
Not OP, but UUID v7 is what you want for most database workloads (other than something like Spanner)
I use the null uuid as primary key - never had any DB scaling issues.
Yeah, no NULL is ever equal to any other NULL, so they are basically unique.
You are also guaranteed to be able to retrieve your data, just query for '... is null'. No complicated logic needed!
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.