Tuesday, January 5, 2010

Using Google Visualization API for Power Monitoring

I just started playing around with the Visualization API today and it's pretty cool. Here's a short screencast I just did showing real-time power usage from our Brultech ECM-1240 power monitor. Every second, data from the ECM-1240 is stored in MySQL. The gauges are in a simple HTML page with a little AJAX to fetch the power data each second from MySQL. The API takes care of the graphics and updating them.

Posted by at

4 comments:

  1. UnknownJanuary 17, 2010 at 12:32 PM

    Neat. Any code you could share about this? Have thought about doing a similar dashboard for data in a MySQL db..

    ReplyDelete
  2. RJanuary 17, 2010 at 1:18 PM

    my AJAX code is really optimized for my setup and it'd be work to extract relevant parts, but there are lots of tutorials for using AJAX with mysql ( ie: http://www.w3schools.com/PHP/php_ajax_database.asp ). plus, the google api has lots of sample code.

    ReplyDelete
  3. Adam "VIC" FrederickJanuary 19, 2010 at 6:13 PM

    This is cool. I do want for my sensor network which I am building now to post directly to google appengine or spreadsheets.

    To comment on your demo - Not sure that the dials are the right widget for this kind of information. You are probably just experimenting with the widgets so no further comment neccessary.

    Anyway I am an Eventghost user. I do not yet use xPL because I think Eventghost does a lot of the things that I would use xPL for. Your posts do make me want to look at xPL though.

    ReplyDelete
  4. RJanuary 22, 2010 at 9:04 AM

    i wanted real-time line charts like those in tomato router firmware ( http://bit.ly/7sYzba ). the google line charts didn't work out, but the gauges gave nice eye candy.

    EG has a lot of functionality and you could implement a lot of the google API stuff in python scripts since they offer a python SDK. xPL's main benefit, to me, is that it's a well defined protocol that lends itself well to a distributed type of control environment. EG is more centralized.

    feel free to stop by the xPL forums ( http://xplproject.org.uk/forums ) if you decide to give xPL a try.

    ReplyDelete

Subscribe to: Post Comments (Atom)