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

Chris McDonough chrism@digicool.com
Thu, 31 Aug 2000 17:22:06 -0400


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
>