Grant Hutchison
2005-Sep-09 13:58 UTC
Fw: No one interested in DB2 drivers for Ruby - what does it mean?
After reading all of my email (I was on vacation for 2 weeks ;->) I came
across 7 interested parties in total.
I would be interested in any additional input on this subject and you have
sparked my interest in trying Ruby and Ruby on Rails with DB2 to experience
it for myself.
IBM has made contributions within the Perl and PHP communities with
optimized drivers for DB2 based on our native C libraries (known as DB2
CLI).
DB2 UDB v8.2 has a very nice feature called HADR with Client Reroute that
can provide a primary/standby database server configuration that is highly
available and this technology should work within a Ruby application since
the automatic reroute to the active database server is handled within the C
runtime layer. The transaction performance of DB2 is also a great reason to
consider deploying any application with DB2 instead of another RDBMS (just
some thoughts).
I would like to consider getting more involved in enhancing the DB2 support
with the Ruby community if there is sufficient demand.
Grant Hutchison
----- Forwarded by Grant Hutchison/Toronto/IBM on 09/09/2005 09:41 AM -----
"M. Edward (Ed)
Borasky"
<znmeb-2WxwdZd67h5Ng+MwTxZMZA@public.gmane.org
To
t>
rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
cc
09/09/2005 09:34 Grant Hutchison/Toronto/IBM@IBMCA
AM Subject
Re: [Rails] No one interested in
DB2 drivers for Ruby - what does it
mean?
Andrew Stuart wrote:
>Hello Folks,
>
>A few days ago I invited people to email Grant Hutchison from IBM if they
>have any interest in IBM developing "official" Ruby drivers for
DB2.
>
>Grant says that only two people sent an email expressing interest, and one
>was from IBM!
>
>I wonder what this means - that Ruby people aren''t developing for
DB2
>because there aren''t enterprise endorsed DB2 drivers, or that DB2
is just
>not as accessible to Ruby developers as MySQL or Postgres. Or maybe
>something else?
>
>
<pregnant pause> Is DB2 open source?
>Anyway it''s a bit of a disappointment because I was hoping to be
able to
>develop applications that take advantage of DB2''s powerful row
level
access>control security.
>
>
If DB2 isn''t open source, is this a useful feature that should be in
PostgreSQL or MySQL?
>Are there any Ruby people out there who use DB2?
>
>
I think the question is "are there DB2 people who use (or would like to
use -- or who would be allowed to use) Ruby?"
--
M. Edward (Ed) Borasky
http://www.borasky-research.net/
http://borasky-research.blogspot.com/
http://pdxneurosemantics.com
http://pdx-sales-coach.com
http://algocompsynth.com
Andrea Campi
2005-Sep-09 14:23 UTC
Re: Fw: No one interested in DB2 drivers for Ruby - what does it mean?
Hi Grant, On Fri, Sep 09, 2005 at 09:58:48AM -0400, Grant Hutchison wrote:> After reading all of my email (I was on vacation for 2 weeks ;->) I came > across 7 interested parties in total.I am interested too, as I''m using Rails with DB/2 as part of my job.> DB2 UDB v8.2 has a very nice feature called HADR with Client Reroute that > can provide a primary/standby database server configuration that is highly > available and this technology should work within a Ruby application since > the automatic reroute to the active database server is handled within the C > runtime layer. The transaction performance of DB2 is also a great reason to > consider deploying any application with DB2 instead of another RDBMS (just > some thoughts).This is a great feature. Is any modification needed to benefit from this from say a C app written to the CLI, or is this an external configuration? We''ve been handling failover manually, and this would make our lives that much easier.> I would like to consider getting more involved in enhancing the DB2 support > with the Ruby community if there is sufficient demand.Apart from improved Ruby drivers, the Rails adapter needs some work too. In particular, DB2''s inability to limit rows returned from a query to a range needs to be worked around by using subqueries. It would be great to be able to have top-notch DB/2 support out of the box. Bye, Andrea -- Press every key to continue.
Grant Johnson
2005-Sep-09 14:35 UTC
Re: Fw: No one interested in DB2 drivers for Ruby - what does it mean?
Have any of you looked at SQLRelay? I believe it has DB2 support, and it definitely has a Ruby driver to connect to it.
Chris Hall
2005-Sep-09 15:53 UTC
Re: Fw: No one interested in DB2 drivers for Ruby - what does it mean?
Slightly off topic, but... I''m in a DB2/iSeries/MySQL shop right now. Currently we use Java and PHP for our web based development. All business data resides on the iSeries, with web app data being both on DB2 and iSeries. We are slowing moving DB2 data to the iSeries. Nonessential business data will continue to reside in the MySQL database. We currently utilize the iSeries Access ODBC driver to access data in the iSeries database since there is no native PHP driver for iSeries. I''ve been experimenting with RoR and am very pleased with the fact that it supports both DB2 and MySQL out of the box, but I am also saddened by the fact there is no support for ODBC, which is what I would need to access the iSeries database. I''d really like to use RoR for future development, but without ODBC support, that''s a deal breaker. What is the chance for ODBC support being added to RoR? On 9/9/05, Grant Hutchison <ghutchis-G1DYhSM1WHTQT0dZR+AlfA@public.gmane.org> wrote:> After reading all of my email (I was on vacation for 2 weeks ;->) I came > across 7 interested parties in total. > > I would be interested in any additional input on this subject and you have > sparked my interest in trying Ruby and Ruby on Rails with DB2 to experience > it for myself. > > IBM has made contributions within the Perl and PHP communities with > optimized drivers for DB2 based on our native C libraries (known as DB2 > CLI). > DB2 UDB v8.2 has a very nice feature called HADR with Client Reroute that > can provide a primary/standby database server configuration that is highly > available and this technology should work within a Ruby application since > the automatic reroute to the active database server is handled within the C > runtime layer. The transaction performance of DB2 is also a great reason to > consider deploying any application with DB2 instead of another RDBMS (just > some thoughts). > > I would like to consider getting more involved in enhancing the DB2 support > with the Ruby community if there is sufficient demand. > > Grant Hutchison > > > > > > > > ----- Forwarded by Grant Hutchison/Toronto/IBM on 09/09/2005 09:41 AM ----- > > "M. Edward (Ed) > Borasky" > <znmeb-2WxwdZd67h5Ng+MwTxZMZA@public.gmane.org To > t> rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > cc > 09/09/2005 09:34 Grant Hutchison/Toronto/IBM@IBMCA > AM Subject > Re: [Rails] No one interested in > DB2 drivers for Ruby - what does it > mean? > > > > > > > > > > > > > Andrew Stuart wrote: > > >Hello Folks, > > > >A few days ago I invited people to email Grant Hutchison from IBM if they > >have any interest in IBM developing "official" Ruby drivers for DB2. > > > >Grant says that only two people sent an email expressing interest, and one > >was from IBM! > > > >I wonder what this means - that Ruby people aren''t developing for DB2 > >because there aren''t enterprise endorsed DB2 drivers, or that DB2 is just > >not as accessible to Ruby developers as MySQL or Postgres. Or maybe > >something else? > > > > > <pregnant pause> Is DB2 open source? > > >Anyway it''s a bit of a disappointment because I was hoping to be able to > >develop applications that take advantage of DB2''s powerful row level > access > >control security. > > > > > If DB2 isn''t open source, is this a useful feature that should be in > PostgreSQL or MySQL? > > >Are there any Ruby people out there who use DB2? > > > > > I think the question is "are there DB2 people who use (or would like to > use -- or who would be allowed to use) Ruby?" > > -- > M. Edward (Ed) Borasky > > http://www.borasky-research.net/ > http://borasky-research.blogspot.com/ > > http://pdxneurosemantics.com > http://pdx-sales-coach.com > http://algocompsynth.com > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
Andrew Stuart
2005-Sep-11 05:56 UTC
Re: No one interested in DB2 drivers for Ruby - what doesit mean?
Hi Grant - welcome to the list - nice to see IBM decision makers here in the
Ruby community.
Maybe it''s a bit of a chicken and egg thing - the demand for DB2
drivers
from Ruby users won''t be there until more DB2 users discover Ruby. DB2
users may not take up Ruby without IBM''s driver support.
DB2 tends to be found in a "corporate" environment. Ruby, and Ruby on
Rails,
are probably not sufficiently mainstream yet to be breaking through the
common corporate IT department law that everything must be Java ;-)
And as Ruby does become more acceptable to corporate environments, the
infrastructure people and applications development teams are less likely to
work with Ruby without official IBM DB2 drivers.
Personally my objective is to use DB2 because of its row level access
control, available in no other database except Oracle, where row level
access control is an add-on and not part of the base product.
Some people seem to have missed the first community petition email, perhaps
due to the mailing list problems recently - I''ll send out a second
call.
Andrew Stuart
----- Original Message -----
From: "Grant Hutchison"
<ghutchis-G1DYhSM1WHTQT0dZR+AlfA@public.gmane.org>
To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org>
Sent: Friday, September 09, 2005 11:58 PM
Subject: Fw: [Rails] No one interested in DB2 drivers for Ruby - what doesit
mean?
After reading all of my email (I was on vacation for 2 weeks ;->) I came
across 7 interested parties in total.
I would be interested in any additional input on this subject and you have
sparked my interest in trying Ruby and Ruby on Rails with DB2 to experience
it for myself.
IBM has made contributions within the Perl and PHP communities with
optimized drivers for DB2 based on our native C libraries (known as DB2
CLI).
DB2 UDB v8.2 has a very nice feature called HADR with Client Reroute that
can provide a primary/standby database server configuration that is highly
available and this technology should work within a Ruby application since
the automatic reroute to the active database server is handled within the C
runtime layer. The transaction performance of DB2 is also a great reason to
consider deploying any application with DB2 instead of another RDBMS (just
some thoughts).
I would like to consider getting more involved in enhancing the DB2 support
with the Ruby community if there is sufficient demand.
Grant Hutchison
----- Forwarded by Grant Hutchison/Toronto/IBM on 09/09/2005 09:41 AM -----
"M. Edward (Ed)
Borasky"
<znmeb-2WxwdZd67h5Ng+MwTxZMZA@public.gmane.org
To
t>
rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
cc
09/09/2005 09:34 Grant Hutchison/Toronto/IBM@IBMCA
AM Subject
Re: [Rails] No one interested in
DB2 drivers for Ruby - what does it
mean?
Andrew Stuart wrote:
>Hello Folks,
>
>A few days ago I invited people to email Grant Hutchison from IBM if they
>have any interest in IBM developing "official" Ruby drivers for
DB2.
>
>Grant says that only two people sent an email expressing interest, and one
>was from IBM!
>
>I wonder what this means - that Ruby people aren''t developing for
DB2
>because there aren''t enterprise endorsed DB2 drivers, or that DB2
is just
>not as accessible to Ruby developers as MySQL or Postgres. Or maybe
>something else?
>
>
<pregnant pause> Is DB2 open source?
>Anyway it''s a bit of a disappointment because I was hoping to be
able to
>develop applications that take advantage of DB2''s powerful row
level
access>control security.
>
>
If DB2 isn''t open source, is this a useful feature that should be in
PostgreSQL or MySQL?
>Are there any Ruby people out there who use DB2?
>
>
I think the question is "are there DB2 people who use (or would like to
use -- or who would be allowed to use) Ruby?"
--
M. Edward (Ed) Borasky
http://www.borasky-research.net/
http://borasky-research.blogspot.com/
http://pdxneurosemantics.com
http://pdx-sales-coach.com
http://algocompsynth.com
_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails
Larry Kelly
2005-Sep-12 00:02 UTC
Re: No one interested in DB2 drivers for Ruby - what doesit mean?
I''m sure there are more out there who, like me, would wish to have the comfort of knowing that there is a good maintained DB2 driver available for Rails. While I currently using Rails with Oracle and MSSQL SERVER. There is a DB2 application in our IT domain. It runs flawlessly, so I don''t hear much about it. But, if there became a need to connected to a webapp, It would be comforting to know that I could capitalize on my existing Rails skills. IT seems that anything that Rails can connect too easily, tends to get used more. IMHO -Larry> ----- Original Message ----- > From: "Grant Hutchison" <ghutchis-G1DYhSM1WHTQT0dZR+AlfA@public.gmane.org> > To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> > Sent: Friday, September 09, 2005 11:58 PM > Subject: Fw: [Rails] No one interested in DB2 drivers for Ruby - what > doesit > mean? > > > After reading all of my email (I was on vacation for 2 weeks ;->) I came > across 7 interested parties in total. > > I would be interested in any additional input on this subject and you have > sparked my interest in trying Ruby and Ruby on Rails with DB2 to > experience > it for myself. > > I would like to consider getting more involved in enhancing the DB2 > support > with the Ruby community if there is sufficient demand. > > Grant Hutchison >-- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails
Chris Hall
2005-Sep-12 12:51 UTC
Re: No one interested in DB2 drivers for Ruby - what doesit mean?
What are the chances of seeing an iSeries/ODBC driver? I''d really like to use RoR here at work, but without DB2 and iSeries/ODBC, I can''t sell RoR, much less mention it, to the management here. On 9/11/05, Larry Kelly <ldk2005-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I''m sure there are more out there who, like me, would wish to have the > comfort of knowing that there is a good maintained DB2 driver available for > Rails. While I currently using Rails with Oracle and MSSQL SERVER. There > is a DB2 application in our IT domain. It runs flawlessly, so I don''t hear > much about it. But, if there became a need to connected to a webapp, It > would be comforting to know that I could capitalize on my existing Rails > skills. IT seems that anything that Rails can connect too easily, tends to > get used more. IMHO > -Larry > > > > > > ----- Original Message ----- > > From: "Grant Hutchison" < ghutchis-G1DYhSM1WHTQT0dZR+AlfA@public.gmane.org> > > To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> > > Sent: Friday, September 09, 2005 11:58 PM > > Subject: Fw: [Rails] No one interested in DB2 drivers for Ruby - what > doesit > > mean? > > > > > > After reading all of my email (I was on vacation for 2 weeks ;->) I came > > across 7 interested parties in total. > > > > I would be interested in any additional input on this subject and you have > > sparked my interest in trying Ruby and Ruby on Rails with DB2 to > experience > > it for myself. > > > > I would like to consider getting more involved in enhancing the DB2 > support > > with the Ruby community if there is sufficient demand. > > > > Grant Hutchison > > > > -- > Best Regards, > -Larry > "Work, work, work...there is no satisfactory alternative." > --- E.Taft Benson > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >
Rich Duzenbury
2005-Sep-12 17:19 UTC
Re: No one interested in DB2 drivers for Ruby - what doesit mean?
On Mon, 2005-09-12 at 08:51 -0400, Chris Hall wrote:> What are the chances of seeing an iSeries/ODBC driver? I''d really > like to use RoR here at work, but without DB2 and iSeries/ODBC, I > can''t sell RoR, much less mention it, to the management here.I''m curious about this myself, as I happen to be an iSeries guy. I thought there was already some type of ODBC support provided by client access on windows, and supposedly (linuxodbc? unixodbc?) provided for linux boxen. I admit, it''s all very fuzzy for me as I haven''t ever tried to make it work. The real question I have is - how would this be useful? While you can create a table on iSeries via ''the ruby way'' (single numeric key), just about *all* of the software I have worked with (for the past umpteen years) expresses one to many relationships with multiple key fields, which seems to be different than how rails wants it to work. (NB - I am an extreme nuby with rails). Take our accounts table. Account number is the primary, unique key. Accounts can have many transactions. The transactions table has two key fields, account number and sequence number. The unique key is a combination of both fields, and it''s supported as a ''unique'' constraint easily by the database.>From what I''ve read so far, rails wants the transaction table to haveone autoincrement unique key field, id, and then a field called account_id to make the relationship work. Tell me I''m wrong (please!)... The rails way could almost use the relative record number, if it weren''t for RGZPFM and REUSEDLT(*YES). Can rails be adapted to work with multiple fields specifying the keys? If so, how?> > On 9/11/05, Larry Kelly <ldk2005-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > I''m sure there are more out there who, like me, would wish to have the > > comfort of knowing that there is a good maintained DB2 driver available for > > Rails. While I currently using Rails with Oracle and MSSQL SERVER. There > > is a DB2 application in our IT domain. It runs flawlessly, so I don''t hear > > much about it. But, if there became a need to connected to a webapp, It > > would be comforting to know that I could capitalize on my existing Rails > > skills. IT seems that anything that Rails can connect too easily, tends to > > get used more. IMHO > > -Larry > > > > > > > > > > ----- Original Message ----- > > > From: "Grant Hutchison" < ghutchis-G1DYhSM1WHTQT0dZR+AlfA@public.gmane.org> > > > To: <rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org> > > > Sent: Friday, September 09, 2005 11:58 PM > > > Subject: Fw: [Rails] No one interested in DB2 drivers for Ruby - what > > doesit > > > mean? > > > > > > > > > After reading all of my email (I was on vacation for 2 weeks ;->) I came > > > across 7 interested parties in total. > > > > > > I would be interested in any additional input on this subject and you have > > > sparked my interest in trying Ruby and Ruby on Rails with DB2 to > > experience > > > it for myself. > > > > > > I would like to consider getting more involved in enhancing the DB2 > > support > > > with the Ruby community if there is sufficient demand. > > > > > > Grant Hutchison > > > > > > > -- > > Best Regards, > > -Larry > > "Work, work, work...there is no satisfactory alternative." > > --- E.Taft Benson > > _______________________________________________ > > Rails mailing list > > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/railsRegards, Rich -- Current Conditions in Des Moines, IA Broken Clouds Temp 78.8F Winds out of the Southwest at 17, gusting to 21mph Moderate Haze
Hi Grant, Have you had any better response from the Ruby community? Do you think it''s likely that IBM will build DB2 drivers for Ruby? I''m trying to make a decision about the database platform on which to build our new in house systems and frankly I''m too nervous about using the homebrew DB2 drivers that are currently available for Ruby - I fell like I''ll hit some limitation or problem and then the decision to go DB2 will be a poor one. If IBM did build such drivers, what''s a guesstimate for how long might it take for them to become available for Ruby under Linux? Thanks Andrew Stuart Managing Director Flat Rate Recruitment Head Office: 170 Dorcas Street South Melbourne, Victoria 3205 Phone: 1300 55 91 92 Phone 03 9696 1616 Fax: +61 3 9686 6680 Mobile: 0417 034 241 Email: andrew.stuart-EHINDgXnq7QrV/aubVXsvDvXrrhHudLZEK66K81epY8@public.gmane.org Web: http://www.FlatRateRecruitment.com.au
Oops! Sorry folks - hit reply on the wrong mail message. Please disregard. Thanks Andrew Stuart Managing Director Flat Rate Recruitment Head Office: 170 Dorcas Street South Melbourne, Victoria 3205 Phone: 1300 55 91 92 Phone 03 9696 1616 Fax: +61 3 9686 6680 Mobile: 0417 034 241 Email: andrew.stuart-EHINDgXnq7QrV/aubVXsvDvXrrhHudLZEK66K81epY8@public.gmane.org Web: http://www.FlatRateRecruitment.com.au