DaemonForums  

Go Back   DaemonForums > Miscellaneous > General software and network

General software and network General OS-independent software and network questions, X11, MTA, routing, etc.

Reply
 
Thread Tools Display Modes
  #1   (View Single Post)  
Old 11th September 2012
daemonfowl daemonfowl is offline
bsdstudent
 
Join Date: Jan 2012
Location: DaemonLand
Posts: 834
Thanked 0 Times in 0 Posts
Default postgresql VS mysql .. when which is better ?

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 !
Reply With Quote
  #2   (View Single Post)  
Old 12th September 2012
ocicat ocicat is offline
Administrator
 
Join Date: Apr 2008
Posts: 2,888
Thanked 190 Times in 160 Posts
Default

Quote:
Originally Posted by daemonfowl View Post
Maybe there no point arguing that one is always better than the other ..
Correct.
Quote:
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.
Quote:
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.
Quote:
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.
Quote:
Or is it all a matter of habitual first-used-app ?
This can be a factor.
Reply With Quote
  #3   (View Single Post)  
Old 12th September 2012
vermaden's Avatar
vermaden vermaden is offline
Administrator
 
Join Date: Apr 2008
Location: pl_PL.lodz
Posts: 1,052
Thanked 118 Times in 93 Posts
Default

@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.
__________________
religions, worst damnation of mankind
"If 386BSD had been available when I started on Linux, Linux would probably never had happened." Linus Torvalds

Linux is not UNIX! Face it! It is not an insult. It is fact: GNU is a recursive acronym for “GNU's Not UNIX”.
vermaden's: links resources deviantart spreadbsd
Reply With Quote
  #4   (View Single Post)  
Old 12th September 2012
daemonfowl daemonfowl is offline
bsdstudent
 
Join Date: Jan 2012
Location: DaemonLand
Posts: 834
Thanked 0 Times in 0 Posts
Default

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 ..
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hipsters hacking on PostgreSQL J65nko News 0 31st August 2012 06:36 PM
PostgreSQL 9.1 with synchronous replication J65nko News 0 12th September 2011 10:57 PM
PostgreSQL updates released J65nko News 0 20th December 2010 10:31 PM
[FreeBSD] which version of PostgreSQL? MacApp FreeBSD Ports and Packages 8 12th July 2008 09:25 AM
PostgreSql rc.d script fridder FreeBSD Ports and Packages 1 1st July 2008 01:12 AM


All times are GMT. The time now is 01:07 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick