node-red-node-sqlite
Advanced tools
A Node-Red node to read and write a local sqlite database.
Run the following command in the root directory of your Node-RED install
npm install node-red-node-sqlite
Allows basic access to a Sqlite database.
This node uses the db.all operation against the configured database. This does allow INSERTS, UPDATES and DELETES.
By it's very nature it is SQL injection... so be careful out there...
msg.topic must hold the query for the database, and the result is returned in msg.payload.
Typically the returned payload will be an array of the result rows, (or an error).
The reconnect timeout in milliseconds can be changed by adding a line to settings.js
sqliteReconnectTime: 20000,
FAQs
A sqlite node for Node-RED
The npm package node-red-node-sqlite receives a total of 804 weekly downloads. As such, node-red-node-sqlite popularity was classified as not popular.
We found that node-red-node-sqlite demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
require(esm) backported to Node.js 20, easing the transition to ESM-only packages and reducing complexity for developers as Node 18 nears end-of-life.
Security News
PyPI now supports iOS and Android wheels, making it easier for Python developers to distribute mobile packages.
Security News
Create React App is officially deprecated due to React 19 issues and lack of maintenance—developers should switch to Vite or other modern alternatives.