[ZODB-Dev] A different sort of ZODB backend

[Itamar Shtull-Trauring]

Consider a PySQLite database with the following schema (see
http://pysqlite.sourceforge.net/documentation/pysqlite/node10.html for
the reason I specifically chose PySQLite).

Objects table has columns: oid, className, dictID [points to Dicts
table]
Lists table: lid, index, valueType, value
Dicts table: did, attributeType, attribute, valueType, valuevalueType,
value

The result is a ZODB storage that can be queried and updated using SQL.
You can I think add indexes for specific attributes on specific object
types as well, but it's too late for me to be sure.

A number of questions:
1. Does this make sense at all? (it's 2am :)
2. Is ZODB4 stable and usable enough that I can think of making such a
backend for it, and if so are the interfaces in place that will allow
this sort of thing?

Please CC me on answers, I'm not a subscriber.

-- 
Itamar Shtull-Trauring    http://itamarst.org/
Available for Python, Twisted, Zope and Java consulting
***> http://VoteNoWar.org -- vote/donate/volunteer <***