View Full Version : SQLstream powers Firefox 3.5 realtime downloads monitor

06-30-2009, 10:01 PM
Mozilla launched Firefox 3.5 (http://www.mozilla.com/firefox) today, and with it, a neat applet, powered by SQLstream (http://www.sqlstream.com), to monitor downloads in real time.

http://2.bp.blogspot.com/_BVv0WTpeWTs/SkqjjCsFmtI/AAAAAAAAADM/UvqG-XUOhHA/s320/heatmap.jpg (http://2.bp.blogspot.com/_BVv0WTpeWTs/SkqjjCsFmtI/AAAAAAAAADM/UvqG-XUOhHA/s1600-h/heatmap.jpg)You can see the results at Mozilla's download stats page (http://downloadstats.mozilla.com).

A few weeks ago, Apple's Hyperwall (http://www.creativereview.co.uk/cr-blog/2009/june/apple-hyperwall) was awe-inspiring as a piece of visual art, but it was less impressive as a piece of real-time data integration, because the data was delayed five minutes (http://www.appleinsider.com/articles/09/06/09/apple_stuns_wwdc_crowd_with_pulsating_app_store_hyperwall.html) from the app store.

SQLstream gathers data from Mozilla's download centers around the world, assigns each record a latitude and longitude, and summarizes the information in a continuously executing SQL query. Data is read with sub-second latencies, and then aggregated (using SQLstream's streaming GROUP BY operator) into summary records each describing a second of activity.

A server-side Java program reads the data using JDBC, serializes it as JSON, and transmits it to all connected web clients. Clients render the charts using the Canvas tag, newly introduced in HTML 5 (http://en.wikipedia.org/wiki/HTML_5). The results are very impressive visually, but to a back-end guy like myself, the plumbing is impressive too.

The amazing thing is that SQLstream makes this so easy. Our official company blurb talks about "shortening data integration projects from months to weeks", but this project took just a couple of days of work.

By the way, don't try to view the page in Microsoft's Internet Explorer. Ten years ago, Internet Explorer led the charge to enhance the capabilities of the web browser, introducing dynamic HTML (DHTML), XML handling in the browser, ActiveX controls and other capabilities, but those days are over. With HTML 5 there is a renaissance in web standards; Firefox is leading the pack, with other 'modern' browsers such as Safari (http://apple.com/safari), Opera (http://www.opera.com) and Chrome (http://www.google.com/chrome) not far behind.https://blogger.googleusercontent.com/tracker/5672165237896126100-6307425355657845641?l=julianhyde.blogspot.com

More... (http://julianhyde.blogspot.com/2009/06/sqlstream-powers-firefox-35-realtime.html)