# Advice please! | store data to file or database

**URL:** https://discourse.nodered.org/t/advice-please-store-data-to-file-or-database/37797
**Category:** General
**Created:** [20 December 2020 14:07 UTC](https://discourse.nodered.org/t/advice-please-store-data-to-file-or-database/37797 "2020-12-20T14:07:26Z")
**Posts on this page:** 1
**Showing post:** 3

<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: [20 December 2020 14:46 UTC](https://discourse.nodered.org/t/advice-please-store-data-to-file-or-database/37797/3 "2020-12-20T14:46:23Z")

</div>

Agree with Colin that InfluxDB is your best bet. Watch out for the not quite SQL syntax though, it does tend to catch people out.

Have a look at the following answer I gave to a question which should help you with the terminology and structures that you probably want.

[Need more detailed information on influxdb - General - Node-RED Forum](https://discourse.nodered.org/t/need-more-detailed-information-on-influxdb/36885/5)

You should also look at Grafana which is a great way to produce excellent dashboards and charts from InfluxDB data.

---

_[View the full topic](https://discourse.nodered.org/t/advice-please-store-data-to-file-or-database/37797)._