Free Source Code: Twitter Database Server
The updated version of this code for Twitter’s API 1.1 is now available for download. This must be done before June 11th when the new API becomes mandatory.
This free PHP source code library is the core module of the 140dev Twitter framework. It uses the Twitter streaming API to gather tweets for selected keywords and stores them in a MySQL database. Entities within the tweets, including user @mentions, hashtags, and URLs are stored in separate tables to optimize the performance of tweet data mining. The rest of the modules in this framework use this database.
This Twitter database cache architecture has many advantages. It allows you to separate your website apps from the Twitter API, protecting your website from Twitter’s occasional performance and reliability problems.