mysql 5.0 released

[Bill Campbell]

On Wed, Oct 26, 2005, David A. Bandel wrote:
>Regurgitating the prose of Man-wai Chang Man-wai Chang
><mwchang at i-cable.com> on Wed, 26 Oct 2005 19:31:22 +0800: begin  
>|
>|Would it pass the ACID test?
>|
>
>Probably no.  Does it have transactions?

Yes.  I'm pretty sure that MySQL has had transactions since version 4.0.
We are using postgresql though because it is a far more mature product that
MySQL and doesn't have the somewhat wierd licensing of MySQL (and see
innodb comments below)

On the other hand, MySQL is frequently used in web applications because
it's light weight and fast.

And on yet another hand, I tend to avoid x.0 releases as they frequently
have more bugs than later releases in the same version.

>On a related note, Oracle bought InnoDB after MySQL declined the
>offer.  Oracle says it will negotiate InnoDB pricing with MySQL.
>InnoDB could have been MqSQL's savior.
>
>Also lacking:  left (right) outer joins, more.  
>
>MySQL (like Windoze) is not ready for prime time.

I think that's a bit harsh considering (a) the number of sites
using MySQL, and (b) it has had orders of magnitude fewer security
problems that Windows.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

The pinnacle of open systems is: when moving from vendor to vendor, the
design flaws stay the same.