Databases: Which one's right for me?

Aaron Watters aaron at
Mon Jan 12 02:12:46 CET 2004

"Tim Peters" < at> wrote in message news:<mailman.284.1073847641.12720.python-list at>...
> [Aaron Watters]
> > BTW, I would like to see somewhere an explanation of how
> > ZODB concurrency control and recovery work.  Please inform if
> > there is some information.  I'm not encouraged by the fact that
> > in what documentation I can find the definitions are not the
> > standard ones.
> Of course you're much more likely to get a useful discussion of this on a
> ZODB list, like <mailto:zodb-dev at>.
> "The standard" ones aren't all that standard.  ANSI SQL-92 defines multiple
> isolation levels, and they've been (I think) fairly critiqued as  incomplete
> and partly ambiguous; e.g.,
>     A Critique of ANSI SQL Isolation Levels
>     Hal Berenson, et al.

Some SQL isolation levels are hacks to allow long running transactions,
etcetera.  If you keep to the strictest isolation level you get the
classical behaviour which has been studied and elaborated by many very
smart people over the last several decades and which is very well

Does ZODB support the strictest isolation levels?  If so how?  If not
what does it support exactly?
   -- Aaron Watters
We'll make our way across the galaxy
And head back home on the L.I.E.
   -- "Laser show", Fountains of Wayne

More information about the Python-list mailing list