[Zope] MySQL and/or ZODB

Andrew Kenneth Milton akm@theinternet.com.au
Fri, 12 Oct 2001 23:30:10 +1000


+-------[ Chris Withers ]----------------------
| 
| 
| Luis Neves wrote:
| > 
| > > > or needs to be supported by ACID - then a RDBMS is for you.
| > >
| > > In what way is ZODB not ACID compliant?
| 
| > (...) The ZODB provides 3 of the ACID properties. Only Consistency is not
| > supported; the ZODB has no notion of a database schema, and therefore has no
| > way of enforcing consistency with a schema.
| 
| So, what would you propose changing to make ZODB ACID compliant in this sense?
| (Although I'm not sure ACID consistency is relevent here...)

I don't think you'll ever manage referential integrity with ZODB. It's a
Persistent Object Store, not a relational database. I really don't know why
people have a problem with this concept, and feel the need to enforce some
other meaningless (in this context) construct onto it. (Actually I do know
why, but, I feel the need to postulate).

Perhaps we should rename it from ZODB to ZOS, to stop people from drawing that
inference. People might think it was an operating system I suppose.

-- 
Totally Holistic Enterprises Internet|                      | Andrew Milton
The Internet (Aust) Pty Ltd          |                      |
ACN: 082 081 472 ABN: 83 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au|