> Sorry for any confusion. I was answering the two different questions > the OP seemed to ask: > 1) *can* you set up different DBs for dev/test/production? > Yes you can, and it's very easy. > 2) *should* you do it? > No - in most cases.
I think, when you say "should you do it?" you mean "should you make your databases different?" which is the confusion, because you clearly explain that it's better TO MAKE THE DATABASES AS SIMILAR AS POSSIBLE (right?). So actually, my question, which was "Should the types of databases for development, testing, and production *all be the same*?" should get the answer, "Yes, the databases should be the same," correct? Bottom line: Although many Rails developers use different types of databases for the three environments, it is best to use the same type of database - e.g. MySql2 - for all three environments. Sound good? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

