Skip to content

Creating the espore databases

Definition

So we are going to create the influxDB database structure for our data. The structure will look as follows:
devices_raw_data [DATABASE]
data [MEASUREMENT]
payload (format will depend on the device)
tags
devEUI
metadata [MEASUREMENT]
payload [FIELD]
rssi
snr
tags
devEUI
gwEUI

Creating the database

We will need to run the following command to enter InfluxDB configuration to create the database
influx
image.png
and then type:
CREATE DATABASE devices_raw_data
we can check the database has been created with
SHOW DATABASES
image.png
Measurements and data will be insert from Nodered as it is received (check )
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.