Comment on Twitter's UID associated to each tweet will very soon exceed 2,147,483,647Comments−DrJokepu17yIn the age of multicore 64 bit CPUs, they're not using signed 32 bit integers as primary key, do they?−thristian17yTo be fair, they say "For some of your favorite third-party Twitter services not designed to handle such a case..." rather than accusing Twitter themselves of primary-key ineptitude.−domdefelice17yI think the problem is not in twitter itself but in the services using their APIs.−ks17yTwitter is using an unsigned 64-bit bigint according to this:http://twitter.com/twitterapi/status/2048659057
Comments
In the age of multicore 64 bit CPUs, they're not using signed 32 bit integers as primary key, do they?
To be fair, they say "For some of your favorite third-party Twitter services not designed to handle such a case..." rather than accusing Twitter themselves of primary-key ineptitude.
I think the problem is not in twitter itself but in the services using their APIs.
Twitter is using an unsigned 64-bit bigint according to this:
http://twitter.com/twitterapi/status/2048659057