postgresql vs mysql

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Suggested Hosts
Post Reply
besonen
Registered User
Posts: 5
Joined: Sun Nov 14, 2004 12:17 am

postgresql vs mysql

Post by besonen »

would someone willing the list the pros and cons of using postgresql and mysql?

i read on a comment elsewhere that phpbb3 only supports full text searching with mysql. is this true?

thanks,
david

besonen
Registered User
Posts: 5
Joined: Sun Nov 14, 2004 12:17 am

Re: postgresql vs mysql

Post by besonen »

besonen wrote:would someone willing the list the pros and cons of using postgresql and mysql?
to be clear, i'm asking about the pros and cons of phpbb3--i.e., how does phpbb3 behave/function differently depending on which database is being used.
besonen wrote:i read on a comment elsewhere that phpbb3 only supports full text searching with mysql. is this true?
fwiw, i did search this forum prior to posting and came up with only a few comments regarding the differences. if there are some other documents outside of the forum that document the phpbb differences between using postgrsql and mysql i'd love the urls.

User avatar
Jim_UK
Former Team Member
Posts: 18478
Joined: Tue Oct 12, 2004 5:36 pm
Location: Darwen N.West UK

Re: postgresql vs mysql

Post by Jim_UK »

Hi
Maybe this will answer your question fully.

Jim
The truth is out there.
Unfortunately they will not let you anywhere near it!

User avatar
DavidMJ
Former Team Member
Posts: 314
Joined: Thu Aug 04, 2005 12:50 am
Location: New York

Re: postgresql vs mysql

Post by DavidMJ »

Jim_UK wrote:Hi
Maybe this will answer your question fully.

Jim
That article is out of date and highly inaccurate.

If I were to pick one, I would pick PostgreSQL over MySQL because of how consistent it is and the superior way it handles Unicode

However, PostgreSQL requires significant amounts of tuning before it can be used on a high traffic site

User avatar
battye
Extension Customisations
Extension Customisations
Posts: 10945
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: postgresql vs mysql

Post by battye »

One advantage of MySQL is the number of people that use it. A significant number of phpBB users use MySQL and are familiar with it, so if you ever run into problems it is likely someone will have encountered it before and be able to assist.
Customisations Team Member

https://github.com/battye/php-array-parser - Give it a Star! :D

Post Reply

Return to “phpBB Discussion”