Author Topic: WeatherLink Observations in a MYSQL database  (Read 4168 times)

0 Members and 1 Guest are viewing this topic.

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 56
    • HoosierWeather
WeatherLink Observations in a MYSQL database
« on: May 30, 2016, 12:49:59 PM »
I've just finished work on the first Java-based version of wx2sql that will run on Windows, OSX, and Linux.  The application will take weather observations that were recorded in WeatherLink and input them into a mysql database.  It is also capable of monitoring the active data file for changes, inputting each change into the database, thus keeping the database current.

If you would like to try it, the documentation, SQL script, and wx2sql are all available for download from http://www.hoosierweather.com/software .

[youtube]https://www.youtube.com/watch?v=f6jblq8LTgg[/youtube]
Twitter:               @HoosierWeather
YouTube Channel: https://www.youtube.com/user/hoosierweather

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: WeatherLink Observations in a MYSQL database
« Reply #1 on: May 30, 2016, 02:52:23 PM »
NOW someone releases this - after I switched off Weatherlink.   =D>  Good job!  I am going to take a look at it to convert my old WLK files to an SQL db so that I can prepend my new Meteobridge records from the last 6 or 7 years.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline ValentineWeather

  • Forecaster
  • *****
  • Posts: 6364
    • Valentine Nebraska's Real-Time Weather
Re: WeatherLink Observations in a MYSQL database
« Reply #2 on: May 30, 2016, 03:59:46 PM »
Very nice, thanks a bunch. If I ever go back to WL I'll give a look.
Currently I store data with Envoy8x Weather data transfer utility (WDTU) when its not crashing. Wish they would of added a debugger mode for it. Trying compatibility mode XP service pack 3 today.
Randy

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 56
    • HoosierWeather
Re: WeatherLink Observations in a MYSQL database
« Reply #3 on: May 30, 2016, 07:48:57 PM »
What can I say, a single developer project, family, and job.  It just took some time.  :)
Twitter:               @HoosierWeather
YouTube Channel: https://www.youtube.com/user/hoosierweather

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: WeatherLink Observations in a MYSQL database
« Reply #4 on: May 30, 2016, 08:38:51 PM »
64 MB for the executable (.msi)?  Really?  And the sql script link is inactive.
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 56
    • HoosierWeather
Re: WeatherLink Observations in a MYSQL database
« Reply #5 on: May 30, 2016, 09:22:30 PM »
Since this is a Java based program, it does require a JRE to run.  The msi contains both the wx2sql application and the Java runtime.  This allows the application to run on a system where Java is not even installed.  The drawback to this approach is the increased filesize of the installer.

I did see the download link for the sql script was not working, I have taken care of that issue.  Thank you for pointing that out.
Twitter:               @HoosierWeather
YouTube Channel: https://www.youtube.com/user/hoosierweather

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: WeatherLink Observations in a MYSQL database
« Reply #6 on: May 30, 2016, 09:30:59 PM »
Since I already have JRE, any chance you could decouple that?  Java versions are my nemesis.  :)  BTW, did you ever consider writing this in something like Python?
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: WeatherLink Observations in a MYSQL database
« Reply #7 on: May 30, 2016, 09:34:09 PM »
And to be more of pest and "that user"  LOL, any chance you could consider making this portable? Even if it has to use jPortable?
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 56
    • HoosierWeather
Re: WeatherLink Observations in a MYSQL database
« Reply #8 on: May 30, 2016, 09:51:50 PM »
Dang, you are being 'that user'.  Lol, no worries, it is all good.  Feedback is a good thing.

So, I can definitely look in to repackaging the app without a JRE. It should not be difficult, I may offer both variations as a download.

Before starting to code the app, I looked into what language I wanted to use.  I took a couple of android development classes last summer, and I needed to pick up Java for work, so that decision kind of made itself. I like the flexibility that Java affords, I can run the app on either my Windows or Linux Server.

Honestly, I have many features planned for the app, but making it a portable piece of software is not one of them (at least for right now).
« Last Edit: May 30, 2016, 10:06:20 PM by darkpenguin »
Twitter:               @HoosierWeather
YouTube Channel: https://www.youtube.com/user/hoosierweather

Offline Bushman

  • Forecaster
  • *****
  • Posts: 7549
    • Eagle Bay Weather
Re: WeatherLink Observations in a MYSQL database
« Reply #9 on: May 30, 2016, 10:14:44 PM »
Java is not a bad choice, but there seem to be security issues popping up all the time with it.  I did Python for work, and it is fairly portable so it is my choice.  Runs on Android, too! I appreciate your efforts nonetheless.  :)

Signed:
"That User"
Need low cost IP monitoring?  http://wirelesstag.net/wta.aspx?link=NisJxz6FhUa4V67/cwCRWA or PM me for 50% off Wirelesstags!!

Offline darkpenguin

  • Senior Member
  • **
  • Posts: 56
    • HoosierWeather
Re: WeatherLink Observations in a MYSQL database
« Reply #10 on: June 11, 2016, 11:59:51 PM »
I don't intend to keep cluttering up this thread with release information, but Bushman, this should address some of the issues that you brought up.  I just put beta 2 out for download, along with additional documentation.  Here are a list of changes:
  • Added the ability to Export and Import your configuration file.
  • Fixed an issue with the logging subsystem that prevented log events from being displayed when the counter
    reached ~15,000 entries.
  • Switched installer program to something a little less primitive. This results in a smaller setup program, but
    you are now required to have Java installed on your machine.

Upgrade steps are also included in the program documentation, but they are rather simple.
  • Make a backup copy of your current configuration file. In Beta 1, this was located in
    c:\Users\<UserName>\AppData\Local\wx2sql\app\config.properties . Place this backup in a location you
    will remember.
  • In Programs and Features, uninstall the current version of wx2sql.
  • Download 0.1.0 Beta 2 from http://www.hoosierweather.com/software and launch the new setup program,
    wx2sql_setup.
  • Import you previous configuration file. Select File→ Import Config and select the backup that you made
    earlier.
  • No changes to your database are necessary.
Twitter:               @HoosierWeather
YouTube Channel: https://www.youtube.com/user/hoosierweather

 

anything