From: Brian Candler <B.Candler@...>
Date: 2007-05-08T21:27:38+09:00
Subject: Re: Witch Oracle library should I use

On Tue, May 08, 2007 at 05:38:27PM +0900, Ben Edwards wrote:
> On 04/05/07, Brian Candler <B.Candler@pobox.com> wrote:
> >On Sat, May 05, 2007 at 12:27:13AM +0900, Ben Edwards wrote:
> >> Have had a look on rubyforge and done a little looking around but not
> >> totaly sure which ruby oracle library's I should use.
> >>
> >> I am connecting to a 10g database.
> >>
> >> Ruby9i and Ruby/OCI8 seem to be the contenders, or is there something 
> >else.
> >>
> >> What would people recommend?
> >
> >ruby-oci8. It's been around for a long time, and it works well. It's the 
> >API
> >used by ActiveRecord's Oracle adaptor, and it also comes with a DBD for use
> >with ruby-dbi. I'm using it with Oracle 10g now.
> 
> ruby-dbi seems like a good idea but its Beta and there hasn't been a
> release for over a year.  Don't think the folks here will trust it in
> a production environment.

The last release was August 2006, and it has had 11,870 downloads since
then.

I used it (with Oracle) in a large project at a previous employer about 4
years ago, which is still running strong. Before ActiveRecord came along,
this was probably the most widely used database interface from Ruby. I
wouldn't worry about the "beta" label.

OTOH, if you're writing code which *only* ever needs to talk to Oracle, then
you may as well cut out the middle man.

Regards,

Brian.