Great tool for documenting your setup. I use this at work a lot

I would say that “on prem” defines a location, “selfhosting” an action. You can do both at the same time, e.g. selfhosting nextcloud onprem.

Apparently, it is not only my oberservation, but the article says similarly:

The inconsistent approach to backward compatibility in decades past may also have played a part.

However, I’m not a db admin and my perspective might be biased (infosec).

I would say that this is a sign of a bad product. Apparently, compatibility between SQL server versions is not great.

Probably overkill, but for projects like this I’ve setup WordPress in the past. Once everything was done, I converted the WordPress page to a static site with httrack and use the static version.

This gives the ease of setting up and editing combined with the stability and security of a static HTML website.

While you can probably use them for some small tasks (like a switch, a file server with a USB thumb drive or a print server), you’re probably better off if you can sell them and buy a raspberry pi or similar.

The Fritzbox 7530 for example could be sold for 50€ (at least in my country).

That’s exactly what the nextcloud desktop app does.

What I don’t get is why anyone would like to buy a new gadget for some AI features. Just develop a nice app and let people run it on their phones.

TBH, the description in the original post is not very clear.

Have you tried the official Nextcloud desktop app?

Many “smart” devices are sold with the idea that you can control your home from somewhere else. Maybe change the temperature on your way home or get notified when someone rings your doorbell. All this stuff requires servers to work.

Controlling some lightbulbs via bluetooth/wifi would be possible of course, but probably not very interesting for many.

Even a raspberry pi can run linux with an lxd desktop, and this i3 is a few times faster than a raspberry pi. But it depends on what you want to with it…

The performance target of “linux desktop running lxd” and the price tag “not crazy expensive” is not very clear…

I would personally look for a fanless barebone pc and equip it with as much RAM and storage as you like. One example for this could be the Zotac ZBOX CI629, which you can get for around 400 Euros and has a 13th gen Intel i3 built in.

Is this within your budget?

Not OP, but generally, you want to separate internal and external services as much as possible. Some even suggest running external services on a cloud server and internal servers on your LAN.

If you run internal and external services on the same host, you need to be careful to not make any configuration mistakes. Take extra time to also test what should NOT be possible.

We had it at work, but I never did anything else than receiving and resolving alerts. But it looked good for me and I liked the system.

While I really like uptime kuma, it seems a bit too restricted for OPs use case. For example, to monitor disk or CPU usage, you would need to write your own scripts. It would be doable, but not very nice.

At least how I understood the.question, OP would probably look for something like icinga.

With 4 TB, the price difference is quite painful (at least for me). With anything below, I’d buy an SSD without thinking twice.

One of the best offers I could find is 300€ for 20 TB, which makes exactly 15€/TB.

My guess is that it is often hard for people to grasp that HDDs loose value much faster than other items they own. New HDDs are larger and offer better price per TB, and older HDDs have a higher risk to fail.

I can buy new HDDs at 16€/TB, why should I spend 12€/TB on a used disk?

I have no idea why, but I made the same experience. Used drives are in most cases much overprized. Often far beyond the price/TB of new, larger disks.