[DB-SIG] pypg pure Python db driver for Postgresql

Stephane Bortzmeyer bortzmeyer at nic.fr
Wed Jul 13 16:04:41 CEST 2005


On Tue, Jul 12, 2005 at 11:41:43PM -0500,
 Randall Smith <randall at tnr.cc> wrote 
 a message of 52 lines which said:

> I put in ident support and Unix socket support as well as taking the
> username from the process when it is not specified.

OK, it works much better now.

Performance tests can be done and they seem to show that pypg is
slower but you may decide by yourself if it is *too* slow:

% python test.py                       
Result with <module 'psycopg' from '/usr/lib/python2.3/site-packages/psycopgmodule.so'>
100 repetitions:
INSERT: 0.4 msec/pass
SELECT (with join): 0.6 msec/pass
DELETE: 0.3 msec/pass

% python test.py                       
Result with <module 'pypg' from '/usr/local/lib/python2.3/site-packages/pypg/__init__.pyc'>
100 repetitions:
INSERT: 0.7 msec/pass
SELECT (with join): 1.1 msec/pass
DELETE: 0.6 msec/pass


More information about the DB-SIG mailing list