IBM Article: DB2 on Rails

rubyonrails-talk
1

I often forward IBM DeveloperWorks articles about RoR to this list. This is a new well-written 'Intermediate' article using DB2 with Rails: IBM Db2 – Data Management Software | IBM

Hope this helps. Cheers Mohit.

2

Thanks for the link, Mohit. Very interesting.

Best regards, Bill

3

Philip Nelson wrote:

Mohit,

Thanks for the link.

You'll find more on using DB2 with Rails in my blog -

http://blogs.ittoolbox.com/database/geek

I also gave a presentation entitled "DB2 on Rails" at the recent IDUG (International DB2 Users Group) in San Jose, which you can retrieve from -

http://www.scotdb.com/downloads.html

HTH

Phil

Thanks Phil

I think that's the presentation that I had offered to proof read once upon a time :smiley:

Cheers mohit.

4

Probably : I had to do lots of last minute adjustments after IBM released ibm_db 0.6.0 one week before the conference. So I never got round to sending it out for proof reading.

Phil

5

Mohit,

Thanks for the link.

You'll find more on using DB2 with Rails in my blog -

http://blogs.ittoolbox.com/database/geek

I also gave a presentation entitled "DB2 on Rails" at the recent IDUG (International DB2 Users Group) in San Jose, which you can retrieve from -

http://www.scotdb.com/downloads.html

HTH

Phil

6

Hi Phil,

Philip Nelson wrote:

You'll find more on using DB2 with Rails in my blog -

I've downloaded, but not yet installed, the Getting Started toolkit (might be called something slightly different) for Windows from the developerworks site. It looked from the description like it was similar to the Instant Rails distro; Ruby / Rails / DB / Webserver all-in-one. I'm hoping I'll get a chance to try it out tomorrow, but thought I'd ask if you know anything about it. Like, in particular, is my assumption about the content correct? I'm currently using Instant Rails for a number of reasons, most significantly its standalone / self-contained characteristics. Is the DB2 distro like that?

Thanks, Bill

7

If this is the Windows "Getting Started" then it includes DB2 Express-C and the precompiled adapter for DB2. Not sure if it actually installs Ruby and Rails too, but I guess it does (I'm a Linux person myself, and so downloaded the source code only).

There is a newer (and considerably improved) version of the IBM adapter / driver available from the RubyForge site -

http://rubyforge.org/projects/rubyibm

Note that the ibm_db2 driver has been renamed as ibm_db (it now covers more than DB2 on Linux, UNIX and Windows). I'd suggest that if you don't have DB2 installed already, and are using Windows, you should download and install the code from Alphaworks and then use gem to install ibm_db.

You'll find details in my presentation of the extra steps you'll need to carry out to use this : a couple of edits to add ibm_db to the list of supported adapters in Rails and ActiveRecord.

HTH

Phil