[sqlalchemy] Re: Guidance regarding nested session usage

2017-08-12 Thread alex
Thank you very much for the guidance Jonathan and Mike. I've implemented nesting counting on my context manager and turned off autocommit and subtransactions. It looks like it's working well! Alex On Wednesday, August 9, 2017 at 5:14:09 PM UTC+1, al...@withplum.com wrote: > > Hey, > > I'd lik

[sqlalchemy] Re: Guidance regarding nested session usage

2017-08-09 Thread Jonathan Vanasco
A similar question about another anti-pattern was asked/answered recently. Most of what Mike says applies in this use-case https://groups.google.com/forum/#!topic/sqlalchemy/W_Rn-EwKvZo especially the locking and integrity issues with long-running transactions. He's written about it elsewher