How to Retrieve Data from SQLite Database and Display it in Table Format on Node-RED Dashboard

[@mircopolo]

Is there a way to close connection to .db file? On Linux I use a file from ftp server mounted as a local file, it reads database nicely but after first read file is not updated if changed by other client. I have to redeploy flow to have it refreshed. Better would be closing the file and opening again but I don''t see such option in the node configuration

[@mircopolo]

Is it possible to edit records? CRUD operations

[@Fusion_Automate]

Yes its possible

[@muhammadan-nasdzikrullahbi9769]

Do i need to install sqlite3 to use the sqlite ?

[@Fusion_Automate]

No no, you can use sqlite3 database directly but to open that database and view the tables and all you can use sqlite db browser software