[sqlalchemy] Re: SqlAlchemy use in Twisted threads

2013-06-13 Thread writes_on
Hi all, Based on some comments here and in the SqlAlchemy IRC chat room, I've updated my decorator to make some changes. Here is the updated version: class ScopedSession(object): SESSIONMAKER = None # this is the single sessionmaker instance def __init__(self, engine,

Re: [sqlalchemy] Re: SqlAlchemy use in Twisted threads

2013-06-13 Thread Richard Gerd Kuesters
I'm glad you got a better solution. The key is now test it and see if memory leaks and connections get closed properly. The main problem in Twisted, IMHO, is the usage of maybeDeferred in some points, which can go to a thread or stay in the main thread, which is a little hard to predict and