undefined | Better HN

0 pointssmt8811y ago0 comments

That's still incremental though. It just looks different.

0 comments

bigint gives you 9.2 quintillion options before you run into a collision. Which is obviously not forever proofed, but certainly future proofed.

smt88OP11y ago

OP isn't asking for a data type that can hold more than a billion records.

OP needs a way to generate a random ID without checking that the ID has already been used -- s/he wants a UUID. Bigint is FAR too small to do that a billion times without a collision.

j / k navigate · click thread line to collapse

0 comments

Jeremy102611y ago

bigint gives you 9.2 quintillion options before you run into a collision. Which is obviously not forever proofed, but certainly future proofed.

smt88OP11y ago

OP isn't asking for a data type that can hold more than a billion records.

OP needs a way to generate a random ID without checking that the ID has already been used -- s/he wants a UUID. Bigint is FAR too small to do that a billion times without a collision.

j / k navigate · click thread line to collapse