The Twitpocalypse is Near: Will Your Twitter Client Survive?: Twitter will cross over a datatype boundary soon. Hilarity might ensue.
The maximum signed 32-bit integer value for most database applications is 2,147,483,648. This is a huge value, but the accelerating popularity of Twitter means has the amount of tweets is rapidly approaching this limit. If third party application developers haven’t designed their Twitter clients to store tweet IDs using something like the less restrictive unsigned 64-bit integer data structure, users might start seeing strange errors, such as tweets listed in the wrong order – or worse, applications not working at all.