Mailing List Archive: Zope: Users

SQL and Python Products

Index | Next | Previous | View Threaded

luiz at pasquall

Jan 16, 2013, 10:34 AM

Post #1 of 3 (270 views)
Permalink

SQL and Python Products

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 [at] pasquall

nd at syndicat

Jan 16, 2013, 11:28 AM

Post #2 of 3 (239 views)
Permalink

Re: SQL and Python Products [In reply to]

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

Attachments:

signature.asc (0.82 KB)

robert at redcor

Jan 16, 2013, 1:26 PM

Post #3 of 3 (236 views)
Permalink

Re: SQL and Python Products [In reply to]

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 [at] pasquall <mailto:luiz [at] pasquall>
>
>
> _______________________________________________
> Zope maillist - Zope [at] zope
> 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 )

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads