LoRa/LoRaWAN tutorial 27: Retrieve and Store Sensor Data From The Things Network

If you like this video and want to support me, go this page for my donation Paypal or crypto addresses:

This is part 27 of the LoRa/LoRaWAN tutorial.

In this video series different topics will be explained which will help you to understand LoRa/LoRaWAN.
It is recommended to watch each video sequentially as I may refer to certain LoRa/LoRaWAN topics explained earlier.

In this tutorial I will demonstrate:
- how to retrieve sensor data from The Things Network,
- how to store it in a database,
- how to retrieve this data from the database and display it in a browser,
- and how to create a downlink, using a NodeJS script, sending data from my computer to my LoRa end node.

All code used in this tutorial can be found in the following Github repository:

The Things Network community developers created several Software Development Kits (SDK) to receive activations and messages from IoT devices via The Things Network to your server.
It also allows you to send messages back to the IoT devices from your server.
The SDK’s are available in Go, Java, Python and Node.JS

In this tutorial I will use the Node.JS SDK.

This tutorial assumes you have installed the following software packages and know how these packages works.
Node.JS (JavaScript server environment) and npm (node package manager)

MySQL (Relational Database Management System)In this tutorial MySQL Community Server is used.

phpMyAdmin (Web based administration tool for MySQL)

Goto The Things Network console.
Goto the applications page and select the application which receives the sensor data.
In this demo the application ID is "youtube_demo_app2".

To retrieve sensor data from The Things Network to your server, you need:
The application ID
Example: youtube_demo_app2
Access key

Download the Git repository:
Goto folder ttn_app_server
Install the node modules, type: npm install

This script only retrieves sensor data from TTN and displays it in the terminal.

Depending on the hex value send, the yellow and green leds can be On or Off.

The retrieved sensor data from TTN can be stored in a MySQL database.
A database and corresponding table needs to be created.
Use the web application phpMyAdmin, to check if the database and table are created.

The column "payload_raw" has data type tinyblob to store binary data.
The payload_fields data is not stored because the payload_raw data can be used to recreate the payload_fields data.

The Arduino sketch transmits the humidity and temperature data as four bytes.
If the button switch is pressed a single byte is transmitted.

Use the web application phpMyAdmin, to check if sensor data are stored.

The sensor data is stored in the table sensor_data.

The sensor data is stored in the table sensor_data.
To display all records from table sensor_data in a browser:
Open a browser and open the PHP file.

BE CAREFUL, ONCE DELETED ALL DATA IS LOST.

Check out all my other LoRa/LoRaWAN tutorial videos:

Subscribe to my YouTube channel:

The presentation used in this video tutorial can be found at:

#mobilefish #lora #lorawan

[danymerhej]

Dear Robert, thank you for this tutorial. I managed to get it working without any problem on TTN V2. What are the modifications in order to use it with TTN V3?

[trendyprimawijaya]

Thank you so much. It is helpful. It help me so much.

[henrisors]

Robert, thanks a lot for your tutorials. They are really high quality. I am impressed ! Quick question regarding this video: I am interested only by the "send downlink" portion of your tutorial. Do you believe the same code would work with TTNV3 ?. Thanks.

[tumelotux]

Is it possible to directly retrieve data from things network using web sockets and visual studio? I need to utilise my sensor data in visual studio.

[cute_pet_videos]

Hi. Thanks for this valuable tutotial content. Is there a way to know the amount data sent out and compliance to fair usage policy by measuring the usage instead of calculating it ?

[mos]

Hallo, Sometimes when i send data ( downlink) the data doesn't achieve the nodes from first time, so i need to send data many times then nodes get the data . can u tell me please what the factors which have effect on downlink .
I use same ur hardwares and same library and i'm from same Holland :).
thanks in advace

[vinodselvaraj]

What kind of sensor can be used with lora and lorawan

[alawrence]

Where can anyone find the access_key? It has dissapeared from the dashboard

[aghamaretha]

Can you help me? I got
Error: Cannot find module 'ttn'
at
when I'm trying to run node retrieve.js
Thankyou

[Ohayou]

How to save data from lora node(arduino) to lora gateways(raspberry pi) on database 😭🙏