3 ms·

"This was before Home Assistant offered their own hardware... Home Assistant uses SQLite, and when you have a ton of sensor data flowing in, SQLite can start ch

"This was before Home Assistant offered their own hardware... Home Assistant uses SQLite, and when you have a ton of sensor data flowing in, SQLite can start choking." Their $99 hardware works great. Some devices are chatty but it's two lines in the startup config to filter the bulk of it, with no useful functionality lost. If the data being generated by your living room is overwhelming SQLite on an eMMC, wow. Home Assistant is one of the few recent products to delight me during setup. The sheer number of weird things it found on my network was impressive. The number of them that are dropping off as various cloud vendors try to lock things down, even more so. It has definitely motivated my future purchase choices and pushed me to simplify.

fullstop 2y ago
I had problems in the past with the sqlite database getting corrupted on shutdown. I moved it to a postgresql database on the same VM and it's been fine since.
- badlibrarian 2y ago
  Yeah, past experience with RPi/SD cards certainly gave me pause. No problems yet, knock wood. $99 well spent. Didn't see anything widespread in the forums and they made online backup a priority in the latest version. I like these folks, their priorities, and the community they built. Interesting that Google Nest and Tesla are pissing everyone off at the moment. The forum is a leading indicator of brands to avoid.
  - eternityforest 2y ago
    Pi SD cards seem to be extremely reliable, I have not had issues with Amazon SanDisks. Especially not if you get a bigger one than you need to spread wear more. I've probably spammed this comment an obnoxious number of times already, but I think a lot of the problem is that IIRC HA still writes logs as they happen. Filesystems don't like small frequent writes, it makes write amplification happen. I handle logging by buffering everything in RAM, and optionally only saving min/max/avg data, on top of only logging points that are specifically configured. I have a script to set up /var/log as a ramdisk, along with a few other things things I've found can occasionally go wrong and write a bunch of stuff. But I don't use HA, or have any idea how hard it would be to do this kind of thing in HA.
MortyWaves 2y ago
Yet every single time I see HA in relation to a raspberry pi, the number one complaint is it destroying SD cards.
- badlibrarian 2y ago
  Yes, that has been my experience with RPi in general. But there's a lotta Pis and lotta Linux versions and a lotta SD cards and a lotta hobbyists out there. Using the $99 Home Assistant Green with eMMC soldered to the board was a leap. So far no problems, nor much griping in the forums.

fullstop 2y ago

I had problems in the past with the sqlite database getting corrupted on shutdown. I moved it to a postgresql database on the same VM and it's been fine since.

badlibrarian 2y ago
Yeah, past experience with RPi/SD cards certainly gave me pause. No problems yet, knock wood. $99 well spent. Didn't see anything widespread in the forums and they made online backup a priority in the latest version. I like these folks, their priorities, and the community they built. Interesting that Google Nest and Tesla are pissing everyone off at the moment. The forum is a leading indicator of brands to avoid.
- eternityforest 2y ago
  Pi SD cards seem to be extremely reliable, I have not had issues with Amazon SanDisks. Especially not if you get a bigger one than you need to spread wear more. I've probably spammed this comment an obnoxious number of times already, but I think a lot of the problem is that IIRC HA still writes logs as they happen. Filesystems don't like small frequent writes, it makes write amplification happen. I handle logging by buffering everything in RAM, and optionally only saving min/max/avg data, on top of only logging points that are specifically configured. I have a script to set up /var/log as a ramdisk, along with a few other things things I've found can occasionally go wrong and write a bunch of stuff. But I don't use HA, or have any idea how hard it would be to do this kind of thing in HA.

MortyWaves 2y ago

Yet every single time I see HA in relation to a raspberry pi, the number one complaint is it destroying SD cards.

badlibrarian 2y ago
Yes, that has been my experience with RPi in general. But there's a lotta Pis and lotta Linux versions and a lotta SD cards and a lotta hobbyists out there. Using the $99 Home Assistant Green with eMMC soldered to the board was a leap. So far no problems, nor much griping in the forums.