O'Reilly logo

Professional Plone Development: Building robust, content-centric web applications with Plone 3, an open source Content Management System by Martin Aspeli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required