Forum: Ruby Novice: Database access. DBI, Activerecord.

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.

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

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.