SQLAlchemy—Turning SQL Lead into Python Gold
Over the years, the Zope community has created several approaches for integrating Zope 2 and relational databases. Let us briefly look at the most important ones:
- ZSQL methods are akin to Script (Python)’s or DTML templates and can be created through the Web or in a skin layer. Essentially, they provide a way to parameterize SQL queries and retrieve the results for processing in a page template. ZSQL methods are quite simple, but can be a little awkward to use with component-based program designs because they are used through skin layers only.
- Archetypes SQLStorage and its derivatives are a valiant attempt to let Archetypes content objects store their actual data in a relational database. A ZODB stub ...