[Zope] Summary of DB Discussion

Phillip J. Eby pje@telecommunity.com
Wed, 10 Nov 1999 11:07:18 -0500


At 09:21 AM 11/10/99 -0600, Karl Fast wrote:
>On Wed, Nov 10, 1999 at 09:46:43AM -0500, Phillip J. Eby wrote:
>> 
>> Could anyone point out where the "real soon now" is on the site?  Every
>> time I've ever looked at the site it has said that they have no plans to
>> implement fully ACID transactions, ever.
>
>
>This page has a list of things they want to do, broken down into 3 sections:
>
> 1. Things that must be done in the real near future
> 2. Things that have to be done sometime
> 3. Something we don't have any plans to do
>
> http://www.mysql.com/Manual_chapter/manual_TODO.html#TODO
>
>
>Under #1 the first two items are "one way replication" and "transactions"
>
>Under #3 there is only one entry:
>
>  "Transactions with rollback (we mainly do SELECTs, and because we don't do
>  transactions, we can be much quicker on everything else). We will support
>  some kind of atomic operations on multiple tables, though. Currently
>  atomic operations can be done with LOCK TABLES/UNLOCK TABLES but we will
>  make this more automatic in the future."
>

That's the kicker.  If you don't have rollback, how can you call it a
transaction???  Seems to me, that to work with Zope, you need to be able to
roll back the transaction if anything on the Zope side fails.