TwitterThoughts creates charts based on Twitter tweets in combination with lots of APIs: From a sample of 600 tweets/minute served by the Twitter Api that we send to Yahoo Pipes where it extracts all phrases from the tweet text and the latitude/longitude with use of Yahoo YQL. This Yahoo Pipe outputs serialized PHP back to our local update script that grabs every tweet and phrase and puts it in our MySql database. Daily overviews for fast rendering of the chart data are generated with a daily CRON update. Finally Google Visualization API generates an interactive flash chart based on our JSON data feed.
12 May: Started rendering again, but database will be fully emptied every sunday!
Did you know you can zoom in by holding your mouse down and dragging a rectangle?