Hi Julien, I also use mod_python in the following way: my handler that is decorated with my decorator: @orm_persistent that opens a session and eicher in finally or tin the except block always closes the session, so I can always be sure not to forget to close a session. Of cource I can forget the decorator itself ;-)
For sharing the session object between the apache processes I have not Idea. But if it is the same thread you could use threadlocal. Alex. On 8/8/06, Julien Cigar <[EMAIL PROTECTED]> wrote: > Hello list, > > I'm using SQLAlchemy with apache/mod_python (prefork) and a custom > mod_python handler. I was looking for a solution to share the session > object between the apache processes. > > At the moment I have a session object per process (which work fine), but > I have to close / reopen the session object for each request which is > not optimal ... and can cause a lot of problems if I forget to close the > session at the end of a request, for example if I modify an object in > the session of a process which is still persistent (cached) in the > session of another process, etc ... > > I plan to use either shared memory (no experience with this at the > moment) or memcached which look nice. Do you have any suggestion or > another solution for this ? > > Thanks, > Julien > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
