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

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.

I use an ecobee termostat with Wifi and three extra sensores places around my home. Home Assistant already has an add-on for it, add the thermostat card and it goes to work. Set whatever automations you want.

I’m americana and would definitely support a ban of American Social media in my country.

You might reach out to the open source initiative if your app is open source. They have lawyers, and may be willing to provide guidance at the very least. I’m just guessing, and don’t work for the OSI, nor know for sure whether they will or wont help in any way. Just another place to look. At the very least they may be able to suggest attorneys who might be willing to help out.

I use a couple of mini pcs in exactly the setup you are talking about. Only downside is throughput. Anything built in is gonna be faster for read write ops, but usb3 is plenty fast for most things including media and data sync. I run Ubuntu with ZFS, and created raid arrays for data redundancy. It works really well. I virtualize using Incus with docker inside of those tiny VMs. It’s awesome.

I use the tp-link EAP615 wall Apps, they are great and run OpenWRT like a champ.

You might look into Netdata, I think it meets your requirements, it’s essentially plug and play, but I believe you can add alerts as well. Been a while since I looked at it, but they’ve put out some big updates lately.

Check out Picsur https://github.com/CaramelFur/Picsur

Glad you got Coturn working, what was it?

Haven’t messed with retention and deletion yet. Not enough data to mess with it so far.

Just and FYI those are my pages and Video, and I also don’t have sliding sync working yet. I work on it here and there, but other than Element X, I’ve had no issues getting clients to connect to my servers running dendrite. I’ll update those docs, and probably do an update video when I get it working on Dendrite.

Is it Ironic that I want to say “Amen” to this statement?

None of these things will change the minds of the people who support Trump. Humans, sadly, have an aversion to anything that threatens their beliefs. We have a law that says a convicted felon can’t vote in an election, and yet, no law to prevent that same felon from running for, and winning political office. The founding fathers, likely, never imagined a convicted felon would run for office, and even moreso that the people of this county would vote for him.