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

[MakerMan]

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

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 …