[support] Drupal: MySQL vs. PostgreSQL

[Vasileios Lourdas]

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.
-- 
# Vasileios Lourdas,
# Informatics Engineer, Thessaloniki (Greece)
# http://www.lourdas.name