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

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 web开发者_如何学Csite 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.

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.

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

Engine Yard is a trusted Rails host. They support MySQL, Postgres and MongoDB. Here is their list of supported technologies:

http://www.engineyard.com/technology/stack

On May 10th, they are hosting a demo on their cloud services.

MySQL is by far the most common free web database now a days, and is very common in Ruby on Rails Projects. Almost all linux hosting providers will give you mysql databases. Unless you have a specific reason to go elsewhere, it is a great place to start.

I have personally implemented a couple of RoR projects that used MySQL as the backend with no complaints.

I don't think there is any argument that MySQL is the most used. If you re looking for an enterprise class database, I say give DB2 a try. Just like MySQL, DB2 Express-C is free and optional support is available. DB2 is the only database that has support from the vendor. See http://antoniocangiano.com/2010/04/22/rails-db2-and-the-enterprise/.