a robust decoding and reporting system for WSPR
Please note: The WsprDaemon Timescale database may be subject to change, the information below will reflect those changes.
10-15 May 2020: Major change in wsprdaemon v2.9 to add generated by wsprd meant change of table names. Previous tables were deleted on 20 May 2020.
After trying out Influx as our database for wspr spots and noise we settled on . In this application TimescaleDB required less CPU and disk resources to provide useful functionality. TimescaleDB is built upon , an open source full-featured relational database using SQL (structured Query Language).
There is the inevitability of jargon - our current implementation comprises:
• Two Databases with names 'tutorial' and 'wsprnet'.
Within the 'tutorial' Database, we currently have three Tables:
• wsprdaemon_spots - comprising wspr spots uploaded by WsprDaemon users that choose to do so.
• wsprdaemon_noise - comprising noise spots uploaded by WsprDaemon users that choose to do so.
• kp - a geomagnetic disturbance index, scraped each day from NOAA's .
Within the 'wsprnet' Database, we currently have one data Table:
• spots - comprising wspr spots obtained from wsprnet.org via an API.
These postgeSQL Tables have been converted into Hypertables for use with TimescaleDB.
Each Hypertable has a Data Retention Policy set by our server capacity. For our logs2 server, for data in:
• RAM - 30 days, before migrating to
• SSD - one year, before migrating to
• RAID - our aim is to retain for 11 years, a sunspot cycle
Check out our Guide by clicking the TimescaleDB logo.
This version covers installation of postgreSQL on your machine, how to gain access to the WsprDaemon database and sample Tables, together with numerous examples of simple SQL queries in 'Flat File' mode.