IBM DB2 and migrations

There’ve been a few questions about migrations and the IBM DB2 adapter. I’ve written a short list that explains what transformations are supported and what are not so far.

June 27 2006 | How-to | Comments Off

DB2 on Rails at RailsConf: Day One – Dave Thomas’s keynote

Dave Thomas opened the conference with his keynote and it absolutely struck the right cord with me. His message was both blunt and simple: “For Ruby on Rails to succeed i.e. to gain much wider adoption it must embrace legacy i.e. the stuff that already exists.” Given the fact that I spend all of my time in the enterprise, I could not agree more. Dave talked about 3 challenges but the one that I really resonated with me (the all did) the challenge of embracing data integration. Active Record is an incredibly elegant piece of technology. The value that derives form DRY (Don’t Repeat Yourself) can not be overstated. But Active Record fails to exploit constraints that are already defined in most databases. In a typical enterprise application you will have data architects and DBAs spend significant effort to define constraints on the data that reflect real world business rules. So why is it that that the framework that espouses to live and die by the principle of DRY makes programmers respecify these constraints in the Active Record instead of just using what has already been specified in the database? It just makes sense for Active Record to build validations from the constraints that are defined in the database. This would take Rails from “elegant” to “brilliant”. I do not mean any disrespect towards the Rails programmers, they really are cream of the crop … but in an enterprise application you simply will not have all of the information to do all of the validations to enforce all of the business rules and constraints. Not over a span of many years (decades) that the application will stay in production. One thing that is true about data gathered by successful applications is that is always accessed by other applications. This is why enterprise class database systems define and enforce constraints in the database. Given that their job is to is ensure data integrity no matter which application they serve, how can they not? I really hope that RoR community heads Dave Thomas’s call and makes Active Record really brilliant.

June 24 2006 | Announcements | 3 Comments »

New article on DB2 on Rails by Edd Dumbill

When you download Startup Toolkit for DB2 on Rails you get 3 flash movies that help to get you started. But these demos will only give you a taste. On the other hand there are many really good books out there on both Ruby and Rails but they don’t talk about DB2. Now there is also an article on developerDomain. This article is written by Edd Dumbill a guy with a lot of practical experience both doing and teaching Ruby on Rails. So, clear out 15 minutes on your calendar and point your browser to http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0606dumbill/ to read An introduction to Ruby on Rails for DB2 developers.

June 23 2006 | Announcements and How-to | Comments Off

DB2 on Rails at RailsConf: Day Zero

Well DB2 on Rails is finally at the RailsConf 2006. The start of this week was our preparation for the confernece that IBM is actually sponsoring. DB2 on Rails is a debutant in the Ruby on Rails world and RailsConf is its coming out party of sorts. Naturally we are all a bit nervous.

June 22 2006 | Conferences | Comments Off

How to connect Rails to DB2

I’ve just created a page that explains how to configure the database.yml file in Rails so that it works with the IBM DB2 adapter. You can find it here.

We plan to create an extensive FAQ section on this site, where we’ll address several of the main questions that we’ve been receiving over the past few weeks.

June 22 2006 | How-to | 2 Comments »

RailsConf 2006 is only 2 days away

This year IBM is sponsoring RailsConf in Chicago. Our sponsorship is in place to highlight the introduction of the Starter Toolkit for DB2 on Rails. If you are one of the lucky 550 or so attendees, you can pick up DB2 on Rails CD-ROM at the registration desk. If you are not coming to the conference, point your browser to Startup Toolkit for DB2 on Rails and download your own copy.

I am attending the conference. So, if you see me around, say hello. I’ll be the guy (or one of the guys) in a black golf shirt with DB2 on Rails logo. And I guess I should mention that my name is Leon Katsnelson but “DB2 guy” will also work. By the way, if you are going to the conference, you should check out RailsConf Facebook at http://facebook.railsconf.org/. Here is my entry.

June 20 2006 | Conferences | Comments Off

Update your DB2 on Rails to v1.1

We just published a minor update to the Startup Toolkit for DB2 on Rails. We have not added new functions but we did address several bugs. One of the most serious issues is DB2 adapter disabling other databases. The new version 1.1 does solve this problem though we do think that DB2 is the only database you need .
For those of you on Windows you can apply the update by clicking on the “Check for Updates” shortcut on the DB2 on Rails folder in Start/All Programs. Those of you on Linux and build your driver and adapter from source, simply download DB2onRails_V1.1_Source.zip and follow instructions in README.txt.

June 16 2006 | Announcements | 1 Comment »

DB2 goes on Rails

If you love Ruby on Rails and find that database like MySQL just does not cut it for you, you will be glad to hear that you can now use DB2 for your Ruby on Rails projects. IBM enabled DB2 for RoR programming by releasing a DB2 Ruby driver and DB2 Rails adapter as part of the Startup Toolkit for DB2 on Rails. This makes DB2 the only database with the vendor supplied enablement for Ruby on Rails.

June 14 2006 | Announcements | Comments Off