On 2/20/07, gustavo halperin <ggh.develop@gmail.com> wrote:
> Hello
>
> I have a friend that ask me why postgresql is better than mysql.
> I personally prefer posgresql, but she need to give in her work 3 or 4
> strong reasons for that. I mean not to much technical reasons. Can you
> give help me please ?
>
in MySQL if you have tables MyISAM they will ignore all rollback
commands you exexute, so you will have inconsistencies in databases...
worst, if you have tables MyISAM and tables InnoDB the first will
ignore all rollback commands and the laters won't...
of course the legendary speed in mysql can be obtained if you use
tables MyISAM :(
some other issues (some of them had been resolved in 5.x i don't know wich ones)
http://sql-info.de/mysql/gotchas.html
one last thing mysql team doesn't afraid to change behaviours between
minor releases, look at this thread
http://archives.postgresql.org/pgsql-general/2005-12/msg00487.php
http://dev.mysql.com/doc/refman/5.1/en/join.html
(Join Processing Changes in MySQL 5.0.12)
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook