Hi there ! I wanna store the temperature measurement and the time when the measurement was done; actually works fine on my flow (I've a UI to display the table, I made it using dashboard), the problem is I don't know where the sqlite node save the data base file, I can't find it ... I tried using t…

@kharlos04 I ran into the same issues - plenty of Linux tutorials... that don't seem to work under Windows. Here is the solution that I found: https://github.com/mpolinowski/nodered-sqlite Mostly a best-of from the tutorials - but verified to work under Windows 10. TL;DR 1.) Install SQLite 2.) …

what are the node configuration options?

OK so the sqlite node will save to the sqlite database that you must have installed separately.

Well, that's a problem, I've not installed sqlite database separately ... I searched in google and found this tutorial: http://noderedguide.com/tutorial-sqlite-and-node-red/ ... Never say that I must install database separately; nevertheless, when start node-red in windows PowerShell show this: […

Please, could you explain me how its works?

Absolutely no idea! My experience is primarily based on these tutorials for the Raspberry Pi. http://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/ Which starts off by stating "Install SQLlite"

[image] kharlos04: Please, could you explain me how its works? Not sure what you mean by that. It seems that it is working (other than, obviously, the flow is trying to create a table that has already been created once.

I have no problem with the flow, works OK ... I wanna know where the sqlite node saves (in my windows PC ) the database called "sqlite" ... in previous replies I posted the setting sqlite node ( Node-RED SQLITE stores Data Base on windows ) In this reply: Node-RED SQLITE stores Data Base on windows …

Well, this example was usefull: https://medium.com/@supotsaeea/node-red-sqlite-d78a57ec4561 I assumed that the database file made by sqlite node will be save in C:\Users_username_.node-red ... I was wrong, I don't know where is

I don't use windows but presumably there is a search program that you could use to find it. However in Linux you can specify a full path to the file, so presumably you can do that in windows too.

Node-RED

Node-RED Forum

Node-RED SQLITE stores Data Base on windows

General

kharlos04 7 July 2018 23:11 4

thanks ukmoose...

Topic		Replies	Views
Sqlite database location node-red General	1	877	23 October 2020
Running node-red in a docker container with sqlite3 General database , docker	5	906	13 July 2022
Nodered and SQLite Integration - Error General function-node	15	299	3 February 2025
Implment data base General	4	183	22 November 2023
Sqlite Database General database	3	350	6 October 2022

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.

Node-RED SQLITE stores Data Base on windows

Related topics