Smart recorder / history

In the early days I used to use Domoticz but switched to a combination of node-red and influxdb and grafana as I found the automation system in Domoticz lacking. I am now using Home Assistant full time but what I really miss about Domoticz is its way of agregating historic data.

Domoticz would discard data older than X days but then keep min, max and mean temperature for each day. I cannot remember if it pruned data further down but my point is it would be great if the recorder component could save data in a similar way so that I could keep a longer history.

It would also be great if I could then compare with historic data e.g. this february is x degrees colder than last year or similar :slight_smile:
February had x days with frost this year compared to x days last year and so on

You can do this already with e.g. the history_stats integration or similar things.

I use one DB (PostgreSQL) for short term data and one DB (influxDB) for long term data with Home Assistant, as described here. Works perfectly fine and results in small databases.

That seems great. Then I guess I am mostly looking for a solution of comparing current values with historic values in graph form. But maybe I have to include grafana or similar in order to achieve this :slight_smile:

Grafana is definitely a good fit, you can also show grafana charts in Home Assistant.