B Clifford (Customer) asked a question.
I need help to install the “node-red-node-sqlite” node.
I must have my link to the Internet OK because I was able to install the “node-red-contrib-mssql” node.
I would prefer the “node-red-node-sqlite” node .
It will not load successfully.
I have attached the error log files for both 1.1.0 & 1.1.1 version installs.
Plain Text Error log from node-red-node-sqlite ver 1.1.0 and 1.1.1
B Clifford - "node-red-node-sqlite v1.1.0" comes pre-installed on a C2-NRED. See page 20 of the CLICK Plus Applications guide
TY. It is not there and a reinstall failed again after I removed a non-functioning node of some sort.
How do I reinstall it?
Here is the most recent Event Log:
2025-10-13T19:03:58.968Z Install : node-red-node-sqlite-1.1.0.tgz
2025-10-13T19:03:57.524Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict /usr/local/nred/.node-red/nodes/node-red-node-sqlite-1.1.0.tgz
2025-10-13T19:04:37.714Z [err] npm
2025-10-13T19:04:37.723Z [err]
2025-10-13T19:04:37.725Z [err] WARN
2025-10-13T19:04:37.726Z [err]
2025-10-13T19:04:37.728Z [err] deprecated
2025-10-13T19:04:37.729Z [err] npmlog@6.0.2: This package is no longer supported.
2025-10-13T19:04:37.840Z [err] npm
2025-10-13T19:04:37.850Z [err]
2025-10-13T19:04:37.852Z [err] WARN
2025-10-13T19:04:37.859Z [err]
2025-10-13T19:04:37.860Z [err] deprecated
2025-10-13T19:04:37.861Z [err] rimraf@3.0.2: Rimraf versions prior to v4 are no longer supported
2025-10-13T19:04:37.941Z [err] npm
2025-10-13T19:04:37.942Z [err]
2025-10-13T19:04:37.943Z [err] WARN
2025-10-13T19:04:37.944Z [err]
2025-10-13T19:04:37.945Z [err] deprecated
2025-10-13T19:04:37.946Z [err] glob@7.2.3: Glob versions prior to v9 are no longer supported
2025-10-13T19:04:39.451Z [err] npm
2025-10-13T19:04:39.453Z [err]
2025-10-13T19:04:39.454Z [err] WARN
2025-10-13T19:04:39.455Z [err]
2025-10-13T19:04:39.455Z [err] deprecated
2025-10-13T19:04:39.456Z [err] inflight@1.0.6: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and tested way to coalesce async requests by a key value, which is much more comprehensive and powerful.
2025-10-13T19:04:49.845Z [err] npm
2025-10-13T19:04:49.846Z [err]
2025-10-13T19:04:49.847Z [err] WARN
2025-10-13T19:04:49.848Z [err]
2025-10-13T19:04:49.849Z [err] deprecated
2025-10-13T19:04:49.850Z [err] @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs
2025-10-13T19:04:57.157Z [err] npm
2025-10-13T19:04:57.158Z [err]
2025-10-13T19:04:57.159Z [err] WARN
2025-10-13T19:04:57.160Z [err]
2025-10-13T19:04:57.161Z [err] deprecated
2025-10-13T19:04:57.163Z [err] are-we-there-yet@3.0.1: This package is no longer supported.
2025-10-13T19:04:57.178Z [err] npm
2025-10-13T19:04:57.179Z [err]
2025-10-13T19:04:57.182Z [err] WARN
2025-10-13T19:04:57.183Z [err]
2025-10-13T19:04:57.184Z [err] deprecated
2025-10-13T19:04:57.185Z [err] gauge@4.0.4: This package is no longer supported.
2025-10-13T19:05:49.097Z [out]
2025-10-13T19:05:49.097Z [out] > sqlite3@5.1.7 install /usr/local/nred/.node-red/node_modules/sqlite3
2025-10-13T19:05:49.097Z [out] > prebuild-install -r napi || node-gyp rebuild
2025-10-13T19:05:49.097Z [out]
2025-10-13T19:06:09.467Z [err] prebuild-install warn install No prebuilt binaries found (target=6 runtime=napi arch=arm libc= platform=linux)
Will restoring it to factory default bring it back?
Let me test that for you. I will let you know in a few minutes
Yes you can get the original nodes re-installed by forcing the update of the Firmware by unchecking the "Skip updating with the same version" button. I just tested this after uninstalling the SQLite node. Hope this helps
The reinstall of the NRED worked and I have SL back in place. Thank you very much for your help.
Now that this node is back, I am needing another bit of insight and help.
Rather than saving my DB locally on the N-RED module of within the SD card, I want to save my DB on a PC that is running on the same network.
Can you offer any tips on this task?
What are your thoughts on using a postres DB?
My primary concern is getting the DB out of my PLC cabinet and into a PC for date retrieval, backups and off-site storage.
Thank you-
Unfortunately, SQLite doesn't support TCP connections to write across a network, nor does it support file writes between Linux and Windows. For your application, we recommend using a DB like MS-SQL or MS-SQL Express. You can also use Azure SQL if you don't want to deal with installing a DB. In my experience though, SQL Express is a pretty simple install and its free up to 10GB of data.
We have tested with the node-red-contrib-mssql-plus-box-0.1.4 node and it worked for all of the standard Create, Insert, Update, delete queries we tested. node-red-contrib-mssql-plus-box (node) - Node-RED
You can check out an example project in the applications guide starting on page 15:
CLICK PLUS Applications Guide (C2-APP-GUIDE)
This was written for Azure, but the only difference is the connection string which includes the IP address of the DB server. Page 20 has a short summary of some of the pros and cons of using a remote DB vs onboard SQLite.
Is it possible to use a node that supports postgresq, such as node-red-contrib-postgresql?
It is likely possible. I have no experience with Postgresql, but based on the doc, it supports TCP/IP connections, so it should work. You can use the Node-RED compatibility checker to get a good version to work with the C2-NRED module and generate a link to download the library. It's always a good idea to backup the nodes you install - they change all the time.
C2-NRED Package Compatibility Finder