Novice: Database access. DBI, Activerecord

Ruby
1

I have been playing with a Ruby tutorial and so far that has focused on
the facilities/functionality of Ruby - and apart from a couple of
misunderstandings, that is going fine.

I would like to now link the tutorials to a database (where I can store
code, tutorial data etc). I am used to using SQL and have knowledge of a
couple of RDBMSs (I have Informix and PostgreSQL installed).

The programming language that I currently use has a generic database
interface and can access a whole raft of databases.

What is the ‘recommended’ database interface route in Ruby? I’m not sure
I want to get into Rails as yet (not until I understand more about Ruby
itself) - so want something that works alongside ‘pure’ Ruby and allows
me to access more that one proprietary SQL database.

2

On Thu, Feb 14, 2013 at 11:11 AM, Steve Tu [email protected] wrote:

What is the ‘recommended’ database interface route in Ruby? I’m not sure
I want to get into Rails as yet (not until I understand more about Ruby
itself) - so want something that works alongside ‘pure’ Ruby and allows
me to access more that one proprietary SQL database.

You could try a driver that interacts directly with PostgreSQL, like
this gem:

Or you could try a generic interface. I have no experience with DBI. I
have done a couple of minor things with Sequel, and I like it a lot:

http://sequel.rubyforge.org/

Jesus.