I noticed that some of the ActiveRecord adapters depend on ruby-dbi. I've just started to play with the ruby-dbi database driver DBD::Proxy, which allows me to connect to other ruby-dbi drivers running on other operating systems.
What seems more practical, developing a ActiveRecord database adapter for DBD::Proxy, or would you just target a specific database, and just depend on DBD::Proxy?
This is an example connect string:
dbh = DBI.connect('DBI:Proxy:hostname=192.168.1.2;port=9001;dsn=DBI:ODBC:testdb')
What does everyone think? It might be too difficult a task for my sub-par programming skills, but perhaps I could use something like the sqlserver_adapter as a starting point.
Reference: http://ruby-dbi.rubyforge.org/