![]() ![]() Vantage Pro VProWeather Communications Software VProWeather/mySQL DB Interface
|
| Now supports Vantage Pro2 |
| With mySQL DB support! (23-Jan-2008) |
| New Database Version 11.2 (05-Sep-2011) |
| After weeks of design, coding, testing, and loading close to 3 years of Vantage Pro derived weather data, then reloading, and then reloading again, the VProWeather/MySQL Database and interface was released back in 2008. VProWeather now supports and directly interfaces with a MySQL Database. It directly updates the Real Time and Graph data downloaded from the Vantage Pro Console and stores it in the MySQL database. Daily Highs and Lows, Monthly Highs and Lows, and Yearly Highs and Lows are also automatically determined and stored in the Database. |
| In the spring of 2011 after a bit of neglect, vProWeather's MySQL's interface and database was given a facelift. A few bugs were fixed, columns were added to store additional data, to mention a few things. See the CHANGELOG for a comprehesive list of what was done. |
| All mySQL SQL scripts are included to create the Database, setup the Triggers on the various Tables, and setup additional Indexes for fast data retrieval. Click on the Thumbnail Image below for the Full Size View of the Database structure. |
| In addition, the Spring 2011 facelift includes some additonal utility type programs to populate the data of some of the new columns that were added. A program to load data that may have been gathered from a Vantage Pro or other weather station is also provided to load that data into the MySQL Database. And a conversion program is provided to format the data so that it can be loaded. |
|
|
Current Version v1.0.5 16 OCT-2011 Click Here to Download md5 checksum here View the Change Log here |
|
| Click Here to see Data Variable Names & Descriptions and Sample Data |
| Email me at: Weather[replace with(at)]curtronics.com with any questions. |
|
This is an extension of Joe Jaworski's initial work, adding some functionality not in his initial work (Solar, ET, THSW UV, Leaf, Soil, etc.), and fixing some bugs. |
|
||||
|
![]() |
![]() |
![]() |
![]() |