pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpgperl vs dbd-perl
5+ messages / 3 participants
[nested] [flat]
* pgperl vs dbd-perl
@ 2005-08-09 14:45 David <dbree@duo-county.com>
0 siblings, 1 reply; 5+ messages in thread
From: David @ 2005-08-09 14:45 UTC (permalink / raw)
To: pgsql-interfaces
I'm wondering which of the two is considered the best. I have both
installed on my system and actually have done some work with PgPerl
because it looked a bit less complicated, and at first, I thought that
this might be a more postgres-specific interface.
However, in researching the mailing lists, etc, it seems that DBD:: is
getting the most attention - in fact, I see little mention of PgPerl,
and the PgPerl list seems rather quiet.
In addition, it appears that DBD can do things that PgPerl can't. For
example, I haven't been able to find an escape-string function in
PgPerl, which I'm now looking to implement. Would one need to write his
own escape-string for PgPerl?
Is PgPerl still viable or is DBD the way to go?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgperl vs dbd-perl
@ 2005-08-09 14:57 Sean Davis <sdavis2@mail.nih.gov>
parent: David <dbree@duo-county.com>
0 siblings, 2 replies; 5+ messages in thread
From: Sean Davis @ 2005-08-09 14:57 UTC (permalink / raw)
To: David <dbree@duo-county.com>; pgsql-interfaces
On 8/9/05 10:45 AM, "David" <dbree@duo-county.com> wrote:
> I'm wondering which of the two is considered the best. I have both
> installed on my system and actually have done some work with PgPerl
> because it looked a bit less complicated, and at first, I thought that
> this might be a more postgres-specific interface.
>
> However, in researching the mailing lists, etc, it seems that DBD:: is
> getting the most attention - in fact, I see little mention of PgPerl,
> and the PgPerl list seems rather quiet.
>
> In addition, it appears that DBD can do things that PgPerl can't. For
> example, I haven't been able to find an escape-string function in
> PgPerl, which I'm now looking to implement. Would one need to write his
> own escape-string for PgPerl?
>
> Is PgPerl still viable or is DBD the way to go?
DBD::Pg is the way to go, for numerous reasons. DBI is very well supported.
More importantly, almost all database-related work is done by building on
DBI. Interfacing your own code with those of others is then relatively
straightforward. See, for some examples, DBIx::RecordSet or Class::DBI.
Finally, if you every need to port to another database product (GASP!), DBI
is fairly easy to adapt (depending on DB-specific SQL).
Sean
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgperl vs dbd-perl
@ 2005-08-09 16:10 David <dbree@duo-county.com>
parent: Sean Davis <sdavis2@mail.nih.gov>
1 sibling, 0 replies; 5+ messages in thread
From: David @ 2005-08-09 16:10 UTC (permalink / raw)
To: Sean Davis <sdavis2@mail.nih.gov>; +Cc: pgsql-interfaces
On Tue, Aug 09, 2005 at 10:57:41AM -0400, Sean Davis wrote:
> On 8/9/05 10:45 AM, "David" <dbree@duo-county.com> wrote:
>
> > I'm wondering which of the two is considered the best.
> > However, in researching the mailing lists, etc, it seems that DBD:: is
> > getting the most attention - in fact, I see little mention of PgPerl,
> > and the PgPerl list seems rather quiet.
> > Is PgPerl still viable or is DBD the way to go?
>
> DBD::Pg is the way to go, for numerous reasons. DBI is very well supported.
> More importantly, almost all database-related work is done by building on
> DBI. Interfacing your own code with those of others is then relatively
> straightforward. See, for some examples, DBIx::RecordSet or Class::DBI.
> Finally, if you every need to port to another database product (GASP!), DBI
> is fairly easy to adapt (depending on DB-specific SQL).
Well, so far (and quite quickly) I've received two replies and both are
in agreement that DBD is the way to go. and Dirk Jagdmann flatly stated
that PgPerl is outdated.
This was much as I'd suspected so I think I'll move over.
Thanks to both of you for the insight.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgperl vs dbd-perl
@ 2005-08-10 03:28 Joshua D. Drake <jd@commandprompt.com>
parent: Sean Davis <sdavis2@mail.nih.gov>
1 sibling, 1 reply; 5+ messages in thread
From: Joshua D. Drake @ 2005-08-10 03:28 UTC (permalink / raw)
To: Sean Davis <sdavis2@mail.nih.gov>; +Cc: David <dbree@duo-county.com>; pgsql-interfaces
>>
>>Is PgPerl still viable or is DBD the way to go?
>
>
> DBD::Pg is the way to go, for numerous reasons. DBI is very well supported.
> More importantly, almost all database-related work is done by building on
> DBI. Interfacing your own code with those of others is then relatively
> straightforward. See, for some examples, DBIx::RecordSet or Class::DBI.
> Finally, if you every need to port to another database product (GASP!), DBI
> is fairly easy to adapt (depending on DB-specific SQL).
DBI/DBD is also what Perl considers standard.
Sincerely,
Joshua D. Drake
>
> Sean
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgperl vs dbd-perl
@ 2005-08-10 20:22 David <dbree@duo-county.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 5+ messages in thread
From: David @ 2005-08-10 20:22 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Sean Davis <sdavis2@mail.nih.gov>; David <dbree@duo-county.com>; pgsql-interfaces
On Tue, Aug 09, 2005 at 08:28:13PM -0700, Joshua D. Drake wrote:
> >>Is PgPerl still viable or is DBD the way to go?
> >DBD::Pg is the way to go, for numerous reasons. DBI is very well
> >supported.
> DBI/DBD is also what Perl considers standard.
>
> Sincerely,
>
> Joshua D. Drake
Well, it's still unanimous, and coming from people who have my respect.
Spent yesterday reading the DBD::Pg mailing list. Now plan on studying
the manpages for DBD and for DBI. It shouldn't be much of a chore
rewriting what little I've done so far into DBI code.
Thanks again to everyone who replied. Maybe I've already said it, but I
thought I was seeing just what all of you have said, but just wasn't
sure.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-08-10 20:22 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-09 14:45 pgperl vs dbd-perl David <dbree@duo-county.com>
2005-08-09 14:57 ` Sean Davis <sdavis2@mail.nih.gov>
2005-08-09 16:10 ` David <dbree@duo-county.com>
2005-08-10 03:28 ` Joshua D. Drake <jd@commandprompt.com>
2005-08-10 20:22 ` David <dbree@duo-county.com>
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