Guaranteed delivery & MS SQL plus

General
1

Hi all ,
my flow read data from an energy meter and insert it a MS SQL server, it work fine but i want add the Guaranteed delivery to avoid data loss. I tryed to configure i dont understand how i need to configure with MS SSQL plus.
can you help me please?

thanks in advance!

2

You will need to do this yourself. There is nothing built in to the node to queue-up your requests/queries (none of the DB nodes do as far as i know).

What I (and others) do is: Data to be written to the database is stored in a "stack". This stack is simply an array in node-red flow context (backed by file storage to reduce losses due to power outage of node-red)

When there is data in the "stack" I peak the "next" entry in the "stack" & attempt a DB INSERT. If the output of MSSQL-PLUS indicates success, I "shift" the item off the stack.

3

i found this flow Guaranteed delivery of data (upload, email etc) across a network (flow) - Node-RED .. i try with stack

4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.