Re: [Pypgsql-users] Re: PostgreSQL Interface Query

[Gerhard <ger...@gm...>]

On Sun, Oct 14, 2001 at 03:18:55PM +1000, Stuart Bishop wrote:
> 
> On comp.lang.python at October 13, 2001, at 10:11  PM, Gerhard Häring wrote:
> 
> > On Sat, Oct 13, 2001 at 03:08:46PM +1000, Stuart Bishop wrote:
> >> On Saturday, October 13, 2001, at 02:05  PM, John Bell wrote:
> >>> [...]  I am leaning towards pypgsql [...]
> >>
> >> I got as far as checking its threadsafety - level 1 compliance
> >> is a major lack to me.
> >
> > I will look into the thread level compliance thing, but for now I only
> > remember a message from the main developer Bill Allie, which sounds
> > reasonable to me:
> >
> > http://mail.vex.net:99/pipermail/pygresql/2001-July/000420.html
> 
> If the PostgreSQL connection provided to you is not thread safe, then
> there is nothing stopping you using locking *inside* your connection
> object. The API says 'use a resource without wrapping it using a mutex
> semaphore', which is from the users perspective (the 'use' is the keyword
> - the connection is the resource).
> 
> And now that Gerhard's email made me realise that threadsafety level 1
> *is* perfectly good for Zope (I was counting from 1, not from 0), I have
> yet another postgres adaptor to evaluate :-)

Cool :-) There isn't an "official" ZOPE database adapter using pyPgSQL
at the moment. There will be one as a subproject of pyPgSQL soon,
however. At least as a development version in CVS.

A sneak preview of it and my experiments with Windows installers is
available at my homepage (sig). Btw. I will change the license from BSD
back to ZPL. I'm not sure if I really have to, but this is to be on the
safe side.

Oh, btw. it's based on the one from psycopg project and I only hacked it
for pyPgSQL.

Stay tuned :-)

Gerhard
-- 
mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20  A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))