Is there an easy way for me to keep the “History” ( /history ) data for like 2 or 3 years? I like the data the exact way it’s recorded, I like the UI exactly how it is, I just want to keep it for a long time. If there are CPU, RAM, or storage requirements I’m happy to oblige (just as long as I know what they are).
I’ve got something just under 100 smart devices in my home. I’m currently running a Synology DS1515+ (Intel Atom C2538 4core x 4thread Avoton) using a virtualized image of HAOS. I think my box has 8gb of RAM but I could be wrong (and that’s trivial to upgrade).
You can theoretically keep your history for as long as you want so long as you have the hard drive space for it. There are probably CPU and memory implications as well, but I’m unaware of what they may be. One thing, though, is that a large database has other downsides. I set mine up for just a year and my backups were taking a very long time, so doing an update was very painful. In time I also noticed that I couldn’t generally just restart HA, I had to restart the entire host computer because, and I think this was due to having a 9GB database, the system couldn’t connect to the database unless I restarted the host.
These are just my experiences with trying to keep history and I ended up shrinking my database nearly tenfold and using InfluxDB for my long term history (and still figuring out how to get the most out of it). My system performance has gone up substantially and I run my HA on a virtual machine with quite a few resources.
What’s InfluxDB? Obviously I’ll go google that but I haven’t run across it yet.
Also do you happen to have the right pointers handy so that I could go look at the size of my DB? Maybe it’s an SQLite file somewhere in my VM or whatever? I’m perfectly happy poking around and the only missing part for me right now is internals of how HA works.