Free Source Code: Twitter Database Server
This free PHP source code library is the core module of the 140dev streaming API 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.