On Wednesday 21 of July 2010 16:46:44 Pierre Rineau wrote:
MySQL is not an SQL database layer. A real SQL database layer must, at least, be ACID compliant :D
<Flame ware mode engaged/>
Pierre.
It's strange that no one talks about MySQL's InnoDB engine, which is fully ACID compliant. An outside reader would possibly conclude from this conversation that MySQL = MyISAM, which is not ACID compliant. All it takes is to add/change a line in my.cnf to make InnoDB the default storage engine. I remember reading that MySQL 5.5 will make InnoDB the default storage engine. Oh well, maybe then will be the time when most people understand that MySQL is really ACID compliant.
I haven't worked with Postgresql before, from talks and internet posts I read that it's a very strong DBMS with many features. But let's also not make false arguments about MySQL.