Extract data from Node-Red

[tgottie]

hello, so I am collecting a information from a plc and operators running a line. so far I have this viewable live. I would like save the data captured at the end of the shift into a database. select the data and be able to see what the performance of the machine was on that date, be able to look at the chart an what not.

how would i go about putting this data into such a database?

[TotallyInformation]

There are many options but as this is time-based IoT type data, many of use use InfluxDB for that. You can then use Grafana to build chart dashboards direct from the db.

But rather than trying to hold onto the data until the end of a shift, it is much easier to send it to the db as it arrives in Node-RED.

There is a contributed node to help write data to InfluxDB. Just note that a timeseries db like InfluxDB may look superficially like a SQL DB but it isn't and this can catch people out. Take some time to play with InfluxDB and become a little familiar with its layout and features and work out what structure you want in your data. Once you've got the basics, there are plenty of us on the forum who use it and can help with the tweaks you will eventually want in order to make everything robust.

[tgottie]

awesome, i will give this a try! it is definitely much better to catch it as it arrives. my thought process was so that it would be viewable at later dates!