Data Logging using node red

[Beno]

@torchard’s advice on making one insert statement is very valid.

Check out this thread for the pitfalls of opening and closing a lot of connections;

groov/Epic Multiple Connection Performance

I’m planning a new application in which a groov or Epic will collect data from multiple (a dozen or more) devices to display on groov View and store in a SQL database. Most of these devices will not be Opto but some may be. I plan on using Node-Red to query the non-Opto devices via TCP messaging and the Opto devices (SNAP-PAC) via RestfulAPI on a regular basis. The flow will then parse the data into a local data store for groov View and will write the data to a SQL database. Has anyone here …