At PyCon, Mike Bayer , the author of SQLAlchemy, gave a three hour tutorial on it. Here's the video . What follows are my notes. He used something called sliderepl. sliderepl is a nice ASCII tool that's a mix of slides and a REPL. You can flip through his source code / slides in the terminal. It's actually pretty neat. At the lowest level, SQLAlchemy sends strings to the database and interprets the responses. It took him 10 years to write it. He started the project in 2005. He's finally going to hit 1.0. SQLAlchemy forces you to be aware of transactions. Isolation models have to do with how ongoing transactions see ongoing work amongst each other. Goals: Provide helpers, etc. Provides a fully featured facade over the Python DBAPI. Provide an industrial strength, but optional, ORM. Act as a base for inhouse tools. Philosophies: Make the usage of different DBs and adaptors as consistent as possible. But still expose uniqu
Ad maiorem Dei gloriam inque hominum salutem.