I disagree with your broad statement that SQL in general isn’t tricky to make more performant if you know what you’re doing. Worked with DBAs who have decades of experience who have gotten great help in streamlining queries and schemas from AI tools in the last couple of years.

This

RustDesk is great, you can run the server on your own hardware, and set up the clients for unattended access. No need for a VPN, as long as all clients on both ends can find your server.

“He has no regrets whatsoever”, is this a quote from the employee, or from Trump about being a pedophilic predator?

Veloren has been a blast on my family’s self hosted system.

Yes, mistyped “replication” and got autocorrected to “recognition”. Sorry, didn’t notice at the time.

Just my opinion and experience. Setup a couple of cheap VPS instances, and setup recognition, one primary, one secondary.

Purelynail has been awesome.

This

I agree with a lot of the folks here. I don’t think it’s gate-kept. It’s just part of self hosting. I have a YouTube channel dedicated to teaching people about self josting, open source, and how to get it all running. There are great projects out there that provide incredibly powerful UIs, TrueNAS, OpenMediaVault, Unraid, Proxmox, NextCloud, HomeAssistant, NetBird, Pangolin, NGinX Proxy Manager, Portainer, and so many more. All designed to make self hosting easier and safer. I know 8 or 10 other creators who also do self hosting and how to’s. It does require learning, time, and dedication. As does anything worth while.

This

I think this is exactly what Pangolin was designed for and does.

Not knowing what your goal is, I’ll start with this: I had very similar hardware to you, and while I was fine with the Omaha Ui, I just never could get it setup how I needed or wanted. I had the er605v2, 3 eap615 wall WiFi 6 apps, and a switch for PoE from the Omaha line but don’t recall the model. I just finally gave up on it, and moved the er605 and wall WiFi APs to OpenWRT. Setup my network with a dumb PoE switch and 4 VLANs and haven’t looked back. It all just works and I almost never mess with it. I’m not saying it wasn’t a little work initially, but it’s been worth it. I’ve now added a 4th wall WIFI (just download a backup of an existing one, install openWRT and restore to the new one. Change the IP and done.) I added two managed PoE Switches with OpenWRT as well. So it’s allowing me to grow as I need to.

How long did you wait to visit the site after adding it to pangolin? I ask, because if you set it up and go within 30 seconds of saving you may see the cert warning initially. It can LetsEncrypt time to verify a site and issue a cert. it’s usually pretty fast, but I’ve seen it take up to 30 seconds or a little longer.

I’ve hit the same thing where I setup a site through Pangolin and go to it too fast, but if I just close the tab and wait about 20 seconds then go again, it all comes up with a proper cert. hope that helps.

Cheap VPS with Pangolin for Wireguard and reverse proving through the tunnel.

Invest in Apple.

This!

If you can get It’s blessing I’d suggest something like KASM workspaces or WebTops, basically a Linux desktop in the browser.

This!

This picture makes me think of a scene from Superman 2 where Zod is in the oval office and the president is sitting to address the nation, looking defeated. Maybe I’m misremembering. I’ll have to dig out my movie and see. Of course, Elon is no Zod, and Trump just looks lost. I’d bet the kid picking his nose has a higher IQ than the other 2 combined.