Passing database command in the topic risks a SQL injection as the payload isn’t sanitised unless you do it. An alternative and somewhat easier method is to use a prepared statement. Click to rate this post! [Total: 0 Average: 0]
Continue readingAuthor: steve
Filtering MQTT Topics (commands and Responses) in Node-Red
Many MQTT topics have control structure, for example, to turn a Tasmota switch on/off you use a topic with an embedded command and value e.g house/main-light/command/power/on Click to rate this post! [Total: 0 Average: 0]
Continue readingUsing Subflows and Groups in Node-Red
A subflow is a collection of nodes that appear as a single node in the workspace. They also appear in the node palette and can be added to a flow like any other node. They are effectively reusable groups of nodes much like sub routines in traditionally programs. Any changes to the subflow are effective immediately in all flows using that subflow Click to rate this post! [Total: 0 Average: 0]
Continue readingNode-Red and JSONata for Beginners
JSONata is a lightweight query and transformation language for JSON data and allows queries to be carried out directly on JSON data. —ref The alternative,and the one I most often use is to convert JSON to JavaScipt and then query it using JavasScript functions. Click to rate this post! [Total: 0 Average: 0]
Continue readingFunction Node Programming-Loops,Arrays and objects
Using Loops There are several loops available – for,while, do while. Loops let you repeat an action. By far the most common one is the for loop. The general format is: for (begin; condition; step) { // … loop body … } Click to rate this post! [Total: 0 Average: 0]
Continue readingUsing For Loops-Node-red Function Node Programming
Loops let you repeat an action. There are several loops available they are for,while, do while. By far the most common one is the for loop. The general format is: for (begin; condition; step) { // … loop body … } Click to rate this post! [Total: 1 Average: 5]
Continue readingUsing The Table DashBoard UI Widget Node
The table dashboard ui widget node is used to add tabular data to a dashboard. The node is based on the tabulator module which you can read about here and see examples here. Click to rate this post! [Total: 0 Average: 0]
Continue readingUsing the Node-Red Email Node
The node-red email node most commonly used is the node-red-node-email which consists of three nodes. A send node receive node MTA (transfer node) Click to rate this post! [Total: 0 Average: 0]
Continue readingEncrypting and Decrypting MQTT Message Payloads
Most MQTT implementations use SSL by default for data security. However SSL is a link encryption method and doesn’t secure the payload end to end unless SSL is applied to all links. In addition if the data is stored at the destination it will be unencrypted unless it is encrypted before storage. Click to rate this post! [Total: 0 Average: 0]
Continue readingStoring and Retrieving JSON Data In SQLite
It has always been possible to store JSON Data in an SQLite database as JSON data is simply text data. However what was not previously possible was how to query this JSON data using a key. This changed in version 3.9 in 2015 (SQLite history) and so there is now no need to separate out the JSON data so that you can query using a key. . Click to rate this post! [Total: 4 Average: 4]
Continue reading