4 min read
Can Two UUIDs Ever Collide? The Actual Math
UUIDs are said to be unique enough to ignore the possibility of a collision entirely. Here is the birthday-paradox math behind that claim, worked out in full.
databases
3 articles tagged “databases”.
4 min read
UUID vs GUID vs Nanoid vs Auto-Increment: Picking an ID Strategy
Four common ways to identify a row, and the trade-offs that actually distinguish them — size, coordination, what they leak, and whether anyone else uses the same format.
2 min read
UUID v7 vs v4 as a Database Primary Key
Random v4 UUIDs scatter writes across your index and cause page splits. Version 7 sorts by time and fixes it, without giving up global uniqueness.