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.
