News for hackers. Stuff that matters.
Re:The economics of a Postgres free tier by mrkurt on Thursday July 11, 2024 @06:09PM (#40941053)
You can run a Postgres on Fly.io full time for just slight more than $2.

It's not a great business though. The compromise you're making is that we don't manage it. It'll probably stay running, it's likely to be worry free (especially if you barely use it), but if anything goes wrong it's up to you.

You could also spin up a VM for cheap somewhere, install Postgres, and just let it be.

Managed databases are expensive to run – worry free costs quite a bit of money to ensure. Maybe you don't need that for a hobby project?

Re:The economics of a Postgres free tier by tossandthrow on Thursday July 11, 2024 @07:00PM (#40941364)
On more than one occasion I have lost data on Fly. this is absolutely not a managed Postgres (and they don't claim to be)
Re:The economics of a Postgres free tier by tossandthrow on Friday July 12, 2024 @07:10AM (#40944474)
I just now realize who you are!

I can add, that I actually had this setup running on Fly for a small analytics backend for a low volume website.

When I tried to login to the interface after some months I discovered that everything had been broken for at least some weeks - to a degree that I could not recover anything from the volume.

Love the business model! Ability to just load 50$ on to my account and let is run.

But I don't dare to use your services to anything but ephemeral dev envs.

Re:The economics of a Postgres free tier by mrkurt on Friday July 12, 2024 @09:31PM (#40951047)
Believe it or not, I know exactly when this happened and why. We had a big disk array failure and (a) our UI did not know how to recover and (b) disk snapshots timed out before many people knew their disks were gone.

This is one of those instances where an unmanaged single node Postgres sucks to use.