[Zope] Re: ZSQL with different user

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andreas Jung wrote:
> 
> 
> --On 19. Dezember 2005 15:32:46 +0100 Pier Luigi Fiorini
> <pierluigi.fiorini at yacme.com> wrote:
> 
>> Hello,
>> I'm developing a Zope application that uses a PostgreSQL connection and
>> several ZSQL objects.
>> People should log in using a Postgres user and ZSQL object should be
>> executed  by the user that's logged in. Multiple people can be logged at
>> the same time. Unfortunately it is not possible because the same Postgres
>> connection is used  by all the ZSQL object. Is there a way to change the
>> user executing a ZSQL  query?
>>
> 
> The short version: forget it. DA connections are tied to a particular user.
> Connections are persistent and shared across threads and requests. You
> really don't want to connect/re-connect for every request and user. You
> would have to implement your own connection management including connection
> pooling *somehow*.

Heh, one could create a user-specific connection and stash it in the
session. ;)  This would actually be a lot like what some of the more
RDB-centric web frameworks do already.


Tres.
- --
===================================================================
Tres Seaver          +1 202-558-7113          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDptj2+gerLs4ltQ4RAt3NAJ93414VDh+tOibJGXENarPaai1x1gCggOD6
sRvr/l2jNeYXaTExZm2A4Wg=
=zWbW
-----END PGP SIGNATURE-----