Re: [mh] database help

[Marc M. <ma...@me...>]

On Fri, Dec 11, 2009 at 09:57:13PM -0600, Joel Davidson wrote:
> I've got a bunch of info I'd like to store in a database of some
> sort with time/date stamps.  Things like temperatures, hvac status,
> etc.  I know some of you have done this (Hi Marc!), but I don't know
> where to start.

I went all out and used cacti. Cacti does take a little while to learn
but if you are serious in logging temperatures/power and do mixed graphs
with that data, this is really the way to go.
Cacti uses rrdtool for the database which in my case I configured not to
delete data (i.e. I have 1 or 5mn resolution for 30 years, which is
about 1GB for 20 samples). This is not how it's meant to be used, but it
works fine that way :)
cacti was specifically my choice over other options because it lets you
zoom on an arbitratry time range in the past, which few other options
let you do.

Marc
-- 
"A mouse is a device used to point at the xterm you want to type in" - A.S.R.
Microsoft is to operating systems & security ....
                                      .... what McDonalds is to gourmet cooking
Home page: http://marc.merlins.org/