From: Jim Clark <diegoslice@...>
Date: 2007-12-25T04:32:17+09:00
Subject: Re: Ruby DBI

Praveen Ray wrote:
> Hi
> What's the best way to do raw SQL in Ruby? Something like Perl's DBI. 
> I see there is a Ruby DBI <http://rubyforge.org/projects/ruby-dbi/> 
> but it seems in beta. Can one use ActiveRecord to run arbitrary SQL 
> statements? I'm not really interested in a full-fledged ORM - just a 
> way to run SQL succinctly and easily.
>
> Thanks
I think you'll find that Ruby's DBI works very well and you should give 
it a try, especially if you don't want the overhead of Rails. I've used 
it a couple of times and found it to be very easy having used Perl's DBI 
for many years. Feel free to post your script and any problems if you 
need further help.

Regards,
Jim