[Zope-ZEO] ZEO/ZODB and SQL/ODBC storage manager?

[Paul Everitt]

Hello David.  I'll tip our hand and tell you that an announcment about
an OracleStorage is imminent.

Chris is right, the potential for a generic backend is nill.  SQL is a
great standard, available in different flavors for every database.  Even
things like dates are inconsistent.  Since the needs of a storage are
pretty intense, we'll be doing per-database storages.

--Paul

> -----Original Message-----
> From: Chris McDonough [mailto:chrism@digicool.com]
> Sent: Thursday, August 31, 2000 2:22 PM
> To: 'David Bolen'; 'zope-zeo@zope.org'
> Subject: RE: [Zope-ZEO] ZEO/ZODB and SQL/ODBC storage manager?
> 
> 
> No.  It would be nice, but I don't think there is such a thing as a
> generic SQL backend...  every relational-db backed storage 
> will need to
> have slightly different semantics and syntax.  For rationale, see
> http://www.zope.org/Members/jim/ZODB/RelationalStorageDiscussion.
> BerkeleyStorage is an entirely different animal, and is even more
> different than any relational storage would be.
> 
> > -----Original Message-----
> > From: David Bolen [mailto:db3l@fitlinxx.com]
> > Sent: Thursday, August 31, 2000 5:07 PM
> > To: 'zope-zeo@zope.org'
> > Subject: [Zope-ZEO] ZEO/ZODB and SQL/ODBC storage manager?
> > 
> > 
> > I've been looking into using ZEO/ZODB as part of a non-Zope Python
> > application.  I'm primarily interested up front in its use as 
> > a distributed
> > persistent object store, but the objects in the application 
> > are likely to be
> > created/deleted/changed more frequently than you might see in 
> > terms of a
> > typical Zope web setup, so FileStorage isn't something I'm 
> > sure I want to
> > use.
> > 
> > I'd just like to double check my understanding given 
> > searching around in the
> > currently listed products and documentation - there doesn't seem to
> > currently exist a storage product that assumes a generic 
> > SQL/ODBC back-end,
> > right?  I found the berkeley storage module (although it's 
> > for Sleepycat 2
> > vs 3) and the Interbase module which is close but I'd 
> > probably have to work
> > on a bit for a different database.
> > 
> > Thanks.
> > 
> > -- David
> > 
> > /-------------------------------------------------------------
> > ----------\
> >  \               David Bolen            \   E-mail: 
> > db3l@fitlinxx.com  /
> >   |             FitLinxx, Inc.            \  Phone: (203) 
> > 708-5192    |
> >  /  860 Canal Street, Stamford, CT  06902   \  Fax: (203) 
> > 316-5150     \
> > \-------------------------------------------------------------
> > ----------/
> > 
> > _______________________________________________
> > Bug reports, feature requests, etc. go in the ZEO Tracker:
> > http://www.zope.org/Products/ZEO/Tracker
> > 
> > Conversations etc. can take place in the Wiki:
> > http://www.zope.org/Products/ZEO/Wiki
> > 
> > Zope-ZEO maillist  -  Zope-ZEO@zope.org
> > http://lists.zope.org/mailman/listinfo/zope-zeo
> > 
> 
> _______________________________________________
> Bug reports, feature requests, etc. go in the ZEO Tracker:
> http://www.zope.org/Products/ZEO/Tracker
> 
> Conversations etc. can take place in the Wiki:
> http://www.zope.org/Products/ZEO/Wiki
> 
> Zope-ZEO maillist  -  Zope-ZEO@zope.org
> http://lists.zope.org/mailman/listinfo/zope-zeo
>