News for hackers. Stuff that matters.
Re:Fixing Database Connections in Django by zzzeek on Friday March 08, 2013 @05:12PM (#5346064)
the SQLAlchemy connection pool (which is what this is using) calls connection.rollback() when the connection is checked back in. as far as "leaking" transactional state it's not different from "autocommit", which is what Postgresql connections normally do (and what psycopg2 will do if you set `connection.autocommit=True`).
Re:Fixing Database Connections in Django by rosser on Friday March 08, 2013 @05:24PM (#5346143)
How is a connection "checked back in"?
Re:Fixing Database Connections in Django by zzzeek on Friday March 08, 2013 @05:58PM (#5346309)
the pool is transparent around acquisition and release:

    conn = pool.connect()
    conn.close()
the above "close()" is a release/checkin.