Integer range is 2,147,483,647. Facebook has 2.96B users. Facebook is the only company that graduated from int to unsigned int, which is 4,294,967,295.

And you're using bigint as an id for the “users” table. I just laugh.

GUID.

GUID all the way.

@tosensei can you pls elaborate on why it is better than uuid-version-whatever

@kiki it's just a different name for the same thing

GUID = Microsoft’s UUID

For the rest of the world, it’s UUID

How about posts. They prob have uuids with letters

@tosensei @Lensflare ah, I didn’t know. Thanks 🐸

Facebook can't use unsigned int, it can't represent negative numbers. And they have negative users in the "metaverse"

@Lensflare technically correct would be UUID V4, though GUID has changed the definition a bit... So it's not a fully compliant UUID v4.

@kiki don't let them fool you.

UUID / GUIDs are a problem in itself regarding storage and partitioning.

Integers make this far easier.

You want partitioning in that kind of range for sure.

What about the time that we colonise the galaxy mod everyone is using Facebook shit? Betcha they’d be needing more.

Best bet is a GUID on a noSQL DB I guess.

i would call it "future-proofing"

people who were the cause for Y2K are not laughing, i would expect/assume.