Re: Is my MySQL Gaining ?

Having worked with both MySQL and Postgresql, there is one thing that most 
people overlook with all the hoopla about new features in MySQL.  One that I 
find impacts my clients and helps with their decision to move to Postgresql.  
When using the new features on OLD MySQL databases, most of the time this means 
a major coversion.  You can't use the old "MyISAM" tables, you have to add the 
new features, use their new Innodb table structure, and write all the stuff 
anyway.  Add in the table redesign, and normalization that didn't happen 
originally and the decision about the database becomes a business decision, not 
a political argumen. My argument at that point is, "Postgresql was designed to 
do those things, they are not 'added features'.  They are new to MySQL and 
since you have to re-write anyway..."

So far, the clients have chosen Postgresql.  Many of them are frustrated with 
the lack of features in MySQL and simply are ready to move for the right 
reasons.  MySQL is great for a simple, fast, list manager, but once you start 
needing constraints, functions, or any other 'normal' database features it 
falls apart.  I think the Postgresql team is doing well, they focus on 
Postgresql, not what MySQL might do.

I say keep up the good work!
-- 
Ken Harris
Senior Consultant
http://www.lhinfo.com
(410) 597-8916



Quoting Martin Marques <martin@bugs.unl.edu.ar>:

> El Vie 26 Dic 2003 11:09, Sai Hertz And Control Systems escribió:
> > Dear all,
> > 
> > Their was a huge rore about MySQL recently for something in java functions
> > now theirs one more
> > 
> > http://www.mysql.com/doc/en/News-5.0.x.html
> > 
> > Does this concern anyone.
> > 
> > What I think is PostgreSQL would have less USP's (Uniqe Selling Points 
> > though we dont sell) now.
> > 
> > What do you think yes we PostgreSQL users need some introspection.
> 
> 1) This is in the 5.0.0 development tree, which could come out around..... 
> lets say 2 years maybe?
> 2) Stored Procedures with those features are already in PG long time ago, and
> 
> are getting optimized every new release.
> 
> -- 
> select 'mmarques' || '@' || 'unl.edu.ar' AS email;
> -----------------------------------------------------------------
> Martín Marqués                  |        mmarques@unl.edu.ar
> Programador, Administrador, DBA |       Centro de Telemática
>                        Universidad Nacional
>                             del Litoral
> -----------------------------------------------------------------
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/