Currently Discord has approximately 1.360.000.000.000.000.000 (1.36 * 10^18) IDs used up and a long can store integers up to 2^63 - 1, which is approximately 9.22 * 10^18.
My question now is if I should be confortable with using a BIGINT (equivilant in size to long) in my mariadb database or not. In the almost 10 years since Discord exists, about 1/8 of a BIGINT has been filled.
Also is it known if Discord uses a long int in the background as well or something else and if so, what the plans for the future are?
Thanks in advance!
Alright, I guess I didn't check enough beforehand:
https://discord.com/developers/docs/reference#snowflakes
This article clearly explains that IDs are implemented as Snowflakes and are unsigned long integers.