Comment by grugdev42

> Maybe I'm not the target market for this, but how hard is it REALLY to manage a RDBMS?

It depends:

- do you want multi region presence

- do you want snapshot backups

- do you want automated replication

- do you want transparent failover

- do you want load balancing of queries

- do you want online schema migrations with millisecond lock time

- do you want easy reverts in time

- do you want minor versions automatically managed

- do you want the auth integrated with a different existing system

- do you want...

There's a lot that hosted services with extra features can give you. You can do everything on the list yourself of course, but it will take time and unless you already have experience, every point can introduce some failure you're not aware of.

I would have no concerns around reliability uptime running my own database.

I would have concerns around backups (ensuring that your backups are actually working, secure, and reliable seems like potentially time intensive ongoing work).

I also don't think I fully understand what is required in terms of security. Do I now have to keep track of CVEs, and work out what actions I need to in response to each one? You talk about firewall rules. I don't know what is required here either.

I'm sure it's not too hard to hire someone who does know how to do these things, but probably not for anything close to the $50/month or whatever it costs to run a hosted database.

Backups are a PITA I wanted to go exactly this route but even though I had VMs and compute I can't let any production data hit it without bullet proof backups.

I setup a cron job to store my backups to object storage but everything felt very fragile because if any detail in the chain was misconfigured I'd basically have a broken production database. I'd have to watch the database constantly or setup alerts and notifications.

If there is a ready to go OSS postgres with backups configured you can deploy I'd happily pay them for that.

It's not about it being hard, it's about delegating. Many companies are a bit less sensitive to pricing and would rather pay monthly for someone else to keep their database up, rather than spending engineering hours on setting up a database, tuning it, updating it, checking its backups, monitoring it and making it scale if needed.

Sure, any regular SME can just install Postgres or MySQL without even setting much up except with `mysql_secure_install`, a user with a password and an 'app' database. But you may end up with 10-20 database installs you need to back up, patch and so on every once in a while. And companies value that.

> Maybe I'm not the target market for this, but how hard is it REALLY to manage a RDBMS?

It is not. You can provision a free Postgres instance with a single click: https://neon.new/

One instance maybe but multi regional?

Look into the capabilities of what I consider the leading edge of open source RDBMS managed solutions, Yugabyte: https://www.yugabyte.com

And tell me how easily you can achieve this "out of the box"

If you don't care about business continuity or high availability then everything gets easier

> And neither MySQL or Postgres ever seem to go down, they're super reliable and stable

The box they're on goes down

> Any Linux distro

What is the upgrade path?

How often do they release?

Do I have to worry about CVEs?

Who is doing network security?

Who is testing that security?

Where are my credentials stored?

Do I have a dashboard that tracks the hundreds of resources I'm responsible for including this new one?

> Plus you have very stable costs each month

I'm sick and tired of managing linux boxes. It simply doesn't scale in any reasonable way.