# Which database to choose for storing data (noob-friendly)

**URL:** https://discourse.nodered.org/t/which-database-to-choose-for-storing-data-noob-friendly/64073
**Category:** Industrial
**Created:** [17 June 2022 11:18 UTC](https://discourse.nodered.org/t/which-database-to-choose-for-storing-data-noob-friendly/64073 "2022-06-17T11:18:55Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![MakerMan](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@MakerMan](https://discourse.nodered.org/u/MakerMan)
#### Post date: [19 June 2022 14:55 UTC](https://discourse.nodered.org/t/which-database-to-choose-for-storing-data-noob-friendly/64073/3 "2022-06-19T14:55:04Z")

</div>

I use node-red to receive data from mosquito and write this data to a sqlite database. The data are time series based, and if I was starting this again, I'd probably look at influx rather than sqlite, based on Influx being better suited.  
But sqlite works for me and currently I have no reason to change.

The discussion here may be useful ...

> [@Sqlite Vs InfluxDB & Grafana](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/6):
>
> InfluxDB is not only better integrated to Graphana but is also much better suited to capturing and processing time series data. Handles timestamped data natively Allows summary/aggregated data to be calculated & saved automatically - for example, I keep my detailed sensor data (at ~1 minute intervals) for 7 days but all the data is automatically aggregated to hourly data (avg, max & min) and kept indefinitely. InfluxDB does all of this itself. Native integration to Graphana. The disadvantage …

---

_[View the full topic](https://discourse.nodered.org/t/which-database-to-choose-for-storing-data-noob-friendly/64073)._