{"library":"node-red-node-sqlite","type":"library","category":null,"description":"Node-RED node for local SQLite database read/write operations. Current stable version is 2.0.1, released as part of the node-red-nodes collection. The package wraps the better-sqlite3 library (v2+) or sqlite3 (v1) to provide SQL query execution with support for prepared statements, parameterized queries, batch execution, SQLite extensions, and configurable reconnect timeouts. Install via npm in the Node-RED user directory with --unsafe-perm flag. Version 2.x introduces a breaking change requiring native binary rebuild on some platforms. Allows SQL injection when using raw queries via msg.topic, but prepared statements mitigate this.","language":"javascript","status":"active","version":"2.0.1","tags":["javascript","node-red","sqlite"],"install":[{"cmd":"npm install node-red-node-sqlite","imports":["nodes are loaded automatically by Node-RED after npm install; no manual import required","configure via Node-RED editor under 'storage' category","set msg.topic to SQL query string, msg.payload for parameters"]},{"cmd":"yarn add node-red-node-sqlite","imports":[]},{"cmd":"pnpm add node-red-node-sqlite","imports":[]}],"homepage":"https://nodered.org","github":"https://github.com/node-red/node-red-nodes","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/node-red-node-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/node-red-node-sqlite/compatibility"},"provenance":{"verified_status":null,"verified_at":null,"last_verified":"Wed Jun 17","next_check":"Fri Jul 24","install_tag":null}}