I am not a developer or coder so thought I would check-in here to see if anyone has developed a way to import live data from the Hub to an SQL Server database. At a 2 second interval that is 43,200 lines of data. I would only store 24 maybe 48 hours worth. I use MS SQL Server (you can get the enterprise version for free to use for development work).

There are several PWS weather apps that can read the UDP data and then store it. I use Weather Display and it can write out to mysql or MS SQL.

WeatherDisplay only sends data every minute. I want to capture at a higher rate.

[image] ordnance1: import live data from the Hub to an SQL Server database. You can only import what the HUB emits, meaning every 3 secs or so for rapid-wind, every 10 secs or so for device status, every 60 secs for sensor observations if I recall the numbers correctly. If you’re not a developer or coder, this might be a bit of a stretch even with the various 3rd-party things people have cooked up in the last year or so here.

Capture data to SQL Server

Developers

gizmoev April 26, 2019, 6:17pm 4

What about ArchiveSW - Display & Data Archive Storage

Topic		Replies	Views
SQL Server support Developers	19	1742	February 22, 2018
Local data storage General	5	970	April 3, 2018
Api update intervals Developers	40	3202	September 18, 2018
UDP data transmitted by the Hub Developers	14	6131	October 26, 2018
Smart Weather Archive for Cheap Local Storage Tempest Owners wfarchive , archivesw	64	5451	April 11, 2018

Capture data to SQL Server

Related topics