[Zope] SQL and Python Products

2013-01-16 Thread Luiz Pasqual
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: l...@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 )


Re: [Zope] SQL and Python Products

2013-01-16 Thread Niels Dettenbach
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
 ---
 





signature.asc
Description: This is a digitally signed message part.
___
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 )


Re: [Zope] SQL and Python Products

2013-01-16 Thread robert rottermann

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: l...@pasquall.com mailto:l...@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 )


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