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

Figure: Database, Fabio Bock
Last modified: Monday, 3 July 2023, 12:27 PM