Actually, MySQL itself does not support transactions, and, from what I can
tell, it never will. Berkeley DB, though, does support transactions ...
what MySQL has done is provided an SQL interface over top of Berkeley DB
files to give the *appearance* of transactions ...
Basically, MySQL remains a "flat file database with an SQL front
end" ... *shrug* They couldn't even do it on their own, they had to get
a third party software package to do it for them. Which, for them, is
good ... Berkeley DB v3.1.14(?) had a corruption problem that was fixed in
subsequent releases ... if you tried to use that for your transaction(s),
you couldn't blame MySQL for the problem, since it wasn't their code
... plausible deniability ...
On Tue, 19 Sep 2000, Jeff MacDonald wrote:
> ---------- Forwarded message ----------
> Date: Tue, 19 Sep 2000 13:15:32 -0700 (PDT)
> From: Vince LaMonica <Vince.LaMonica@quest.com>
> To: Linux <linux@ilender.com.pe>
> Cc: paul@ywebwerks.com, php-db@lists.php.net
> Subject: RE: [PHP-DB] Interbase or MySQL ???
>
> } From: Paul A. Owen <paul@ywebwerks.com>
> } To: <php-db@lists.php.net>
> } Sent: Friday, September 15, 2000 12:47 PM
> } Subject: Re: [PHP-DB] Interbase or MySQL ???
> }
> }
> } > > What database will you choose if money doesn't matter?
> } >
> [snip]
> } > However, PHP support is a little immature right now but things are
> } > improving. MySQL is very basic with no procedure or transaction support.
>
> MySQL *does* support transactions. I really wish folks would stop telling
> others it doesn't, as it has since 3.23.17 at least. Transaction support
> isn't as complete as it is in Oracle, but it does match PostgreSQL.
>
> Check out
> http://www.mysql.com/documentation/mysql/commented/manual.php?section=Compare_PostgreSQL
>
> for a good comparison of the two [even though this is on the mysql site,
> it does list things that postgre can do that mysql can't].
>
> /vjl/ [who's just now getting e.mail sent to the list from last week!]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org