Mailing List Archive: SQL and Python Products

SQL and Python Products

Jan 16, 2013, 10:34 AM

Post #1 of 3 (1307 views)

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

Re: SQL and Python Products [ In reply to ]

nd at syndicat

Jan 16, 2013, 11:28 AM

Post #2 of 3 (1262 views)

Permalink

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.

--
---
Niels Dettenbach
Syndicat IT & Internet
http://www.syndicat.com
PGP: https://syndicat.com/pub_key.asc
---

Re: SQL and Python Products [ In reply to ]

robert at redcor

Jan 16, 2013, 1:26 PM

Post #3 of 3 (1259 views)

Permalink

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 )

Mailing List Archive

Mailing List Archive

Attached Files: