# Sqlite Vs InfluxDB & Grafana

**URL:** https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009
**Category:** General
**Created:** [2 August 2018 15:23 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009 "2018-08-02T15:23:44Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [2 August 2018 16:48 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/6 "2018-08-02T16:48:22Z")

</div>

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 is that you have to learn something that you will initially find a little more complex than standard SQL to begin with.

---

_[View the full topic](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009)._