Save payload in sqlite data base

#1

Hi all,

i'm very new in node red.
I'd like to save a payload with weather data in a sql data base.
can anybody help me to understand what i have to do?

thanks in advance

FK

Summary

This text will be hidden

0 Likes

#2

Hi @fiberkill

Have you installed the sqlite nodes? Essentially you have to create a message containing the SQL query you want to run - in this case an sql INSERT statement. There are lots of threads in this forum around inserting data into databases. The best place to start would be to search the forum for those threads and see if they help you understand what you need to do.

0 Likes

#3

And if you are new to SQLite, you could probably benefit from a tutorial like http://www.sqlitetutorial.net/

0 Likes

#4

Hi,
i managed it to insert my values into sqlite data base.
It was realy easy.

Thanks for your help

fk

0 Likes

#5

If it's time based numeric data you want to store then InfluxDB is a better choice. If you want to graph it, take a look at Grafana which works with a number of data sources like InfluxDB.

0 Likes