[sqlalchemy] Re: 2 Sessions with same object...how do they interact?

I am using SQLite. I can see the COMMIT, and there is only one. The SQL log shows that the COMMIT is immediately followed by a retrieve of the same row, but it's retrieving a value that was flushed ( but not committed ) from a different session! So, are these 2 sessions connected to the same

Re: [sqlalchemy] Re: 2 Sessions with same object...how do they interact?

SQLite uses the singleton thread pool by default which shares one connection per thread.This so that a :memory: connection works as expected. There's a good deal of discussion and advice on this topic at