# Nodered to sqlite to grafana help

**URL:** <https://discourse.nodered.org/t/nodered-to-sqlite-to-grafana-help/44635>\
**Category:** General\
**Created:** [23 April 2021 21:01 UTC](https://discourse.nodered.org/t/nodered-to-sqlite-to-grafana-help/44635 "2021-04-23T21:01:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![biros](https://avatars.discourse-cdn.com/v4/letter/b/e47c2d/32.png) [@biros](https://discourse.nodered.org/u/biros)\
**Post date:** [23 April 2021 21:01 UTC](https://discourse.nodered.org/t/nodered-to-sqlite-to-grafana-help/44635/1 "2021-04-23T21:01:28Z")

</div>

Hello again,  
Does anybody use the sqlite+grafana combo? (influxdb is too complicated for me).  
My time series column is TEXT datatype with “YYYY-MM-DDTHH:MM:SS” (tried different formats, without the "T" too).  
Yet when I set "datetimestamp" to be recognized as a time series column, the values disappear.  
When I leave it like that, i can see the values in the query table but no chart is drawn in both cases.  
I know it's not the most node-red-ish issue, help please.  
I was doing the same thing with node-red \> csv \> smb \> grafana (different linux pc) and it worked flawlessly. I assume I don't have the right knowledge about the perfect sql query syntax for my case.

As timeseries;

 ![image (1)](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/d/4d2d418225ad8dbc4aab97b096716a7474500903.png)

No timeseries;

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/7/07ff6e895af7b85b411d1c66d733e6ef23ee91cd.png)

Thank you kindly for any advice.

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [23 April 2021 23:39 UTC](https://discourse.nodered.org/t/nodered-to-sqlite-to-grafana-help/44635/2 "2021-04-23T23:39:57Z")

</div>

Hi,  
I don't have any experience with sqlite in combination with grafana so no ready to run solution from me 😉  
Have a look at this [SQLite plugin for Grafana | Grafana Labs](https://grafana.com/grafana/plugins/frser-sqlite-datasource/) and then in particular the paragraph about _Support for Time Formatted Columns_  
With the provided example you should get it working.

---

<div class="post-metadata">

**Author:** ![biros](https://avatars.discourse-cdn.com/v4/letter/b/e47c2d/32.png) [@biros](https://discourse.nodered.org/u/biros)\
**Post date:** [24 April 2021 08:22 UTC](https://discourse.nodered.org/t/nodered-to-sqlite-to-grafana-help/44635/3 "2021-04-24T08:22:29Z")

</div>

Cheers mate, the "Z" was missing from the format's end.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [23 June 2021 08:22 UTC](https://discourse.nodered.org/t/nodered-to-sqlite-to-grafana-help/44635/4 "2021-06-23T08:22:46Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.