[DB-SIG] Popy - Psycopg - PyPgSQL - PyGreSQL
Tue, 1 Oct 2002 10:45:59 +0200
I am using psycopg module to access PostgreSQL in Python.
It is fast, is DBAPI-2.0 compliant, I have never encountered any bugs
I am using it for couple intranet sites in my company, and it has never
failed me. The environment it works in is Apache, mod_python, Python,
psycopg and PostgreSQL for completely dynamic sites with about 10000
requests served daily.
I am not saying that it is best, however my advice is not to use Python
module supplied with PostgreSQL sources...
Senior system analyst
TietoEnator Financial Solutions
41 Lacplesa Str.
Riga, LV-1011, Latvia
Tel: +371 7286660
Fax: +371 7243000
> -----Original Message-----
> From: firstname.lastname@example.org
> [mailto:email@example.com]On Behalf
> Of Federico Di Gregorio
> Sent: pirmdiena, 2002. gada 30. septembr=CF 19:29
> To: Python DB-SIG Mailing List
> Subject: Re: [DB-SIG] Popy - Psycopg - PyPgSQL - PyGreSQL
> 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 or
> > 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
> 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
> 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
> INIT.D Developer
> God is real. Unless declared integer. -- Anonymous FORTRAN