From: Brian Candler <B.Candler@...>
Date: 2003-08-07T04:34:43+09:00
Subject: Re: Ruby and  MySQL Database...

On Thu, Aug 07, 2003 at 04:03:24AM +0900, Useko Netsumi wrote:
> I was wondering if there are updates for ruby modules for the lastest mysql
> 4.0.x? I'd love some sites as well that can give me tutorial implementing db
> programming with Ruby Scripting Language. Thanks

Don't know about latest mysql 4.x, does ruby-mysql-2.4.4 not compile with
it? If so you could help debug it by posting your compile errors here.

With mysql you have two choices: program directly with the mysql API, or go
through the DBI layer (which means installing an additional package,
ruby-dbi-all-0.0.20, in addition to ruby-mysql). The direct mysql API may be
slightly faster, but the DBI layer has the advantage of giving the same
frontend to many different database APIs (e.g. postgres, sqlite, oracle)
making your code easier to port to different databases. I say "easier"
because you still have to deal with the different SQL variations for each
database.

There is a good tutorial on using DBI here:
http://www.kitebird.com/articles/ruby-dbi.html

and there are also examples on ruby-dbi's homepage,
http://ruby-dbi.sourceforge.net/

Regards,

Brian.