• 0 Posts
  • 7 Comments
Joined 1 year ago
cake
Cake day: June 11th, 2023

help-circle
  • The Lemmy app we are using on our phones needs to download content from Lemmy so it can be displayed to us. Lemmy might just have one big file full of links, but that’s annoying to have to write code to handle. Or it might have a folder full of files where each file is a post, but that’s also a bit annoying to write code to manage.

    It (probably) uses a local SQLite database to store all of the cached posts.

    Conceptually, a database is just a place to store things, just like a big text file. The database just handles a lot of the grunt work for you and makes it easier to search, organize, and filter the data.

    So anywhere there is data, there could be a database.







  • Technically I run OpenHAB not HA, but I’ve struggled with this too.

    I’ve been wanting to dockerize my Openhab for a while but have found similar issues with compatibility and network discoverability so I’ve avoided it. My current setup is their official Raspberry Pi os (openhabian), with a Conbee II via Zigbee2mqtt for zigbee with Hue, Tradfri and Sonoff devices an Aeotec Zstick Gen5 (no plus) for Zwave with mostly Zooz devices, way too many WiFi devices (mostly TPLink Kasa) and probably some other things I’ve forgotten.

    To be honest though I haven’t fully nailed reliability. It works for months straight with no issues but every so often I get a bug that requires resetting a device or two, or an update stomping over my SSL certs, or some intermittent slowness, but it’s reliable enough. I specifically avoid any cameras or security devices (beyond some door sensors for non-security reasons) so that I don’t have the headache of high reliability.

    The whole setup is a patchwork of whatever happened to work at the time and wasn’t prohibitively expensive for me. I decided a long time ago that the flexibility was worth more than paying a bunch more for a single highly reliable system.

    It sucks, but it works better than manually switching on my lights all the time, so it’s good enough for me.