[fxruby-users] mysql

[Jonathan Stott]

I would second Lyle's suggestion that the two are seperate issues.

However, instead of interacting with the database directly via the
mysql gem, you might instead want to consider some form of
Object-Relational Manager (ORM).  An ORM will wrap a lot of the SQL
you are likely to write, and the rows you return, in Ruby objects and
methods.

There are several available for ruby:

ActiveRecord (of rails fame):
http://wiki.rubyonrails.org/rails/pages/ActiveRecord

Sequel: http://sequel.rubyforge.org/

DataMapper (my personal favourite, but currently under heavy
development) http://datamapper.org

They can significantly reduce the amount of 'boilerplate' SQL you have to write.

Regards,
Jon