How stable and good is the database these days? Has it developed for the better over the years or is it the same as when HA was founded? In the past, there was a lot of talk about needing to switch to another DB, such as Maria, when your DB started to grow in size. I get a few different arguments and answers when I google, some say that these days, sql lite in HA is so good and updated and stable that it is not necessary to switch to another. I run my HA on a minipc in linux and have really good performance. Is it only the performance that you notice when the DB starts to get too big? Or is there a risk that the file will become corrupt? I also run on M.2 nvme so no risk of fragmentation. How big can the sqllite db become without risks? Or is it just possible to continue without switching to, for example, Mariadb as long as its performance is good? My db increases by about 100mb / day and is currently at 28gb
For comparison my 5 year old db is 1,6GB.
I’ve had Maria database for quite a while for this very reason (original crashed frequently). But some year or so ago HA team totally revamped sqlite, so now i’m back on built-in db for over a year now and so far i didn’t have a single problem (like before).
I am using the HA standard SQlite and are up to about 15 GB.
Never had a problem with it and doesn’t seem to slow down HA at all?
I keep a lot of my data for 13 months after that it gets purged.
I guess it also depends on your hard- and software setup.
I run my HA in a VM under Windows 11 - but the PC I run it on is reasonably fast.
28GB does seem a bit excessive and means it’s storing at least 9 months’ worth of data.
If you set your recorder to store more than the default 10 days in the past, you really shouldn’t need to any longer. HA now has Long-Term Statistics, so provided the entities you’re interested in are correctly defined, their history will be aggregated & stored forever.
I’d be asking myself: How much of that 28G am I really ever going to use?
I am a bit of a pack-rat when it comes to saving data, but frankly a large percentage of what HA stores by default is never going to be needed. Storage is cheap and maybe the system can handle it. But even I draw the line somewhere. I like lean and efficient systems, and spending the time to weed out the entities which spam the database with useless information is a worthwhile endeavor.
Agreed. Still don’t understand why some weather entities are stored in LTS. I’m not a meteorologist - I don’t need to know what the cloud cover was 2 years ago.