Question: Recommended Postgresql interface?


(Jeremy Henty) #1

What is the recommended way to interface Ruby to Postgresql? I have
been using ruby-postgres, but there seems to be little effort going
into its development recently (please correct me if I’m wrong).
Recent postings along the lines of “I am using ruby-postgres” tend to
get “why not use Ruby/DBI” answers. So is Ruby/DBI the way to go?

Regards,

Jeremy Henty


(SER) #2

Jeremy Henty wrote:

Recent postings along the lines of “I am using ruby-postgres” tend to
get “why not use Ruby/DBI” answers. So is Ruby/DBI the way to go?

Well, AFAIK (I installed DBI a looong time ago), Ruby/DBI uses
ruby-postgresql. Again, I may be way off-base here, but I believe that DBI
is predominantly an API layer on top of other DB interfaces. In the case
of PostgreSQL, I believe that you’ll find that if you try to install DBI
with access for PostgreSQL, you’ll be required to install ruby-postgresql.

···

… “This is America, we have freedom of religion. Why can’t we have
<|> freedom from religion as well??”
/|\ – anon
/|


(Jeremy Henty) #3

Oops, looks like I didn’t do enough research before posting. I’ll
check out Ruby/DBI more carefully. Thanks.

Regards,

Jeremy

···

In article 3cfaffe0@news.mhogaming.com, Sean Russell wrote:

Jeremy Henty wrote:

Recent postings along the lines of “I am using ruby-postgres” tend to
get “why not use Ruby/DBI” answers. So is Ruby/DBI the way to go?

Well, AFAIK (I installed DBI a looong time ago), Ruby/DBI uses
ruby-postgresql.


(Michael Neumann) #4

Ruby/DBI is a layer on top of ruby-postgresql. Because of this, it’s performance
is not that good (I guess factor 2-3 compared to plain ruby-postgresql).

But it’s easier to use.

Regards,

Michael

···

On Mon, Jun 03, 2002 at 02:50:15PM +0900, Sean Russell wrote:

Jeremy Henty wrote:

Recent postings along the lines of “I am using ruby-postgres” tend to
get “why not use Ruby/DBI” answers. So is Ruby/DBI the way to go?

Well, AFAIK (I installed DBI a looong time ago), Ruby/DBI uses
ruby-postgresql. Again, I may be way off-base here, but I believe that DBI
is predominantly an API layer on top of other DB interfaces. In the case
of PostgreSQL, I believe that you’ll find that if you try to install DBI
with access for PostgreSQL, you’ll be required to install ruby-postgresql.


(James) #5

Well, AFAIK (I installed DBI a looong time ago), Ruby/DBI uses
ruby-postgresql. Again, I may be way off-base here, but I
believe that DBI
is predominantly an API layer on top of other DB interfaces. In
the case
of PostgreSQL, I believe that you’ll find that if you try to install DBI
with access for PostgreSQL, you’ll be required to install
ruby-postgresql.

This is true. I recently rebuilt a system and after some frustration and
README perusing found that, indeed, using DBI with PostgreSQL requires
ruby-postgresql underneath.

DBI lets you ignore the details of the underlying database, but prevents
you from using every feature of any particular DB.

James