The API team at IBM recently released a new update for the ibm_db gem, which includes both the Ruby driver and the Rails adapter for DB2 (and Informix). This coincides with the release of the latest major upgrade to DB2 LUW (Linux/Unix/Windows), which is now up to version 10.1.
ibm_db 2.5.10 adds support for Rails 3.2 and fixes a few minor bugs that have been reported by the community. New features such as Time Travel Queries are supported seamlessly.
The biggest news is the simplified installation process. You now only need to set the DB2’s instance user home, and the gem installation process will take care of determining both which architecture (e.g., 32 vs 64 bit) and libraries to use.
All it really takes now to install ibm_db on a Linux/Unix/Mac box is something along the lines of:
$ sudo -s $ export IBM_DB_HOME=/home/db2inst1/sqllib $ gem install ibm_db
Windows users don’t even have to worry about setting up the home directory. It will work both on Windows 32 and 64 bit systems, but unlike with *nix systems, Ruby and ibm_db will run in 32 bit mode only.
To try out DB2 with Ruby/Rails, I recommend you download and install DB2 Express-C for free.
Get more stuff like this
Subscribe to my mailing list to receive similar updates about programming.
Thank you for subscribing. Please check your email to confirm your subscription.
Something went wrong.
Hi,
Will you folks be able to get back to the Python driver which seems a bit out of date? Also the sqlalchemy adapter is for sqla version 0.4 but sqla version 0.7.7 is the current version
I’d like to try out DB2 12x but we’re a python shop and somehow, I just don’t feel comfortable with the db2 python and sqla adapters at this time
thanks
Hi Brad,
>> Will you folks be able to get back to the Python driver which seems a bit out of date? <>Also the sqlalchemy adapter is for sqla version 0.4 but sqla version 0.7.7 is the current version<<
We are working on Python 3 support and you could expect a release soon. You can check the branch http://code.google.com/p/ibm-db/source/browse/#svn%2Fbranches%2Fibm_db_sa which has support for SA version 0.7.x . Jaimy Azle (jaimy.azle@gmail.com) who is developing and maintaining the branch will be able to provide you more details.
Thanks
Praveen