[Zope] MySQL - PostgreSQL - ZODB

[Shane Hathaway]

Monty Taylor wrote:
> 
> Possibilities for flaming aside, I must say that I break from the
> pervasive attitude of Zope culture and defend MySQL a bit.

As I see it, it is sensible to choose MySQL over an ACID-compliant
database when you'll be performing 99.9% read operations.  The
comparison charts on mysql.com, astounding as they are, appear to be
correct.  MySQL is indeed very fast, especially compared with
PostgreSQL.

However, using MySQL, if someone is writing to multiple tables in the
database while someone else is reading it, the database will not appear
to be consistent to the reader until the write operation is complete. 
That is not a bug.  It is part of the design of MySQL.  Apparently
MySQL is faster because of it.

So, as always, choose your database wisely.  If you want another
chaotic but high-capacity Slashdot, use MySQL.  If you want perfect
integrity even during an onslaught of write operations, use something
else.

It is also my understanding that Zope, when it is capable of using an
SQL database as its primary storage, will not be tied to any specific
database type.

Shane