Hi Mike,
Depending on your weather station hardware, you probably do not need a reading every minute. I found my wireless sensors sending data every 15 minutes, so there was no reason for more frrquent polling and I could lower the stress on the servers.
Just a thought.
Search found 4 matches
- Wed Apr 14, 2010 5:52 pm
- Forum: misc
- Topic: SQL-Database
- Replies: 14
- Views: 13093
- Mon Apr 12, 2010 9:44 pm
- Forum: misc
- Topic: SQL-Database
- Replies: 14
- Views: 13093
Re:SQL-Database
Sure, here you go.
The reading table (and host table) have been stripped.
Please let me know if it works and if you have any problems and/or improvements. [file name=weatherlog.txt size=7996]http://www.meteohub.de/joomla/images/fb ... herlog.txt[/file]
The reading table (and host table) have been stripped.
Please let me know if it works and if you have any problems and/or improvements. [file name=weatherlog.txt size=7996]http://www.meteohub.de/joomla/images/fb ... herlog.txt[/file]
- Thu Nov 19, 2009 7:36 pm
- Forum: misc
- Topic: SQL-Database
- Replies: 14
- Views: 13093
Re:SQL-Database
OK, my setup is as follows:
A scheduled script pulls raw data from MeteoHub, parses the values and uploads it into a mysql database.
The database has four tables. Host, Mapping, Reading and Sensor.
Host is the table that holds the info on the MeteoHub server.
Sensor is the table that holds the ...
A scheduled script pulls raw data from MeteoHub, parses the values and uploads it into a mysql database.
The database has four tables. Host, Mapping, Reading and Sensor.
Host is the table that holds the info on the MeteoHub server.
Sensor is the table that holds the ...
- Wed Jul 08, 2009 10:45 pm
- Forum: misc
- Topic: SQL-Database
- Replies: 14
- Views: 13093
Re:SQL-Database
That script would indeed be interesting. I use rrdtool for most of my graphs already and generating them from the sql database would offload some precious cpu cycles from my meteohub system.