Re: Owl/Electrisave and Currentcost meter graphs [was: [OT] Google Streetview car spotted]

[James Fidell <james@xxxxxxxxxxxx>]

Rob Iles wrote:
> Very Pretty :) (and I'm sure useful too, if I read it properly).
>
> Just wondering what you used for graphing - looks very reminiscent of
> MRTG/RRDTool...

It would do...

I hacked about with some existing perl code I found to read the meters,
creating a couple of daemons that write their data into a MySQL database
and RRD files.  Once that was working I created all the graphs using
cacti, a web-based front end to RRDtool.

It's a little clunky, but putting the data into MySQL means I can
subsequently write code to do "interesting stuff" with the data
and
regenerate the RRD files should I wish.  For creating the graphs, the
RRD stuff just works so much better than anything else I've ever seen
that it seems stupid not to use it.  Unfortunately it (eventually)
throws away the raw data and isn't really as helpful as relational
databases for some things, so I decided to use both.  Disk is cheap,
after all :)

James

------------------------------------