[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Re: Getting started with Postgres or MySQL

On Thu, Feb 01, 2007 at 04:37:39PM -0500, Angelo Bertolli wrote:
> The fundamental difference is licensing.  If Windows was open source, I 
> certainly wouldn't bother disagreeing with them if they specified which 
> users would benefit more from Windows.  And on that issue MySQL wins 
> because you can have it under the GPL.  Postgres is under BSD. (I guess 
> that's arguable, but we are on a Debian list after all.)
It depends on whether your definition of "freeness" is biased toward
developers or end users.

Basically, on technical merits, MySQL benefits practically nobody.

> (By the way, you actually get different transactional results based on 
> what kind of storage you tell MySQL to use.  InnoDB is better but slower 
> than MyISAM.  Gee, I wonder if there could be a tradeoff there.)
Yes, because MyISAM is *not* transactional at all.  Not just that, but
if you have a query/transaction that involves upty-bazillion InnoDB
(transactional) tables and only *one* MyISAM table, then the *entire*
query/transaction is *not* transactional.

> MySQL got the upper hand for having "better" priorities early on, and 
> now they're enjoying their popularity.  It didn't really matter that 

Yes, they were "fast" when computers were still slow.  Unfortunately,
many people were willing to give up data integrity in exchange for



Roberto C. Sanchez

Attachment: signature.asc
Description: Digital signature

Reply to: