Live data from Hacker News

Free Postgres databases for small projects

fly.io

171–180 of 231 posts

Re: Free Postgres databases for small projects

#171

Earlier quoted context omitted.

This isn't really a content-free comment -- you've let us know that you all are not sitting on your hands. Have you thought of hiring a technical writer? Think of it as a work-stealing algorithm if that helps :-)

If you click on the Twitter handle of one of the authors at the bottom of the article you’ll see they list their job as “technical writing at fly.io”.

Oops... I guess I should have written "...another technical writer".

Re: Free Postgres databases for small projects

#172
post #40

Earlier quoted context omitted.

This is true, but we aren't going to bill per request. We really can't, since we support arbitrary UDP and TCP services. I don't really want to promise anything we haven't shipped yet. But my perfect cloud service (a) charges me when VMs are alive and (b) gives me the tools I need to create/remove/stop/start/suspend/resume VMs based on either network activity or metrics. One flaw of Fly.io right now is that it's rela…

Can you scale each region based on usage i.e. have a huge server in US or Europe and a tiny one in a market you don't have many users in? fly.io is really an incredible piece of work, I'll probably just default to it as I am a massive Elixir fanboy :-) As others have said $50 seems a very low starting point but if you can make it cheaper why not, just means you've helped more people onto your service and they will gr…

Autoscaling and balancing regions is something we launched with, but it ended up not making much sense. Our load balance sends traffic to the next nearest region when an app is too busy. It's usually better to spread capacity around to lower latency for users, and then eat the additional latency when a region gets overloaded.

In most cases "the next nearest region" is less than 15ms away.

Re: Free Postgres databases for small projects

#173
post #40

Earlier quoted context omitted.

This is true, but we aren't going to bill per request. We really can't, since we support arbitrary UDP and TCP services. I don't really want to promise anything we haven't shipped yet. But my perfect cloud service (a) charges me when VMs are alive and (b) gives me the tools I need to create/remove/stop/start/suspend/resume VMs based on either network activity or metrics. One flaw of Fly.io right now is that it's rela…

I actually worry you are undervaluing yourselves. $50 is fine for 10 regions as a data point from where I sit though I wouldn’t object to less

Oh don't you worry. We can extract large sums of money from big companies.

Re: Free Postgres databases for small projects

#174

To the Fly.io team here, other than the "daily storage-based snapshots of each of your provisioned volumes"[0], is there a plan to offer something similar to Heroku WAL based restore system [1] where you can (from the control panel) restore a db to a moment in time? Also do you have any plans for a managed upgrading/patching of Postgres, again similar to Heroku? For me personally the fully managed nature of Postgress…

It's definitely more hands on.

We will be able to do a WAL backup / point in time restore feature when we ship object storage.

Managed upgrades are almost in. If you run `fly image show` it'll tell you if you need one, then `fly image update` will upgrade your Postgres. We don't do this automatically yet. It won't be difficult though.

Re: Free Postgres databases for small projects

#175

I had not heard of fly.io but i really appreciate free for side projects! I have a docker setup for .NET core psql app on digital ocean so will be fun to see if i can get a that working with you. Also pricing at a quick glance seems good. Are you running your own servers or using another cloud as the basis?

We run our own servers. It took a lot of work but it's really making life easier now. I'm not sure we could offer a free tier like this on top of another cloud.

Re: Free Postgres databases for small projects

#176
post #174

To the Fly.io team here, other than the "daily storage-based snapshots of each of your provisioned volumes"[0], is there a plan to offer something similar to Heroku WAL based restore system [1] where you can (from the control panel) restore a db to a moment in time? Also do you have any plans for a managed upgrading/patching of Postgres, again similar to Heroku? For me personally the fully managed nature of Postgress…

It's definitely more hands on. We will be able to do a WAL backup / point in time restore feature when we ship object storage. Managed upgrades are almost in. If you run `fly image show` it'll tell you if you need one, then `fly image update` will upgrade your Postgres. We don't do this automatically yet. It won't be difficult though.

> We will be able to do a WAL backup / point in time restore feature when we ship object storage

Brilliant! I have only had to use it once on Heroku, but that one time has me convinced that I couldn't live without it.

Re: Free Postgres databases for small projects

#177

This is awesome. One genuine question from someone with no context into their product: does Fly lock me in by barring access to WAL replication? This is something Heroku does that is extremely annoying as you'll grow and grow with them and one day you realize migrating the data will be a massive hassle.

We do not! You have full administrative access to your postgres. You can create offsite replicas, or even fork the Postgres app we use and deploy over your Fly.io installed postgres: https://github.com/fly-apps/postgres-ha

RDS preventing external streaming replicas is the most annoying thing ever.

Re: Free Postgres databases for small projects

#178

On thing I'm missing, is there an object store that works well with fly.io? Where do you store user uploaded content?

Most people use S3, some people run Minio on Fly. Everyone wants us to just ship object storage so they don't have to think about it.

Re: Free Postgres databases for small projects

#179

I'm a newbie in deploying and would love to see a documentation on how to deploy a spring boot using flyctl. Most docs are about node and ruby. Thanks for the free services.

Hey, just letting you know that almost all your comments are shadowbanned, in error it seems. You can use the contact link at the bottom of this page to contact HN staff to sort it out.

Re: Free Postgres databases for small projects

#180

How to get free postgres for small projects: sudo apt-get install postgres AND you actually get sole control of all the data, all without the need for a credit card! Seriously though, who is this for? Any backend hosting platform offers a database. It's just a standard at this point. For people hosting static gihub pages (and storing all the database connection credentials in frontend js?!), don't make me laugh. Or y…

This is for people who want to run a fullstack app and expand it to multiple regions.

"fly launch" on a Phoenix app, for example, gets your entire app + DB deployed in about 60s for free.

Post reply on HN