Ask HN: Heroku or Not?

I recently launched a small project (http://statusdashboard.com) with the goal of learning RoR and was blown away by the community and infrastructure (particularly Heroku). 3 weeks from watching the first blog railscast to a fucntioning site (with SSL, recurring billing, monitoring, etc.). I've also setup a VPS and started learning how to host myself (I think it is always better to understand how the magic happens).

Heroku definitely hides the complexity of their "magic". It just seems to work so effortlessly.

However, my biggest question so far is this: what is the best practice for managing and maintaining the DB? I'm used to jumping into the db for routine tasks, ad-hoc reporting, and troubleshooting. Amazon RDS would make it easier, but a bit pricy for my needs right now. I also understand you can db pull, but I've heard a few examples of data loss when attempting a pull/push roundtrip with a local PostgreSQL instance. So, I find myself spending time in the Heroku console, manipulating the data in code, manually.

What do you do to manage/report on data in the DB? I'm preparing to launch a number of larger projects, but need to get a better system in place first.

Those aren't the same thing at all. You can't write C in visual basic. The guy you were responding to was comparing what it would take to get your application working with Heroku vs. what it would take to set up your own server providing some of the same services that Heroku does.

If you were trying to set up a similar question, it'd have to be more like: "Should I use gcc or should I write my own C compiler?" Clearly the correct answer here is "Use gcc" if you're trying to get work done, but that doesn't mean nobody should ever write their own compiler, either. It's just not the right choice for most people, even though I'm sure there is a huge reward in learning how to do it.

Use Heroku is the simple answer. Unless you have specific needs for background processing or do some stuff that is not in Ruby, use Heroku. This is especially true if you have not set up a production system before.

Here's my take:

-> if time is more precious than money, go with Heroku.

-> if money is more precious than time, go with Linode/SliceHost etc.

You can change your mind later on (depending on scale increase cash etc), or even mix-and-match (eg: your workers on Linode, your front-ends on Heroku).

Last point: some software (eg: sphinx) are not available on Heroku, and some others (eg: websolr) are quite costly compared to a roll-your-own setup.

Start with Heroku. It's actually quite cheap for low traffic.

At the same time, buy a $20/month Linode. Start playing around with it by setting up toy web sites and web apps. If you don't have experience setting up a server, then it's important to be experimenting with one for a long time because it takes a while to learn things. For example, you not only have to install and configure all of the necessary software, you have to think about security and resource utilization (memory, CPU, disk). You also are going to want to set up some server monitoring software such as serverdensity.com. And you're going to want to get used to managing web traffic (reading Apache logs, tuning Apache for performance, etc.). All of this takes time. But if you do this then if the time comes for you to switch away from Heroku, you will have experience setting up and managing your own web server.