Database

The final section of the implementation phase focuses on sending the data to an external database and subsequently graphically visualizing the measurement results. As mentioned earlier, the database already existed prior to the start of this project, so a solution had to be found to enable data to be sent to an InfluxDB database. For this purpose, an add-on called "InfluxDB" was installed in Home Assistant. To establish a connection between Home Assistant and the database, a bucket and a token are created first. This is necessary to precisely specify where the data should be sent within Home Assistant. The "configuration.yaml" file is updated with the created bucket and token, as well as the attributes of the database. Additionally, all entity IDs that are supposed to send sensor data to the database are passed on. Once it is confirmed that the database is receiving the sensor data, the graphical representation begins. Two diagrams are created using a program code, which compare the current indoor and outdoor temperature with the setpoint and display the current humidity. Since it is currently not possible to access the Home Assistant operating system outside the network, visualizing the sensor data on an external database is a way to view the sensor data outside the network.

Figure: Database, Fabio Bock