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

For an actual NAS solution, meaning your primary goal is storage, then Rockstor, OpenMediaVault, and TrueNAS are the big open source ones I know of. I believe they can all do ZFS and RAID these days

If you’re looking for a system to host self hosted apps, that can also do ZFS storage, check out Incus Containers on a playing Ubuntu or Debian install, and use LXConsole for the UI side.

I use Picsur. It’s very similar. I have liked it quite a bit.

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.

Sorry for the delayed reply. Haven’t really played Minecraft, so can’t say, but I’ll say I run my own server and the family and I play for while til we get to a point we’ve done what we want, and I then go in and change the world sees and we get a new world and start all over.

I’ll give a vote for Zulip. It’s come a long way over the years, and if you really look at the way they’ve built it, it’s so much better than most options as there is a built in concept of context in threaded conversation.

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!