A colleague approached us with the need for an independent meteorological system to collect real-time data from a local weather station. This data would be used to manage several interconnected applications, including the automated control of garden pond pumps based on outdoor temperatures.
To collect and manage data, we developed a comprehensive system utilizing a wireless Davis Vantage Vue weather station connected via USB cable to a Raspberry Pi. The Raspberry Pi regularly retrieves data from the weather station and stores it locally in an SQLite database. Every five minutes, this data is transferred to a PostgreSQL database hosted on a remote server.
We developed a universal FileMaker database, where data from PostgreSQL is written using an ODBC driver. This database integrates various sensors, providing a comprehensive overview of current conditions and enabling efficient management of connected devices.
