[Pypgsql-users] Re: PostgreSQL Interface Query

[Stuart B. <ze...@sh...>]

On Saturday, October 13, 2001, at 10:11  PM, Gerhard H=E4ring 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 :-)

--
Stuart Bishop <ze...@sh...>