Re:5NF and Database Design
by Tostino on Tuesday April 14, 2026 @01:06PM
(#47768298)
Not OP, but UUID v7 is what you want for most database workloads (other than something like Spanner)
[ Parent
| on HN ]
Re:5NF and Database Design
by tossandthrow on Tuesday April 14, 2026 @03:14PM
(#47770059)
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!