[Leaplist] curious about mysql vs postgres...

[Jason Boxman]

On Wednesday 01 October 2008 20:14:03 tom foster wrote:
> Nothing too heavy.
>
> I'm wondering whether either one is "easier" than the other, or are
> they about the same but the plumbing is so different that one seems
> more difficult?
>
> "LAMP" is a more common acronym than "LAPP", after all.

There was a time when MySQL was somewhat faster than PostgreSQL, so it was 
popular for Web apps that didn't need the reliability of an ACID compliant 
RDBMS.  That day has long passed.  MySQL is mostly popular today because it's 
entrenched.

The only reasons I can see for using MySQL is: legacy code, phpmyadmin, ENUM 
type -- though latest PostgreSQL now has this too --, or replication, if your 
entire database fits in memory.

Further, for something as important as your data, PostgreSQL has always been 
completely Open Source (tm).  Moreover, its authors, unlike those of MySQL, 
have never been dismissive of lacking features.  Instead, they added them.  
(MySQL tended to dismiss useful features, then implement them and scrub 
evidence of their dismissiveness away.  Weak sauce.)

ymmv


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.