I have just published the first version of a Twitter aggregation database and tweet display framework called 140dev. The code is at: http://140dev.com/free-twitter-api-source-code-library/
This is written in PHP and MySQL on the server side, and JQuery and Javascript on the client side. The functionality is pretty basic now, but I have plans to extend it over time. This code is very heavily documented, and is meant as a working tutorial for Twitter API programming. It uses the Phirehose library to access the Twitter Streaming API and collect tweets containing a set of keywords, stores the tweets into a normalized MySQL database, and then returns the most recent tweets as linkified, formatted HTML. Javascript code in the browser uses Ajax to load older tweets, and to automatically update a count of new tweets, as done on Twitter.com. The result is a real-time tweet stream that can be added to any Web page with a single line of PHP code. I'd really appreciate any comments you have on this code. It is GPLed and has a plugin architecture, so if anyone wants to add on to it, let me know. - Adam Green http://140dev.com 140...@gmail.com @140dev -- Twitter developer documentation and resources: http://dev.twitter.com/doc API updates via Twitter: http://twitter.com/twitterapi Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list Change your membership to this group: http://groups.google.com/group/twitter-development-talk
