Hi,
We are trying to migrate a very old application on Zope 2.9, first we thought to migrate to Python Products and then upgrade Zope.
We don't know what's the best way to deal with SQL querys in Python products. He is some options we are evaluating:
- SQLAlchemy, leaving behind ZSQLMethods e Zope DA's - Psycopg - Python code access a Zope DA inside Zope
So, what you guys think?
Thanks.
Am Mittwoch, 16. Januar 2013, 16:34:01 schrieb Luiz Pasqual:
We are trying to migrate a very old application on Zope 2.9, first we thought to migrate to Python Products and then upgrade Zope.
We don't know what's the best way to deal with SQL querys in Python products. He is some options we are evaluating:
- SQLAlchemy, leaving behind ZSQLMethods e Zope DA's
- Psycopg
- Python code access a Zope DA inside Zope
So, what you guys think?
I mainly use MySQL with Zope with the ZMySQL Database Adapter... Not shure if that something you're looking for.
hth best regards,
Niels.
Hi Luiz, use sqlalchemy together with z3c.saconfig. Powerfull, flexible, easy to use ..
And in martin aspelis book is a chapter how to use them ..
robert
On 01/16/2013 07:34 PM, Luiz Pasqual wrote:
Hi,
We are trying to migrate a very old application on Zope 2.9, first we thought to migrate to Python Products and then upgrade Zope.
We don't know what's the best way to deal with SQL querys in Python products. He is some options we are evaluating:
- SQLAlchemy, leaving behind ZSQLMethods e Zope DA's
- Psycopg
- Python code access a Zope DA inside Zope
So, what you guys think?
Thanks.
-- Luiz Fernando Pasqual S. Souza mail: luiz@pasquall.com mailto:luiz@pasquall.com
Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )