What databases should I use with Ruby on Rails, based on current Hosting services?

Question

I've been looking for hosting services and I still don't know what kind of database is the most commom. It seems to be MySql and PostgreSql. So, I'm not sure about how much traffic and data my website will have (it's just a project), but I would like to be prepared. I've worked in some projects with Oracle (PL/SQL) and I know something from MySql.

Thank you !

ps. 4 years later, I've been coding RoR mostly with PostgreSQL. SQLite by default when I need simple apps, but PostgreSQL otherwise.

Answer 1

One of the tenets of Rails is you shouldn't really care what database you're using: that's all abstracted for you.

So I would say go with the hosting provider that seems the overall best, and trust them to pick a good database.

In this case, as house9, I would recommend Heroku as an excellent overall service. Start with a small, free plan, scale up as needed. They use PostgreSQL by default, which has been entirely adequate in my experience.

Answer 2

I recommend Heroku for hosting they require Postgres or if you want to go 'NoSql' - you can use MongoDB via the MongoHQ Heroku plug-in

http://heroku.com/

they offer a 'free' plan for small sites