Absolutely! Here's what I think needs to be done: - finalize the recommended table structures - come up with as-generic-as-possible SQL queries for use in each Storage method that is anticipated to be used by this storage. - make sure the current table structure doesn't neglect to anticipate versioning and undo Though this should be abstracted to be able to use any SQL database, I had anticipated developing this against Oracle (using DCOracle) initially. Is this a problem for you?

-----Original Message----- From: Jonothan Farr [mailto:jfarr@real.com] Sent: Wednesday, May 03, 2000 3:27 PM To: Chris McDonough; Jason Spisak Cc: zope@zope.org Subject: Re: RelationalStorage (was LocalFS)

...

I've put some stuff about a proposed RelationalStorage in the ZODB wiki at http://www.zope.org/Members/jim/ZODB

Its goal is to allow you to use a SQL database as a Storage, which somewhat coincidentally would also get around the single-file 2GB limitation.

I would appreciate comments (in the wiki or here). The table structure I'm not sure on, it's only a skeleton right now...

I like it. I'm much more interested in working on this than a FileSystem storage, for different reasons. Care to collaborate?

--jfarr