Elliot, I don't have the code you want, but I have some information I think will be useful in scoping the problem. I have been running the collection you speak of for the last year using owfs. I have lots of sensors beyond the rooms, and since the program actually controls the heating and cooling, I have the control actions directly.
I have 2 kinds of room sensors. One is a bare DS18B20 hanging in the air. The other is an attempt at a mean radiant temperature (mrt) sensor. The 18B20 is glued into the back of an acorn nut with thermal epoxy and the nut is painted black. This gives a significant thermal mass to the reading location and reduces rapid ups and downs. I also remove all duplicate inputs and i never record the first reading in the opposite direction. This cuts down the number of samples recorded by a large number. I sample around 2500 times a day (every 30 seconds), but record on average around 100 temps for the mrt and 250 temps for the bare sensor. It still adds up with around 5M readings so far this year. I have my database laid out such that a sample is 20 bytes plus record overhead (id,date,sensor_id,value). This is the nice thing about a database., to make it human useful in a log file was about 50 bytes long. yours, jerry Paul Alfille wrote: > Hi Elliott, > > Thank you for the kind words. > > I'm sending your note to our developer's list, since there is a > community interested in this problem. > > Christian Magnusson has written a "wrapper" script that stores and > graphs the data in a rrd database. This is the "Round Robin Database". > > A number of people (like Mike Kalist) use mysql as a backend. You can > extract the data and populate the database by a number of means: > bash scripts, perl, python, etc. Actually any programming language > that allows you to read and write files. > > Paul Alfille > > ---------- Forwarded message ---------- > From: *Elliott Jeyaseelan* > Hi Paul, > > I bumped into your OWFS site and downloaded the software and tried it > on my > centos box. I was very impressed with the fact that everything worked > without a single hitch. > > What I am trying to do is create a thermal profile for my house by reading > and storing temperature of different rooms in my house and trying to > graph > after saving it on mysql under linux os. I am also trying to capture the > thermostat events like, turn on heat or cold or blower, hopefully this > would > help give a better picture on my house leaks heat or cool during the > different parts of the year, and what part of the house needs to be better > insulated etc etc > > Does such code already exist as part of your owfs suite of > applications, or > do you recommend that I write some basic bash scripts to accomplish > this? I > am not very familiar with bash scripts but its never too late. > > Just wanted to check with you first before trying to re-invent the wheel. > > Thanks for making a superb collection of software, I am sure there are > many > others who have volunteered their time and effort towards this project, > thanks to them also. > > Regards, > Elliott > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > ------------------------------------------------------------------------ > > _______________________________________________ > Owfs-developers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/owfs-developers > > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Owfs-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/owfs-developers
