Yep I'm doing something like this too at the moment, but it's a bit a pity to not use the persistent/caching functionality of the SQLAlchemy sessions and every time reload data (objects) from the database, even if they haven't changed ...
I made some basic tests with memcached and it *seems* to work ... Regards, Julien Alex Greif wrote: > 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
