What's the difference between the two PostgreSQL perl client implementations DBD::Pg and DBD::PgPP?
Asked
Active
Viewed 234 times
-2
Kalle Richter
- 8,008
- 26
- 77
- 177
-
Why didn't you read the [documentation](https://metacpan.org/pod/DBD::PgPP)? – neuhaus Feb 10 '16 at 09:49
-
I wanted to answer the question myself... I guess I have to hit the checkbox when creating the question. – Kalle Richter Feb 10 '16 at 09:54
3 Answers
1
According to CPAN, DBD::PgPP is a pure Perl implementation of the PostgreSQL driver. DBD:pg has some low-level c implementation. If you need only Perl as a dependency, DBD::PgPP is worth looking at.
Alexander Fomichev
- 11
- 2
0
Use DBD::Pg if it's available, it will be faster than DBD::PgPP because some parts are implemented in C, whereas DBD::PgPP is pure perl (which is what PP stands for).
neuhaus
- 3,886
- 1
- 10
- 27
0
Summing up http://www.perlmonks.org/?node_id=457530:
DBD::PgPP pros:
- easier to install than
DBD::Pgbecause it doesn't depend on the external dependency - more up-to-date (see below)
- pure
perlimplementation
DBD::Pg pros:
- actively maintained by the PostgreSQL team
- has a more friendly PostgreSQL interface
- offers support for
COPY(see http://search.cpan.org/~turnstep/DBD-Pg-3.5.3/Pg.pm#COPY_support for details)
Kalle Richter
- 8,008
- 26
- 77
- 177