I don’t understand - you want a layer to hide database internals but also a web app that “is only the db itself”?

At least for some android phones this is already possible with Lineage OS.

Use something like pgAdmin, DBeaver or the pg cli to connect to your postgres instance. Then run the command from the changelog as a SQL query.

First offense, 72 hour unpaid leave. And better hope there’s no complaints because not wearing it is reasonable suspicion.

Second offense? Goodbye.

That’s the key. You can do a lot with technology, but many problems are not solvable with technology alone.

It does not matter how safe or reliable bodycams work if there are no repercussions for not wearing or disabling them. But since american cops are not even held accountable if they straight up murder people, nobody should be surprised that bodycams “don’t work” in a system like this.

You can get a quick overview via DSM, I think in the Disk Manager. For more details you could jump into a terminal and use smartctl.

Have you checked the SMART values of your drives? Do they give you a reason for your concerns?

Anyhow, you should never be in a position where you need to worry about drive failure. If the data is important, back it up separatly. If it isn’t, well, don’t sweat it then.

Why would you buy something new if your current solution works and your requirements don’t change? Just keep it.

Also good with Boost once I opened the image and clicked “HD”.

Wasabi S3 is nice and cheap. You’ll only pay what you use, so probably just a few cents in your case.

Oops, nevermind:

If you store less than 1 TB of active storage in your account, you will still be charged for 1 TB of storage based on the pricing associated with the storage region you are using.

I recently upgraded three of my proxmox hosts with SSDs to make use of ceph. While researching I faced the same question - everyone said you need an enterprise SSD, or ceph would eat it alive. The feature that apparently matters the most in my case is Power Loss Protection (PLP). It’s not even primarily needed to protect from an possible outage, but it forces sync writes instead of relying on a cache for performance.

There are some SSDs marketed for usage in data centers, these are generally enterprisey. Often they are classified for “Mixed Use” (read and write) or “Read Intensive”. Other interesting metrics are the Drive Writes Per Day (DWPD) and obviously TBW and IOPS.

At the end I went with used Samsung PM883.

But before you fall into this rabbit hole, you might check if you really need an enterprise SSD. If all you’re doing is running a few vms in a homelab, I would expect consumer SSDs to work just fine.

What’s wrong with Portainer?

I have no experience with terraform but Bitwarden has an API and CLI, so you might be able to script something with it?