I have a question regarding the use of Sqlalchemy from mod_python. The question basically boils down to:
How will Sqlalchemy act when a request to add/delete/update a mapped object goes to any of 20 embedded python interpreters? The reason I ask is that I have just started using Sqlalchemy on a project and have noticed that after making a change on a mapped object, sometimes the expected result returns and sometimes not. An example: I delete a property of a mapped object, and then request a web page that lists all the mapped objects and their properties. The request can go to any of 20 apache processes, and when refreshing the list I sometimes get the expected results but other times the list show the property that should have been deleted. My initial feeling, after seeing this, was that Sqlalchemy may do some caching and depending on what apache process the request goes to, the object in that process my not be correctly synchronized. Thanks, Marek
