Connecting to a MySQL Server to Retrieve Data
I have a MySQL server that is storing temperature sensor data that is being logged every second.
I was wondering if anyone has any experience or knowledge of a suitable approach to retrieve this data from the MySQL server, process the data, and then provide me with an output?
Let’s say, for example that I want it to display the average temperature from my sensor from 7am-8am on a particular day. I would like to connect in to the MySQL server, extract the data for that day, process the average, and then output it in some format on my mirror.
Thanks for any preliminary guidance!
You probably need something like this installed then : https://github.com/sidorares/node-mysql2/blob/master/README.md
But more than that I don’t know