[Zope] zope as databasefrontend?

Dieter Maurer dieter@handshake.de
Sun, 26 Aug 2001 00:28:31 +0200 (CEST)


Ralf Duda writes:
 > ....
 > A user logged in and then the database connection would be established,
 > with the username/password and of course the right database permissions.
 > This connection should be open until the user logout. :)
 > 
 > I haven't found any hind on this kind of connection. (Late database
 > connection)
 > In general, is it possible to do it?
There are several reasons why this is not standard:

  *  opening a connection is expensive
     you may not want it for each user.

     Note that connections are thread-local objects.
     Therefore, each thread will have such a connectioon
     (at least in the worst case).

  *  It is unclear when a user logs out (he may never do this
     explicitely; just switches off the computer, logs in again

 > Must it realized it completely in a extra phyton script? (sounds
 > complicated)
I fear so: an External Method or a Python Product.


Dieter