[sqlalchemy] sessions and threads

Hi all, Seems I can't do session.query in anything other than the main thread. I'm using SQLite, and I'm not sure if it's a problem with that or SQLAlchemy it's self. Is there any kind of work around for this? Cheers, -- You received this message because you are subscribed to the Google

Re: [sqlalchemy] sessions and threads

On 7/24/15 4:14 PM, 'Chris Norman' via sqlalchemy wrote: Hi all, Seems I can't do session.query in anything other than the main thread. I'm using SQLite, and I'm not sure if it's a problem with that or SQLAlchemy it's self. Is there any kind of work around for this? Unfortunately the

[sqlalchemy] Sessions and threads, find in one thread, use in another

In my current application I am running a rather expensive query in a background thread, but then I need to use the results in the foreground thread. The object I find has a great deal of lazy evaluated properties that link it to several other mapped objects. As it stands now, the application is