CODEWITHSUNDEEP
ruby-on-railsrubydatabase
mrcaramori
mrcaramori

Reputation: 2503

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 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.

Upvotes: 14

Views: 23509

Answers (5)

Leon Katsnelson
Leon Katsnelson

Reputation: 450

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/.

Upvotes: 1

simeonwillbanks
simeonwillbanks

Reputation: 1459

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.

Upvotes: 2

bsberry
bsberry

Reputation: 1008

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.

Upvotes: 14

Alan Jackson
Alan Jackson

Reputation: 6511

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.

Upvotes: 1

house9
house9

Reputation: 20614

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

Upvotes: 7

Related Questions