1.6 Forward data to the SQLite database

Now, we can forward the data to the integrated SQLite database.

First the structure for the process data needs to be created in the internal SQLite database. This can be easily done over the port page in the process data section:

After this, the structure can be verified in the integrated SQLite frontend. The frontend can be accessed via the page menu on the left or the „View/edit data“ button at the process data:

In the front end, the data structure is shown as columns:

For the access via Node-RED, the corresponding node needs to be imported:

Copy the contet (as stated in 1.4 1.4 Add device process data to Node-RED) and import it to Node-RED. The result will be a node group from SQLite data, that needs to be directly connected to the „value“ output of the „Write/read process data“ flow:

The SQLite database requires to be confirmed before deploy. Double-click on the „Database“ node and confirm by „Done“:

Hit „Deploy“ and you can view the data in the SQLite frontend. Select „Content“ to view the data:

Well done! Your data is now stored in the internal database for further processing.