We are building web applications since the mid-90s with Python. Historically, we have used a
SQLAlchemyDA - a new unified database adapter for Zope 2
SQLAlchemyDA is a generic database adapter for Zope 2. Its goal is to provide RDBMS support for all databases supported by SQLAlchemy through one DA instead having a dedicated DA for every database type. SQLAlchemyDA is based on my package z3c.sqlalchemy. Right now the project is in an early stage (basically the result of a half day of work) however you can already use it with ZSQL methods....more to come.