[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.