Most preferred DBMS used for phpBB (which database type?)

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Get Involved
Post Reply
User avatar
AmigoJack
Registered User
Posts: 5702
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Most preferred DBMS used for phpBB (which database type?)

Post by AmigoJack »

Is there a (representative) statistic where each DBMS type is listed and how much it is used in running phpBB installations? I would like to get an overview if MySQL is really used most ...and if PostgreSQL is on the second place ...and how many are really using ORACLE.

It doesn't matter if the numbers are mixing internet sites with intranet sites - or if they show counts instead of percents.
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by drathbun »

I think you would find the overwhelming majority of boards owners are using MySQL, simply because it's part of the "free" stack of linux + apache + mysql + php or LAMP. Most inexpensive web hosts offer this package, and even more costly hosts offer it as a very cost effective solution. There is no advantage to running Windows+SQL Server or Oracle or any other paid solution.

MySQL is certainly capable of running large boards when properly tuned and with proper hardware behind it.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

User avatar
naderman
Consultant
Consultant
Posts: 3735
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by naderman »

The people submitting information through the ACP send stats feature use:

99.11% MySQL
0.40% PostgreSQL
0.36% Microsoft SQL Server
0.08% SQLite
0.03% Oracle
0.01% Firebird
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by drathbun »

drathbun wrote:I think you would find the overwhelming majority of boards owners are using MySQL
naderman wrote:99.11% MySQL
I am guessing that 99.11% could be considered an overwhelming majority... :lol:
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

User avatar
AmigoJack
Registered User
Posts: 5702
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by AmigoJack »

Thanks nader for showing real data. :) I guess those are total numbers since phpBB began offering the option to send this date in the ACP...? (When was it?)

I can speculate on my own - the more I read about PosgreSQL the more I think MySQL is like Windows: it's just too widespread so people hardly expect anything else (whereas PostgreSQL nowadays almost differs in nothing compared to MySQL while still being more robust - so it will still take time until hosters accept it to offer [don't forget that MySQL is owned by ORACLE - a profit oriented company]).

I wonder how the numbers will look like in the future...
The worst thing about censorship is ███████████
Affin wrote:
Tue Nov 20, 2018 9:51 am
The problem is probably not my English but you do not want to understand correctly.
...
We will not come anybody anyway, nevertheless, it's best to shit this.

Kim_Possible
Registered User
Posts: 1343
Joined: Sun Sep 21, 2008 3:57 pm

Re: Most preferred DBMS used for phpBB (which database type?

Post by Kim_Possible »

AmigoJack wrote:(When was it?)
IIRC, the admin stat collection feature was added in 3.0.6, so Fall 2009.

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by drathbun »

AmigoJack wrote:[don't forget that MySQL is owned by ORACLE - a profit oriented company])
Which, in my opinion, will not change anything, nor should it. Oracle remains committed to open source, and MySQL has for many years (long before being acquired by SUN, followed by the Oracle acquisition) offered a free and a paid "enterprise" version of their database.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

User avatar
Elias
Registered User
Posts: 4745
Joined: Sat Feb 25, 2006 4:31 pm
Location: In the Water!
Name: Elias

Re: Most preferred DBMS used for phpBB (which database type?

Post by Elias »

naderman wrote:The people submitting information through the ACP send stats feature use:

99.11% MySQL
0.40% PostgreSQL
0.36% Microsoft SQL Server
0.08% SQLite
0.03% Oracle
0.01% Firebird
Thanks for the info!
"Mystery creates wonder, and wonder is the basis of man's desire to understand." - Neil Armstrong
|Installing Extensions|Writing Extensions|Extension Validation Policy|

User avatar
Ger
Recognised Extension Developer
Posts: 1934
Joined: Wed Jan 02, 2008 7:35 pm
Location: 192.168.1.100
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by Ger »

AmigoJack wrote:I can speculate on my own - the more I read about PosgreSQL the more I think MySQL is like Windows: it's just too widespread so people hardly expect anything else (whereas PostgreSQL nowadays almost differs in nothing compared to MySQL while still being more robust -
It's true that many hosts only offer MySQL and not PostgreSQL. But even when the choice is offered I still choose MySQL(i). Simply because I'm familiair with it.

You say PostgreSQL is more robust: why is that? What's the exact difference?
My extensions:
Simple CMS, Feed post bot, Avatar Resize, Modbreak, Magic OGP, Live topic update, Modern Quote, Quoted Where (GDPR) and Autoresponder.
Newest: FAQ manager for 3.2

Like my work? Buy me a coffee to keep it coming. :ugeek:

-Don't PM me for support-

User avatar
Sajaki
Registered User
Posts: 1360
Joined: Mon Mar 02, 2009 1:41 pm
Location: Acidalia Planitia, Mars
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by Sajaki »

Ger wrote:You say PostgreSQL is more robust: why is that?
This article sums it up nicely.
http://www.techrepublic.com/article/mys ... ql/1050671
Transactions and advanced locking is something i much miss in mysql. you need mysql with innodb for that whereas most hosts only offer isam which doesn't have transactions. the only visible downside for postgre is perhaps that it's reported to be abit slower.

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by drathbun »

Sajaki wrote:This article sums it up nicely.
http://www.techrepublic.com/article/mys ... ql/1050671
Did you see the date on that article? It's from 2002. A lot has changed since then; as a result, their feature comparison chart is not accurate anymore.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

User avatar
Dog Cow
Registered User
Posts: 2496
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: Most preferred DBMS used for phpBB (which database type?

Post by Dog Cow »

Ger wrote: But even when the choice is offered I still choose MySQL(i). Simply because I'm familiair with it.
Note that MySQLi is a PHP interface to MySQL. MySQL is still MySQL.
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog

Post Reply

Return to “phpBB Discussion”