So some background on what I have used node red for. I am currently a controls engineer and was trying to find a way to track data from water flows on different circuits on a machine over my companies network. This led me to node red! I was able to use a MQTT gateway to send data (water flows) over modbus protocol to the gateway and then use node red on a raspberry pi and send it to influxdb and then use grafana to graph the data in real time. It was very simple.
I currently have been tasked to find a way to track data on a new machine but this time preferably in table format and it will not be in real time.
The way the machine I built works is it is a water leak tester for hundreds of Casting Dies. I will have a MQTT In node on node red for "The number of Die" and a MQTT node for each water circuit. It comes out to be about 10 MQTT in nodes. My company wants to walk over and press a button mid cycle and snapshot the data for that particular time on that particular die. I have the ladder logic and gateway programed already.
My question is if anyone has an Idea what the best way to take these MQTT IN nodes and store them in a database, as well as plotting them in a table. I was thinking to MYSQL, and then to Excel. but im not sure how to take all these nodes and put them into the same database
Any advice would help greatly!