I joined Obsidian Catalyst just to try out the Bases plugin. So far it's worth it, might fill the void for a self-hosted, plaintext Notion Database replacement!
Thankful for a Reddit post that SmartHQ appliances need a 2.4ghz network. The SmartHQ app isn't all that helpful with it's error messages.
I've on and off again spent time trying to find some replacement for Postgres for software I write. Postgres is wonderful but is also a heavy requirement for lots of little homelab services. I tend to run a Postgres instance for each service which takes quite a bit of memory and maintenance overhead.
In Rust-land there is DataFusion that has a SQL interface for querying and inserting data. Inserting data can be a bit messy though and seems very much not to be the focus.
DataFusion is integrated well with Delta though! Delta appears really interesting! It can use memory, filesystem, or remote storage. It supports write fairly well, including (fairly manually) the maintenance items that folks complain about with Postgres (compaction/vacuuming).
It took a day but I have a working prototype of creating a table on Minio, inserting data, and querying the table. Examples on Delta's site seem out of date and overly verbose at the same time.
I've had trouble with connections from my phone with WireGuard for a while. For maybe 2 years it wasn't a big enough issue to worry about. Finally looking, it seems to be an MTU issue that winds up causing problems for some sites, like Duck Duck Go. When I had that set as my default search engine it feels like the Internet is broken.
Setting the MTU to 1420 in my router WireGuard config seems to have fixed it! It was previously at 1200... for a reason I cannot recall.
I'm excited to see other folks interested in a Limbo/SQLx integration.
SQLx + support for an S3 store falls close to my ideal use case for application DB usage.
I ran into a problem with my homelab Minio cluster where a single node was able to corrupt the ls of a bucket. With that node turned off ls showed the latest files, with the node running ls wouldn't list any files added in the last month. Writes were fine in either case, other than not being ls-able. A manual heal on the cluster seemed to fix it fine enough.
It's nice to see more OIDC services coming out that (presumably) work well for self-hosting. Pocket-ID (via This Week in Self-Hosted and Rauthy.
I'm still using kanidm with no need to switch, but it's nice to see maybe-easier things to recommend for other folks to try!
Something went wrong on a homelab server and Docker stopped cleaning up old overlays.
Running docker system prune -a -f (via) seemed to fix it.
Total reclaimed space: 149GB :tada:
I have a Sense Energy Monitor but would really like a local solution, ideally Z-Wave as a bunch of my house is already Z-wave-d. Aeotec makes a whole house energy monitor but I need more clamps to monitor things like my HVAC system which can't be tracked with smart plugs.
The Sense learning for appliances hasn't worked all that well with variable loads and it seems to have trouble discerning between the various heat pumps in the house.
IoTaWatt was previously out of stock for a while. It's wifi, but can accommodate more clamps.