From: Ben Edwards Date: 2007-05-09T03:30:15+09:00 Subject: Re: Witch Oracle library should I use On 08/05/07, Brian Candler wrote: > On Tue, May 08, 2007 at 05:38:27PM +0900, Ben Edwards wrote: > > On 04/05/07, Brian Candler 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. Need to have a look at ActiveRecord bit it seems not to be geared towards SQL. This is not a bad thing per say but I have a lot of SQL. I do fancy using some type of wrapper as we are thinking of moving stuff to postgress. Regards, Ben > 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. > > -- Ben Edwards - Bristol, UK If you have a problem emailing me use http://www.gurtlush.org.uk/profiles.php?uid=4 (email address this email is sent from may be defunct)