Hacker News Reader

Comment by chanks | Hacker News Reader

It looks like Heroku's dropping the larger shared database offering ($15/month for 20 GB). That's... disconcerting. That means their cheapest production database now is the Ronin for $200 a month, but I have an app going into production soon that won't need anywhere near that much power.

View on HN

The shared 20gb plan (based on the older, Postgres 8.3-based architecture) is still available, as is the free 5mb shared offering. We won't replace these until this new development plan is out of beta. Once we do we will continue to have a database plan at or near this price point. Stay tuned.

Matt Soldo (Product Manager, Heroku Postgres)

Thanks, Matt. Can you share what the dev plan's row limit is? The blog post doesn't say.

We haven't determined the limit yet. Our goal is that it is more than enough to evaluate the heroku platform and to develop and test on, and high enough that any of the existing shared:5mb databases can migrate to it without worries.

It will very likely be on the order of 10^3.

Looking forward to hearing the features the "database plan at or near this price point" will have. We would love to be able to connect to our database with other apps besides the main one - even if it ended up somewhere between the $200/month plan and the $15/month - it would be incredibly useful.

This is awesome. Had been really bummed about the lack of direct psql access for the shared database. Thanks Matt and co.!

Just a clarification - I was kind of requesting a feature, hoping that the new plans will work that way.

Thanks for the feature request. Attaching multiple apps to one DB is something we've wanted to do for quite a while...

FYI, you can hack this by provisioning a database on one app, then manually setting the DATABASE_URL config var on a second app to match that of the first app.

I want that too.

In fact, on my todo list is to research the other database providers for Heroku to see if any of them offer this capability.

Time to switch to a db add-on provided by a third party?

Try: https://addons.heroku.com/justonedb or https://addons.heroku.com/cleardb

What reason would you have to switch because of this? It seems like an enormous improvement.

My response was based purely on the parent poster's comment: "It looks like Heroku's dropping the larger shared database offering".

The rep from Heroku hadn't added his clarification yet.

I should have been more skeptical. Apologies.

I downvoted this, but I wish I hadn't, because the links more than make up for the trite comment. If you haven't checked out the Heroku Add-ons in a while, as was the case with me, it's worth a look!

If you can work with MySQL, then you'll get a much cheaper plan with a reserved instance of Amazon's RDS.

Besides being MySQL under the hood, which has known flaws compared to PostgreSQL, with Amazon RDS you get to be completely worry free. You can also do backups on Amazon's S3 and setting up a replicated slave is literally just a push of a button.

I wonder if this will come with some smaller production plans between dev and Ronin. We're also in the situation of getting enough performance out of the shared db offering and not needing the power of Ronin yet.

Also, I'd hope they will give a few months warning before flipping the switch completely, similar to how the hoptoad/airbrake switch went.

We will certainly have a deprecation / transition period between the existing shared db plan and the new development plan that will give users ample opportunity to migrate their data. Safely preserving data is our number one priority, so this will be handled carefully.

> Also, I'd hope they will give a few months warning before flipping the switch completely, similar to how the hoptoad/airbrake switch went.

Funny you should say that, as I was involved in the hotpoad/airbrake transition and am now involved in the Heroku postgres one. The transition will be as smooth as we possibly can, no data will be lost, there will be plenty of time to move your data, and easy ways of doing so.

We are really excited about offering a development and free 9.1 postgres service, a huge step forward from the current 8.3 shared database service, and are looking forward to moving people over to the new instances.

Reply on news.ycombinator.com