Hello everyone, I want insert data upto only some points (for example only entry 500 datapoints) in sqlite or sql database, and then data insertion will stop automatticaly. Is there any such node library available, or any other solution to develop? can anyone help me how to develop?

Have you searched the flows library. There are both MSSQL and sqlite nodes. I can't vouch for sqlite nodes but I know node-red-contrib-mssql-plus works very well. The read me has info to help.

How long of a time will it be till you hit the limit? How will you detrermint the time limit? Fixed? Vaariable? How you you determine the number of rows to create? Will this be restarted at some time (like, insert 300 points in a half hour then start inserting 300 more in the next haclf hour...etc) …

Thanks for quick reply. There is no time limit for datalogging. I will elaborate in details for better understanding. I am developing the logic for connecting my IoT device to the cloud. If internet connection is disabled then it buffer data in local sql database(like 300 points then it has to be s…

So a datum comes in you try to send to cloud it succeeds, then you check to see if you have stored data if so loop thru sending it to the cloud, deleting each datum after is is sent it fails store the data in the database of buffer - set flag saying there is stored data. that seem…

Hi, Is there any similar kind of solution is available, can you share me link or flows?

I don't have a flow, but I gave you the basis of a flow. Did you try to create it? If not, why not? if you did and are having problems, let us know and i'll will be happy to guide you to a solution.

Node-RED

Node-RED Forum

Insert data in sqlite or mssql

General

Steve-Mcl 8 May 2020 07:55 5

I understand and do exactly the same thing except I don't use a database. I use this.

Topic		Replies	Views
Save payload in sqlite data base General	5	697	14 January 2020
I want to fetch data from sqlite in batches after certain interval of time General database , function-node , mqtt	10	260	6 March 2023
How to insert lots of data with a single message in sqlite General	6	1785	22 October 2018
Nodered and SQLite Integration - Error General function-node	15	265	3 February 2025
Function to create data and insert into column of existing sqlite DB General database	7	368	6 January 2023

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Insert data in sqlite or mssql

Related topics