I started doing the One True Database method because I got worried that the high write count on all the little db’s was abusing a raspberry pi’s SD card. Moved them all to a bigger server with NVME and mirroring to a RAID.

Not all the compose files make obvious how to reconfigure the db host. Homeassistant uses s a sqlite db built into the container, rather than a separate unit, but you can force it to use a remote db through its config file. May or may not be worth hiding db user/pass in a .env And sometimes there’s trouble restarting after power failure, depending on what order the database, pi, and various containers come back up.

I also feel it’s worthwhile. I feel better being able to check on all the databases. Feel better not writing to the SD card so much. Feel better offloading those megabytes and cpu cycles from the little pi. It’s been fun snooping through database structures. There have been a couple times where I decided to query one of the ccontain databases directly, or cross from one project to another, and it’s easier (for me) to give a different user privileges to the database and query some deep bit of data than to figure out how to extract it from an API or frontend.

I’m not even running that many services, but why would I want the overhead of 6 separate mysql instances when I could just have one?

A records return the numerical address of a name.

CNAME returns a different name for a name. Basically ‘synonym’ so the maintainer only has to change the one master, A record when the IP address changes. Convenient to use CNAME to point www.example.com to example.com, but you can use it just as well to point example.com at my.private.host.xyz You can even chain multiple CNAMEs to make it easier to manage a complex backend structure while presenting a simple address to users.

Doesn’t work that way on lemmy: if they delete the post, then the alt’s shilling disappears, too.

or at least change the title to [solved] with a link to the comment that worked.

Uncheck “Send notifications to Email” in your settings. Or get a 3rd party app with a notifications setting.

Could they be astroturfing, looking for a specific solution to fill search engines with their own product placement, then deleting because most of the comments are other FOSS solutions?

Not who you replied ti, but I’ve been on purelymail for about a year and a half. No complaints. $10.yr is great, and their billing statements claim I could be around $3/year if I switched to their advanced billing. I have nagging concern that they’re hosted on AWS, and if your goal is to completely free yourself of US tech giants, then purelymail won’t.

.63W: N100 server with 2 HDD & 2 SSD. Cable modem. 5-port POE switch. WAP. Ooma VOIP device.

The POE & WAP are like 10W between them, but I had to add them to get strong enough wifi to one particular client. Authentik somehow consumes 3W. Immich also has a high idle load, so I leave it down most of the time.

Yeah, I started with a PCI (no e) card, but had to switch to USB when it got hard to find cheap motherboards with PCI slots. It’s an old setup :) Honestly amazed that they can fit the whole thing into a thumb-sized USB dongle, although I suppose it’s easier without the analog side.

I use a USB tuner like https://hauppauge.com/pages/products/data_dualhd.html and https://mythtv.org/ Has to be plugged into an external antenna, and it really helps for that antenna to be on the 2nd floor, in a window, with clear view unobstructed by aluminum siding.

tvheadend.org or HDhomerun are probably more general solutions.

My setup is a pile of kludges built on top of each other over the last two decades.

I started with ULAs distributed through DHCP, connected to named, which allows hosts do declare their own name and let me access local services as though I had a real domain.

My ISP eventually started supporting IPV6, but only assigned /128, so the ULAs got NAT-6ed out to the real world.

I eventually learned how to request prefix delegation from the ISP and set up SLAAC.

So now, my PIv6 clients have a) their link-local address, b) the ULA, c) a “privacy” SLAAC, and d) a unique SLAAC. All my internal services still refer to the ULAs.

I don’t think I’d recommend this system for someone setting up from scratch. The easiest thing would be to go with SLAAC, if you can get prefix delegation, and set your DNS/pihole to send the unique-SLAAC address of any servers you run.