Pycon: SQLAlchemy
The SQLAlchemy talk at Pycon just made a few things click for me. I didn’t really understand SQLAlchemy before, as evidenced by this previous post. The reason it didn’t click for me right away is because it’s not implementing the same pattern as most ORM’s I’ve used. Fowler’s active record pattern is what ORM’s like ActiveRecord, SQLObject and the Django ORM implement. SQLAlchemy implements the data mapper. Projects like elixir put an Active Record pattern on top of the data mapper.
So, a few pattern links and it all starts to make sense to me. Good presentation.