# Save payload in sqlite data base

**URL:** <https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163>\
**Category:** General\
**Created:** [23 January 2019 09:46 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163 "2019-01-23T09:46:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![fiberkill](https://avatars.discourse-cdn.com/v4/letter/f/ecccb3/32.png) [@fiberkill](https://discourse.nodered.org/u/fiberkill)\
**Post date:** [23 January 2019 09:46 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163/1 "2019-01-23T09:46:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [23 January 2019 09:55 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163/2 "2019-01-23T09:55:23Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [23 January 2019 11:16 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163/3 "2019-01-23T11:16:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![fiberkill](https://avatars.discourse-cdn.com/v4/letter/f/ecccb3/32.png) [@fiberkill](https://discourse.nodered.org/u/fiberkill)\
**Post date:** [30 January 2019 08:56 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163/4 "2019-01-30T08:56:10Z")

</div>

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

Thanks for your help

fk

---

<div class="post-metadata">

**Author:** ![Robbo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/robbo/32/4491_2.png) [@Robbo](https://discourse.nodered.org/u/Robbo)\
**Post date:** [30 January 2019 09:05 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163/5 "2019-01-30T09:05:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mk0523](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mk0523/32/16332_2.png) [@mk0523](https://discourse.nodered.org/u/mk0523)\
**Post date:** [14 January 2020 23:36 UTC](https://discourse.nodered.org/t/save-payload-in-sqlite-data-base/7163/6 "2020-01-14T23:36:06Z")

</div>

Hi, could you please post the flow of how you did it. I am trying to store data but I can't