Blue Sky On Mars

SQLAlchemy, which was announced a couple months back and has been busy in svn, has now had its first release. Congrats to Mike Bayer on that! SQLAlchemy is an object-relational database mapper that uses the data mapper pattern. This is in contrast to SQLObject and ActiveRecord which use the active record pattern. Also interesting for SQLAlchemy, is that Jonathan LaCour’s declarative layer effectively gives you active record-style mapping. The data mapper pattern works well for more complicated databases or bigger databases because it lets you be more explicit about what you want to pull from the database and how you want it to show up in your objects. That flexibility also makes it more complex for simpler tasks. That’s why I think that Jonathan’s ActiveMapper strikes a nice compromise.