[Zope] Database connectors

[Chris Withers]

Dario Lopez-Kästen wrote:
> yes, we sometimes get deadlocks in the database, net outages and general
> misbehavior of DCO2. This is on zope2.6; we have not been able to use
> ChrisW's latest modifications to the the python side of DCO2, because
> for our use cases it hanged even worse. 

Indeed, I needed solid reproducible test cases and my expertise in 
generating these in the weird world of Zope 2's DA's was not so good 
back then ;-)

> If everything goes the way I want, we will not be using neither ZSQL not
> DCO2 connections in the future; we will use SQLAlchemy to create a
> standard python library that connects to the database with cx_Oracle,
> and zope will only see Python objects from our custom library. The
> library will manage the connections to Oracle, and be independent of
> ZODB transactions (more or less).

This sounds like an excellent plan, and one which I'm hoping to explore 
with a pure Zope 3 project I'm working on.

I'd recommend having a look at this:

http://svn.zope.org/z3c.zalchemy/

...which should still mean you don't have to worry about transactions :-)

cheers,

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk