Support multiple databases.

rubyonrails-talk
1

I was wondering, how easy is it to develop an application to support different database back-ends? For example, I am looking to develop an app to support MySQL and SQLServer. One developer working in OS X against MySql, the other in Windows against SQLServer. Are there problems which may be encountered or does Rails handle all and it "just works"?

Cheers, Diego

2

You have to be a little careful with this, for sure, however it is not difficult as long as you keep in mind which models belong where.

This is a decent article on how to do this: http://schf.uc.org/articles/2006/12/06/multiple-concurrent-database-connections-with-activerecord

Do note that AR classes which redefine database connections can be subclassed and keep the super-class’s db connection. Thus:

class MySQLConn < ActiveRecord::Base establish_connection … end

class SQLServerConn < ActiveRecord::Base establish_connection … end

Then:

class Model1 < MySQLConn … does stuff to mysql end

class Model2 < SQLServerConn … does stuff to sqlserver end

You’ll have to go searching around and give some thought into dealing with test fixtures with this. There are a few articles around though as I haven’t done that, I’m not sure the best way.

Jason

3

Hi Jason,

Thanks for taking the time to reply. I'll look in thge directions you point to.

Cheers, Diego