Just a few days ago, I was talking about how much I enjoy PySqlite, and now I’ve found another great tool for my SQL war chest. SQLAlchemy
I am already using it for another part of a big multi-database reporting project. The fun part for me is that it is more modular and less demanding of structure than SQLObject, so I can actually use its superior raw SQL connection and marshalling capabilities for manual report queries, while continuing to utilize my SQLObject enabled object model.
Very sweet, and very quick to get going on my Mac development and Linux deployment environments. I’m currently collecting data from three different databases (SQLite, PostgreSQL, and MySql) on five different servers. This is a killer app for me.
I’ll be exploring its object-relational capabilities soon, but I am already very fond of the framework, and how lightweight it feels.