postgresql VS mysql .. when which is better ?

[daemonfowl]

Hi everybody !!

I'd like to ask you about mysql VS postgresql .

Maybe there no point arguing that one is always better than the other ..
Are there any particular cases when postgresql is more advisable to opt for ?

eg.0 : mediawiki
eg.1 : nginx/apache ?
.. etc

Would there be any noticeable difference using one with such apps ?
Or is it all a matter of habitual first-used-app ?

Thank you !

[ocicat]

Originally Posted by daemonfowl

Maybe there no point arguing that one is always better than the other ..

Correct.

Are there any particular cases when postgresql is more advisable to opt for ?

Historically, MySQL focused more on performance at the expense of following standard, but it was still adopted in the marketplace more than PostgreSQL. As a result, more people are probably familiar with MySQL than PostgreSQL.

On the other hand, PostgreSQL focused more on implementing the SQL standard than MySQL, but lagged in performance until the late 8.0x series. The PostgreSQL team is also working on making high availability (HA) features solid. Performance in the 9.x series is significantly better too.

Personally, I prefer PostgreSQL because of its adherence to standards, the compatibility of its license to the BSD license, & the PostgreSQL mailing lists. The PostgreSQL development team is very active, & very helpful.

mediawiki

Until very recently, Mediawiki claimed compatibility with MySQL, however they made available information on how to work with PostgreSQL, but they made no guarantees on stability. Nevertheless, they now claim to support PostgreSQL. I do not have experience using Mediawiki with PostgeSQL to know how solid this compatibility is yet. You do the math.

nginx/apache ?

The patched version of Apache 1.3 in OpenBSD's base installation is only getting older. Discussion on misc@ indicates that at some point it will be dropped. nginx(8) is already integrated into OpenBSD's base installation, & by reputation sports better performance & agility. People can over-emphasize performance issues, but this helps when using older hardware with isn't cutting edge.

Or is it all a matter of habitual first-used-app ?

This can be a factor.

[vermaden]

@daemonfowl
http://ledgersmbdev.blogspot.co.uk/2...gresql-vs.html
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL

Personally, I would stay away from MySQL as far as possible.

[daemonfowl]

ocicat ,thank you very much for your interesting post !
vermaden , thank you very much for the links ! the wikiVS is really cool :-)
Mr Elephant is more convincing than dolphins ..