[Pypgsql-users] Problems with the Zope PyPgSQL adaptor

[charlie c. <ch...@be...>]

Dear list,

I've been looking for a Python driver for PostgreSQL support and it seems 
that PyPgSQL is currently the only one to offer this. The driver seems to 
work fine so I tried the ZopeDA from CVS. This seems to have several 
problems: first of all I was not able to set up a connection using 
standard parameters:
e.g dbname=charlie host=localhost as the connection string
I get an error complaining that the database "dbname=charlie" doesn't 
exist. So I've hard-coded the connection string in db.py. It might be nice 
to know what I'm doing wrong.

The other error is that with or without unicode supports, result sets seem 
to have some kind of memory problem. Testing a single SELECT causing my 
system to run out of memory with Python swelling to well over 150 MB 
(probably more if I had the resources) and pg_ctl crashing at some point 
being unable to allocate heap to the child. I thought this might be 
related to unicode but it isn't.

System: Zope 2.6.2 (binary release, python 2.1, win32-x86), python 2.1.3, 
win32), PostgreSQL 7.4.1 for cygwin.

Any ideas?

Charlie

-- 
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D-40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226