# 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:** 8
**Page:** 1
### Author:  [@JoseGodinho](https://discourse.nodered.org/u/JoseGodinho)
#### Post date: [2 August 2018 15:23 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/1 "2018-08-02T15:23:44Z")
Hello All
I have implemented SQLite in my project, using the excellent examples from Csongor Varga
My question is this is most effective way to record time series?
A drawback from sqlite is the connection to grafana, is there any way around this?
Thank you
José Godinho
---
### Author:  [@ghayne](https://discourse.nodered.org/u/ghayne)
#### Post date: [2 August 2018 15:27 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/2 "2018-08-02T15:27:45Z")
There is no datasource for SQLite in Grafana. I am testing a MySQL database in parallel with InfluxDB which is working very well if you don't want to use InfluxDB, which is probably the best choice for time series.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [2 August 2018 15:54 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/3 "2018-08-02T15:54:38Z")
+1 for influxdb. @JoseGodinho why don't you want to use influx?
---
### Author:  [@JoseGodinho](https://discourse.nodered.org/u/JoseGodinho)
#### Post date: [2 August 2018 15:56 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/4 "2018-08-02T15:56:38Z")
it not a question of don´t want to use!
I just would like to know if it makes sense to change..
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [2 August 2018 16:06 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/5 "2018-08-02T16:06:26Z")
> [@JoseGodinho](#):
>
> it not a question of don´t want to use!
> I just would like to know if it makes sense to change..
If you want to use Grafana then yes.
---
### Author:  [@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")
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.
---
### Author:  [@Backup](https://discourse.nodered.org/u/Backup)
#### Post date: [2 August 2018 22:52 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/7 "2018-08-02T22:52:05Z")
I have influxdb and grafana running on a Raspberry Pi3 and they're well suited. I rarely use more than 3% cpu power and grafana is very quick to upload and display a months worth of data.
Both are now available from the repository which makes them ultra easy to install.
I've used both MySQL and SQLite and both are excellent but influxdb is not only ultra easy to install and very little setup required.
+1 for influxdb & grafana
PS: if you are used to relational database time series dbs are a different animal and will require a little learning curve.
---
### Author:  [@JoseGodinho](https://discourse.nodered.org/u/JoseGodinho)
#### Post date: [3 August 2018 13:41 UTC](https://discourse.nodered.org/t/sqlite-vs-influxdb-grafana/2009/8 "2018-08-03T13:41:58Z")
Thank you all for the useful tips