Which database type do you prefer?

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
Profo
Registered User
Posts: 34
Joined: Wed May 13, 2009 1:51 pm

Which database type do you prefer?

Post by Profo » Mon Jul 14, 2014 2:33 pm

I've always used MySQL with phpBB. I love MySQL. It's the database type I learned first, it's fast, the one I know better, and the one available on every server.
I think this also applies to ¿90%? of phpBB forums out there.

But lately I've been wondering if there would be a real advantage in learning and using another database type with phpBB, so I decided to ask here.
For example: Would I increase forum performance by using SQLite? Would searches be more accurate with a different database engine?

I googled a little bit, but didn't find any phpbb-focused comparison, so any experiences would be helpful.

User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan

Re: Which database type do you prefer?

Post by EXreaction » Tue Jul 15, 2014 12:39 am

Until you get a large number of simultaneous users, what is used won't really matter.

MySQL or PostgreSQL are probably the best options.

There is not much to learn by using a different database system, unless you're intending on becoming a DBA. For simple applications like phpBB, the database doesn't really matter and they all function roughly the same.

The database starts really mattering when you are managing many GB or TB of data or need to handle thousands or millions of requests a second.

User avatar
umarizal
Registered User
Posts: 172
Joined: Mon Mar 17, 2008 2:03 am
Location: São Paulo - SP - Brasil
Name: Leandro dos Santos
Contact:

Re: Which database type do you prefer?

Post by umarizal » Tue Nov 18, 2014 6:06 pm

I've read on many sites recommendations to use MariaDB to be lighter and faster than MySQL.
EN: Do to others what you would want them to do to you.
ES: Haz a los demás todo lo que quieras que te hagan a ti.
PT: Faça aos outros o que você gostaria que fizessem a você.

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29247
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: Which database type do you prefer?

Post by Marshalrusty » Wed Nov 19, 2014 1:07 am

umarizal wrote:I've read on many sites recommendations to use MariaDB to be lighter and faster than MySQL.
Yup. If you have the opportunity to choose MariaDB instead of MySQL, there are no downsides to doing so.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

User avatar
Lumpy Burgertushie
Registered User
Posts: 66268
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Which database type do you prefer?

Post by Lumpy Burgertushie » Wed Nov 19, 2014 4:06 am

my host just switched over recently and I didn't even know about it. did not have to make any changes for any of my boards etc.


robert
I am going to be out of town and off line for a week . see ya when I get back.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Post Reply

Return to “phpBB Discussion”