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(at)bugs(dot)unl(dot)edu(dot)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(at)unl(dot)edu(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

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