Pycon Canada – the SQLAlchemy Session In Depth

Video is up for my Pycon.ca talk, The SQLAlchemy Session – In Depth.
In this talk, I delve into the key philosophies behind the design of SQLAlchemy’s Session system.
Starting with a brief review of the ACID model, I contrast the approach of the so-called “active record”
pattern to that of the more explicit Session pattern, and how the two approaches integrate with the
ACID model at work within a relational database. Afterwards, I present an HTML animation of a Session
object at work.