Category Archives: MySQL

All Clear!

I forgot to put up a ‘everything’s done!’ post.  Well, all the stations are back up and working very well.  West Parish has not shut down, Plum Cove has registered all the rain that just fell over the past few days, and East Gloucester is showing accurate humidity.

I also installed the computer for the Windspire, at the moment it is sitting there collecting data from Windsync and putting it in a daily csv file.  I also installed cygwin and MySQL workbench so soon I will be able to write a script or something to import those files into MySQL and do something cool with them.  It might be easier then I thought with the daily csv’s, since if I don’t want live data I can simply convert the file at the end of the day and leave it at that instead of trying to update on the fly with data coming in.

O’Maley is back up!

I got to go on the O’Maley roof and put up the weather station, and now we are getting good data! It is also just in time for some high winds, and they seem to be reporting accurately.

Also, slow progress has been made with the MySQL graphs, since now I have to together enough to run a decent looking 24 hour graph of wind direction and air pressure. But I am reading about http://saratoga-weather.org which has some nice looking templates that I might use instead of ‘rolling my own’.