Adapter gems available
Posted by David October 01, 2007 @ 02:31 PM
The extracted adapter gems are now available for install from the gems.rubyonrails.org server. Say you want the Oracle adapter installed, you just do gem install activerecord-oracle-adapter. All the extracted gems are:
- activerecord-firebird-adapter
- activerecord-frontbase-adapter
- activerecord-openbase-adapter
- activerecord-oracle-adapter
- activerecord-sqlserver-adapter
- activerecord-sybase-adapter
The mysql, postgresql, and sqlite adapters are still included in Rails core.
These will be released to the standard Ruby repository alongside Rails 2.0 when that reaches final.

Ah, and I was just wrapping up the OpenBase adapter to release it alongside the OpenBase gem. Does core want to keep the adapter in its own repository? Either way is fine with me – I’m just glad I can now have commit access and an independent release cycle. Woohoo! Go Rails 2.0!!
Is there a DB2 adapter?
@Noah: IBM has been maintaining their own DB2 adapter for several months now, which I believe was the reason it was not included in the list above.
Is there a Informix adapter ? In my work use informix 4GL and php
Why not Sqlite adapter? I think the list of supported DBs should be more comprehensive..
What’s the plan for unit testing the external adapters? Gonna copy over the AR test suite to the http://svn.rubyonrails.org/rails/adapters/ repository to share between those adapters? Or keep it bundled with Rails core and make it easy to invoke it for specific external adapters? The latter has the advantage of better code sharing, but makes it harder to account for per-database exceptions inside the test code (e.g. the Sybase and SQLServer adapters tend to skip certain date/time tests).
@Karim: Sqlite is included in Core.
I’ve tried using gem install for the sqlserver adapter, but I keep getting the Gem::GemNotFoundException error. Are these only going to be released with 2.0.0, or do I need to use a ’-s’ option?
Okay, just tried using the ’-s’ option and I got the adapter this time. Use
gem install activerecord-database-adapter -s http://gems.rubyonrails.org.The latter method, though I’m sure the adapter-specific tests will migrate toward the new repository.
I current access oracle with the RubyOCI driver. How does the activerecord-oracle-adapter change the way I work? What is the point? Does it replace RubyOCI?
Alex Rod,
There is an Informix adapter for sure. Look here:
http://wiki.rubyonrails.org/rails/pages/Informix
I’ve been using it for a long time.
(Disclaimer: I’m the author. Feel free to e-mail me if you have questions)
The IBM_DB-0.9.0 gem adapter/driver, maintained through rubyibm@RubyForge, provides access to all IBM Data Servers (DB2 8 and 9 on Linux, Unix, Windows, z/OS, i5/iSeries V5R3/V5R4 and Informix IDS 11.10).
Disclaimer: I will be answering your questions on rubyibm forum and tracker :-)
I started to use and have no any problems)