Concurrency: Writing to database

[eugene]

Node-red fundamental question.

I have a flow that writes input payload to a database (same table).

The input payload comes from 5 sources, the time is depending on some external event.

Do I need to worry for lost of data, if two input payload arrived at the "write database flow"?
How about if 5 input payload arrives at the same time? or 20?

Can I be confident that node-red "write database flow", will execute each of the concurrent message?

[knolleary]

@eugene

Can I be confident that node-red "write database flow", will execute each of the concurrent message?

Node-RED doesn't drop messages.

Whether the particular database node has some internal limitation as to how many concurrent requests it can handle, or whether it queues things up, will depend on the specifics of the node.