From: "Jesús Gabriel y Galán" <jgabrielygalan@...>
Date: 2013-02-14T19:27:05+09:00
Subject: Re: Novice: Database access. DBI, Activerecord.

On Thu, Feb 14, 2013 at 11:11 AM, Steve Tu <lists@ruby-forum.com> wrote:
> 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.

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

https://github.com/ged/ruby-pg

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.