[Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

Andreas Jung lists at zopyx.com
Mon Mar 26 01:07:34 EDT 2007



--On 25. März 2007 23:54:14 +0200 Maciej Wisniowski 
<maciej.wisniowski at coig.katowice.pl> wrote:

>> In the Zope 2 worlds we have dedicated database adapters
>> for different databases. Fortunately the Python world made us a
>> wonderful present called SQLAlchemy that abstracts the different
>> databases. In the Zope world we have some wrappers like
>> z3c.zalchemy and z3c.sqlalchemy... basically they deal with connection
>> handling, mapper handling and integration with the Zope transaction
>> system. Would it make sense to replace all different Zope DAs with
>> a generic DA on top of one of the z3c.* wrappers? I think it would not
>> be too hard to write such a DA...or am I missing something? Thoughts?
>
> Now (in Zope2) we have things like ZOracleDA (DCOracle2), ZPsycopgDA
> etc. that are adapters to these specific databases. They're based on
> Shared/DC/ZRDB/.
> In Zope3 there are also such adapters eg. one using cx_Oracle. They're
> based on Zope3 rdb module.
>
> What do you mean by 'replacing' them? You want wrapper build for
> z3c.* to be used instead of ZRDB (rdb)?
>
> You're talking about Zope2 or Zope3 too?

The subject says Zope 2:-)

-aj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope-db/attachments/20070326/f0ec829a/attachment.bin


More information about the Zope-DB mailing list