Hi. I'm working on a project which consists of 3 raspberry pi's collecting data from different points in the field. These data collected to node-red are sent to a fourth raspberry pi by mqtt broker mosquitto (I'm thinking about using linux as the OS installed on the RPIs), which should store all data that are sent at regular short intervals (2 seconds to half an hour, depending on the variable). This fourth RPI not only have to store data from all the time is collected, but it should also design graphs for analyses, set alarms based on that, and front-end.
Based ond that I'm considering about using InfluxDB + Grafana. But from what I've searched over the internet and forum, I saw other options like MySQL, so I'm not sure.
- What are your thoughts on this subject?
- Do you recommend Node-Red Dashboard to use as professional front-end, so a client can access information from it?