[Zope-DB] RFC: mxODBCZopeDA & ZEO

[Charlie Clark]

On 2004-05-25 at 19:01:01 [+0200], Dieter Maurer <dieter at handshake.de> 
wrote:
> Charlie Clark wrote at 2004-5-24 19:48 +0200:
> > ...
> >Well, the following struck while we were testing and installing:
> >1) each Zope Product has to be installed and possibly configured locally
> 
> We let all hosts be servered via NFS (from the same source).

Yes, that makes sense. More difficult for products like mxODBCZopeDA to 
check licence use but heyho!

> >2) each DB has to be configured to accept connections from the various 
> >clients
> 
> We trust the remaining hosts at least as much as the Web gateway.
> The complete subnet has the same database access.

Yes, I imagine this would generally be the case.
 
> >3) heterogeneous clients may in some circumstances confuse each other
> >configuration
> 
> ???
> Avoid heterogenous clients?

In general, yes. In practice, in testing this wasn't possible and maybe not 
a bad thing to have done this: threw up a problem with possible iODBC and 
UnixODBC conflicts.

We still think that in such an environment it might still make sense to 
have a single connection object communicate with the database and are open 
for discussion on this and a possible ZSQL replacement together with other 
issues at EuroPython in two weeks.

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::