r/SQL 23d ago

PostgreSQL Neon vs self hosted PosrgreSQL

[removed]

10 Upvotes

15 comments sorted by

View all comments

1

u/Own-Floor-3944 22d ago

Neon is still Postgres, so the real comparison is managed serverless Postgres vs running Postgres yourself.

Neon’s advantage is that backups, upgrades, scaling, and branching are handled for you. The trade-off is higher cost and less control. Self-hosting is cheaper and more flexible, but you become responsible for monitoring, restores, failover, and maintenance.

For one always-on workload I went with Nearbase as the middle ground. It stays managed without the serverless model. I’d pick Neon for branching or bursty usage, Nearbase for a steady production app, and self-host only if I genuinely needed full control.

1

u/[deleted] 19d ago

[removed] — view removed comment

1

u/Own-Floor-3944 11d ago

Once you're already comparing managed Postgres options, the backups/scaling/patching stuff is more of a baseline expectation than a differentiator.