I made a copy of the /home/dev/.node-red/node-modules directory, then restored my unit, copied that directory in, restarted Node-Red, and voila there were my modules in the palette. And maybe, just maybe include the Opto PAC/Groov Nodes by default. But guys… Opto22 Support, please check this out and see if you can come up with a solution.
I am sure Opto22 support won’t either, as this is using SSH. So to put it simply: you want a wrapper around the node-red-node-sqlite that besides doing what it usually does, it also outputs a message (or extends the outputted message) with the following information: action delete/insert/update rowid inserted or updated row data.
NODE RED SQLITE INSTALL
x) to successful install sqlite-3 with npm install sqlite3 but no way, I get always. When using a prepared statement to data is passed in the msg.params object and the command is created in the node.
An alternative and somewhat easier method is to use a prepared statement. Passing database command in the topic risks a SQL injection as the payload isn’t sanitised unless you do it. I don’t support any accidents or screwups. I can connect with an external browser to Node-RED and everything looks. Node-Red SQlite- Using a Prepared Statement. (It will ask for your admin password, type it in and continue)Ĥ)Type or Copy/Paste: cd /home/dev/.node-red/ĥ)Type or Copy/Paste: sudo npm install sqliteĨ)Once the status is stopped, click ENABLEĩ)Wait for about 10-15 seconds, then click on “Open Node-Red Editor”
1 a) Install sqlite using pallette, then either reboot or goto step 6, then come back to this after step 9ī) Using winscp (there are other ways to upload, this the way I am doing it at this time) copy node_sqlite3.node to your user directoryģ)Type or Copy/Paste: sudo cp node_sqlite3.node /home/dev/.node-red/node_modules/sqlite3/lib/binding/node-v48-linux-arm/.
0 kommentar(er)
