Live data from Hacker News

Free Postgres databases for small projects

fly.io

181–190 of 231 posts

Re: Free Postgres databases for small projects

#181

I'm having trouble understanding the purpose of these edge services. Granted, I've only handled small - medium sized infrastructures, and never really experienced the issues at scale, but if I were to get to that point, wouldn't it be easier to just hire a Infrastructure Engineer who could deal with the replication / sharding, not to mention having that engineer also deal with site reliability and dev ops? If a user…

A user hitting your service would hopefully be hitting your service on Fly.io and that would be talking to a database on Fly.io. :)

You can replicate across datacenters on Fly.io for free. No infra engineer required. And very little code change required: https://fly.io/blog/run-ordinary-rails-apps-globally/

Re: Free Postgres databases for small projects

#182

Not sure if this is a dumb question but is this basically the same as Heroku? What’s the difference?

We're different, but only because we were builtin 2020 instead of 2008. Notably:

1. You get your own Postgres proces and disk, no shared database instances 2. Private networking is baked in. Your app talks to postgres over an encrypted private network 3. You can provision persistent disks and run basically anything you want 4. We support arbitrary TCP and UDP services, not just HTTP.

We're also substantially cheaper.

Re: Free Postgres databases for small projects

#183

Earlier quoted context omitted.

I was blind-robbed by a German company because of that. I paid a full year, was never given access,I "opened" a ticket and they answered a full week later asking me to fill 2 forms with lots PIID+ national ID card + Credit card, I told them to get lost. For being a supposedly modern, democratic society Germany seems very backward regarding online things, it is not surprised that for a economy of its size and influenc…

Was it PamFax? I used them for my one-time personal use over 10 years ago...

Yes, see what they wrote after fully charging me and refusing a charge back:

> There are some security issues with your account. We need to verify the > account holder in order to unlock your account again. > Please send us a scanned photo ID of the account holder and also a Letter of > authority (LOA). It is required that the entered account information are > also shown on the proof. > We will then enable your PamFax account immediately.

Re: Free Postgres databases for small projects

#184
post #182

Not sure if this is a dumb question but is this basically the same as Heroku? What’s the difference?

We're different, but only because we were builtin 2020 instead of 2008. Notably: 1. You get your own Postgres proces and disk, no shared database instances 2. Private networking is baked in. Your app talks to postgres over an encrypted private network 3. You can provision persistent disks and run basically anything you want 4. We support arbitrary TCP and UDP services, not just HTTP. We're also substantially cheaper.

That's awesome. Thanks for the reply. :)

Re: Free Postgres databases for small projects

#185

Earlier quoted context omitted.

Was it PamFax? I used them for my one-time personal use over 10 years ago...

Yes, see what they wrote after fully charging me and refusing a charge back: > There are some security issues with your account. We need to verify the > account holder in order to unlock your account again. > Please send us a scanned photo ID of the account holder and also a Letter of > authority (LOA). It is required that the entered account information are > also shown on the proof. > We will then enable your PamFa…

Merchants can't just refuse a chargeback. The entire point of a chargeback is that it's clawing money back from an unwilling merchant.

Re: Free Postgres databases for small projects

#186

Earlier quoted context omitted.

What are the physical security implications of using Fly.io and other edge computing services? Is some shady ISP colocation as safe as highly secured AWS and Azure data centers?

Fly isn’t really edge in the sense that they are colocating with lots of ISPs like Netflix might for video at the edge. Fly is edge in the sense they have hosts in N regions and manage the anycast for you so traffic seamlessly routes to those regions. They don’t publish which data centers they operate in only the regions ( https://fly.io/docs/reference/regions/ ) but most of those regions line up with equinix data ce…

We should do better documenting security across the board, but I keep getting drawn into i.e. months-long DNS optimization problems. This'll get done this year, though.

Re: Free Postgres databases for small projects

#187
post #47

Earlier quoted context omitted.

It's an attempt to reduce friction. Developers try services like ours out for fun before they use them in anger. Putting a price on the fun stuff keeps people from trying it. It's not that $6.88/mo is too much, it's that >$0/mo is too much for developers who are used to their side projects being subsidized by monopolies or VCs. People spend a lot of money on infrastructure when they use it in anger. Free apps cost us…

Hey, talking about friction.. in your pricing page you say https://fly.io/docs/about/pricing/#managed-ssl-certificates > Managed SSL certificates > We use Lets Encrypt to issue certificates, and donate half of our SSL fees to them at the end of each calendar year. > Single hostname certificates > Free for the first 10 > $0.10/mo for additional certificates > Wildcard certificates: $2/mo So, if my pet project needs a…

The infrastructure to manage and distribute certificates is pretty complicated, and doing support for certificate issues is expensive. This is why we bill for them. More details here: https://news.ycombinator.com/item?id=22624262

For people who need a whole bunch of certificates, the price hasn't been an issue.

The problem with services that are free at any scale is that there's never an incentive to make them any good. Most of our certificate infrastructure improvements have been done because people who were trying to give us money were having a hard time of it.

Re: Free Postgres databases for small projects

#188

What are the security implications of edge computing? Is our business data as safe in some shitty ISP colocation as it is in highly secured AWS and Azure data centers?

AWS has some of the most secure data centers on the planet, so I'd hesitate to draw comparisons, but we're mostly at Equinix, which is no slouch on physical security.

Re: Free Postgres databases for small projects

#189
post #47

Earlier quoted context omitted.

It's an attempt to reduce friction. Developers try services like ours out for fun before they use them in anger. Putting a price on the fun stuff keeps people from trying it. It's not that $6.88/mo is too much, it's that >$0/mo is too much for developers who are used to their side projects being subsidized by monopolies or VCs. People spend a lot of money on infrastructure when they use it in anger. Free apps cost us…

> If we can sift through 1,000 free users and find one who converts to $25k per month, we're delighted. Does this ever happen? I was contacted by a F500 who needed some custom version of my open source project ( https://github.com/mickael-kerjean/filestash ). 25k sounds unreal but hey I have no experience in purchasing enterprise grade software and it's not simple to find actual figures so I was aiming at making an o…

Ok this is a good and difficult question.

For _our particular service_ this happens, but that's partially because the service is designed to scale to very large customers and the market has set a price for cloud computing resources. Companies already spend money on infrastructure, we're not having to convince them to do that from scratch. We do have to convince them to point that firehose our direction.

What you're doing is more difficult. In general, big companies will spend $10k per month as easily as they'll spend $2.4k per month. It's equally difficult to convince them to do either.

Does filestash get used by multiple people in an organization? If I were trying to price this, I'd invent a "per user" price and target $500/mo for small organizations (like $50/user). Enterprises don't love per user prices that scale, so it gives you a story for "we'll give you unlimited users for $10k per month".

I am more than happy to talk more about this if you want to send me an email, but I'm mostly guessing about OSS licensing. I haven't done the work for real.

Re: Free Postgres databases for small projects

#190

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.

I would start here, if you can get it running in Docker it's very easy to run on Fly: https://spring.io/guides/gs/spring-boot-docker/
Post reply on HN