Search found 4 matches

by erwinkooi
Wed Apr 14, 2010 5:52 pm
Forum: misc
Topic: SQL-Database
Replies: 14
Views: 13093

Re:SQL-Database

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.
by erwinkooi
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]
by erwinkooi
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 ...
by erwinkooi
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.