In this recipie we are going to add a SQL Database to the app, then using it to save some data.

Step1: Adding the Database

First you ned to add a sql database as a servise to your app.
bilde3
Select the IBM SQL database.
Give it a name then press create.

Step2: Configuring the Database

Now you ned to configure your database. Navigate to the dashboard and under services, press your SQL database.bilde4
Launch it, and a new tab wil pop up. Select work with tables.
Press the pluss sign marked in the picture bellow to create a new table.
bilde5
Now write the necessary sql, then click run DDL.

Step3: Running the app

Then we can go back to the Node-RED editor. In this app the messages recieved are a json object, so we need to transfer it into this format.
bilde6
This can be done by adding a json node. Then we can add a SQL database node, and connect it to the json node. Press the sql node and select witch database and table you want to save to.
Now the app is ready to be deployed.

Leave a Reply