Sir, I am doing a code in which user choice I am taking ,So if user wants to refresh it Database just by entering any input that input I am taking on MQTT pub node and then that pub node should trigger my Refresh Function and it should automatically trigger my DB and user gets the updated DB .(So ho…

So you are selecting all the data from the database. Good. I am guessing (because you have not shown us), that you think you can just write the result of the database query straight to a file and expect it to be in the right format. That is not how it works. Look again at the list of 3 steps I de…

So you want something in node red to refresh the view in the database browser?

yes sir, I want this and same should user can do from UI dashboard side

Does the database browser have an API that you can use from node red to tell it to refresh?

no sir,i am using software name db browser for sqlite there no such API option available.

[image] shipra: no such API option available. Well how can node-red tell the database browser to update if there is no api?

I believe that there is no way that node-red can interact with another application such as the database browser if that application does not provide an api to do it. Can you imagine the security implications if a web page or remote server could interact with an application on your PC and tell it to…

So sir any other method can you suggest on this?

Shipra, I am unclear about what you want to do. Do you have two databases and you want to copy the contents of database A and replace the contents of database B? If so you can 1 - backup DB-B 2 - do an export from DB-A 3 - delete all data from DB-B 4 - insert the export from DB-A into DB-B Kno…

yes sir i want to copy my data from a file to B file which is .csv file

Node-RED

Node-RED Forum

How to refresh my sqlite 3 database through node red

General

shipra 21 September 2020 10:19 16

Ok then sir any idea or suggestion how can i do this.

Sir ,I want to copy 2 msg.id in my sql DB

Topic		Replies	Views
Sqlite Database not updated General	12	768	20 May 2024
Implment data base General	4	178	22 November 2023
SQLite Browser based manager General	13	2328	18 June 2020
Nodered and SQLite Integration - Error General function-node	15	274	3 February 2025
Node-RED freezes while sqlite query General sqlite	23	618	17 February 2024

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.

How to refresh my sqlite 3 database through node red

Related topics