Which Database to choose when?

rubyonrails-talk
1

Hi folks,

I’m developing Ruby and Rails application for a while, but was mostly tight to MySQL or SQlite3. There is a lot of buzz about schema free DBs and I hear a lot of names like Redis, MongoDB, CouchDB etc.

So my question is what is (really) the difference between those and when do you choose one over the over. Especially when dealing with the enterprise ecosystem.

I know that this is one of the “tell-me-your-OPINION” topic, but I want to expand my horizon and don’t have the experience and background right now with those (NoSQL) databases.

Thank for any comments from experts.

Cheers,

Chris

2

Christoph Jasinski wrote:

I'm developing Ruby and Rails application for a while, but was mostly tight to MySQL or SQlite3. There is a lot of buzz about schema free DBs and I hear a lot of names like Redis, MongoDB, CouchDB etc.

I really don't think this is the appropriate forum to discuss this. It is not directly related to Ruby on Rails. I doubt that most people here really want to do your research for you. All those options you have listed have their own web sites with their own documentation that explains their strengths and trade-offs.

Go read about them and decide which is best for what you want to do.

http://code.google.com/p/redis/

http://couchdb.apache.org/

3

Thanks Robert.

So I’ll do the research on my own, now.

Chris