[api]

Counterpoint: Postgres is very hard to properly configure in a HA configuration and is hard to scale out, and this will pretty much force you down a path of using managed Postgres. If you DIY a serious deployment you’ll be spending a ton of time researching it and getting it just right.

In other words Postgres is actually kind of expensive for serious use despite being “free.” It’s just something to be aware of. Kubernetes is another “free” system with this nature.

If I were starting a new project today I would look hard at cockroachdb. Its license is on paper less free than Postgres but in practice it’s more free for many use cases, and it’s a modern raft database with auto failover and pretty easy scaling.

Postgres feels like something from 1980s Unix. Everything is manual and clunky and very arcane.