I am using HomeAssistant for over a year now. It is my platform to connect my KNX installation, my Hue lamps, SONOS, iOS and my heat pump.
Especially for my heatpump I want so save some entity statistics for a longer time (several Years) to make year by year comparisons.
Currently I am using the integrated SQLite DB with standard settings. The Purge time seems to be 10 days, because my APEX Charts end there after rebooting the system. HA is running on a RPI4, all data is stored on SD Card.
It would be possible to move the system to a NAS or at least the DB. But for me the current configuration seams to be the easiest way to run HA.
So what is your advice to store statistics of special entities for several years and visualize them via APEX charts within HA?