[DB-SIG] Popy - Psycopg - PyPgSQL - PyGreSQL

Federico Di Gregorio fog@initd.org
30 Sep 2002 19:29:24 +0200

Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Il lun, 2002-09-30 alle 19:11, Marcelo Pereira ha scritto:
> Hi there (again),
> I have download these Python interfaces to PostgreSQL and I haven't find
> any documentation (just some examples, basic and advanced, but just
> examples).
> Which is the better one?? (I know this is a question like:  "PostgreSQL o=
> MySQL",  "RedHat or Slackware", "Vi or Emacs", ..., or another religious
> question...) I just want to know which is more efficient.

i can't say "this one is better" but i can say that psycopg is very
solid and almost bug-free. it is also quite fast (it was designed for
speed) but i never tried a benchmark, mainly because i think benchmarks
should be done on real-world cases. note that i am its main author,
maybe you want to wait for others' module authors to speak on this list
before going for it.. :)

> Which module do you use? I would be happy if I had a reference manual
> (from any one: Popy, Psycopg, PyPgSQL or PyGreSQL).

they all implement the dbapi-2.0 to some extent, so you should be fine
by just reading the PEP. psycopg has a lot of example code in
doc/examples/ and support some nice dbapi-2.0 extensions like connection
pooling, user-defined typecasters (to conver postgres data ti python
objects), etc.

hope this helps,

Federico Di Gregorio
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
INIT.D Developer                                           fog@initd.org
   God is real. Unless declared integer. -- Anonymous FORTRAN programmer

Content-Type: application/pgp-signature; name=signature.asc

Version: GnuPG v1.2.0 (GNU/Linux)