Chapter A.6. Should I Use SQLAlchemy or SQLObject?
Philosophically, we try to present one way to do common tasks with TurboGears. But, there are two places where we need to deviate from that:
There are some less-common needs that need to be accommodated.
A new “best†approach is discovered.
SQLAlchemy is supported in TurboGears for both of these reasons.
If you are connecting TurboGears to a legacy database, you will find that SQLAlchemy can handle a much wider variety of potential schemas. If you have specific performance constraints, SQLAlchemy also makes it easier to optimize the SQL that is produced while still maintaining database independence and a Python feel.
We think that SQLAlchemy is maturing into the best database access layer ...
Get Rapid Web Applications with TurboGears: Using Python to Create Ajax-Powered Sites now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.