From: Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] best postgres interface
Date: Thu, 25 Mar 1999 10:10:52 -0500
Message-ID: <199903251607.KAA25347@antares.mcs.anl.gov> (raw)
In-Reply-To: <36F9E168.4FD73415@broken.net>
> I see there are a couple of perl interfaces to
> postgres. Does anyone have any comments as to the
> best? I would prefer to use perl but if people
> think is this the wrong way to go i would like
> to know.
>
I can only speak about the Pg interface that I am using. The second
one you mentioned is probably DBI::*; I am not familiar with it but it
looks similar. You might consider DBI if you client needs to access
other data sources as well and if you want it to be more portable. As
far as perl vs. others, I guess all interfaces send the queries and
handle results in much the same way. However, by simply being in
perl, you have and added value of being able to process the results in
a very sophisticated manner. If you choose perl, you won't find
yourself among those who complain about the backend not being able to
compute an avg() of something or not getting the date in the format
they please. Also, some of the tasks that still represent a
considerable load on the backend can be trivially solved in perl.
--Gene
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: selkovjr@mcs.anl.gov
Subject: Re: [INTERFACES] best postgres interface
In-Reply-To: <199903251607.KAA25347@antares.mcs.anl.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox