Databse recommendation

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
mgaidia
Registered User
Posts: 2
Joined: Sun Apr 08, 2007 7:35 am

Databse recommendation

Post by mgaidia »

phpbb support many databases, now the question is which one to use?
any advice?
User avatar
WhiteWolfSix
Registered User
Posts: 210
Joined: Fri Jan 21, 2005 9:05 am
Location: 48°43′N, 19°08′E

Re: Databse recommendation

Post by WhiteWolfSix »

Most used database for phpbb is mySQL.
Image
WhiteWolfSix (WW6)
mgaidia
Registered User
Posts: 2
Joined: Sun Apr 08, 2007 7:35 am

Re: Databse recommendation

Post by mgaidia »

i know but for example mysql have a bad full text search.
Which one is the most reliable? quick, stable, etc..
User avatar
jojobarjo32
Registered User
Posts: 164
Joined: Wed Jun 22, 2005 7:38 pm
Location: France

Re: Databse recommendation

Post by jojobarjo32 »

It depends... For many boards, MySQL is sufficient... otherwise you can use it for example with PostgreSQL which is very reliable and fast.
I don't know the others DBMS supported but I think MySQL and PostgreSQL are the most common used on the web.
matthewf
Registered User
Posts: 147
Joined: Sat Feb 24, 2007 2:01 pm
Location: England

Re: Databse recommendation

Post by matthewf »

not to mention there are a lot of mysql experts on theses boards (phpbb.com included)
User avatar
EXreaction
Registered User
Posts: 1555
Joined: Sat Sep 10, 2005 2:15 am

Re: Databse recommendation

Post by EXreaction »

I am interested in hearing what others have to say as well...

I am a php developer, but I have never gotten more than ankle deep in the other DB types besides MySQL.
Millar
Registered User
Posts: 2
Joined: Fri Apr 13, 2007 4:04 pm
Contact:

Re: Databse recommendation

Post by Millar »

EXreaction wrote: I am interested in hearing what others have to say as well...

I am a php developer, but I have never gotten more than ankle deep in the other DB types besides MySQL.

Yes, I am the same. I think mySQL is definately the most associated with PHP in general. Not to mention support by a mojority of webhosts.
User avatar
pentapenguin
Registered User
Posts: 618
Joined: Sun Jul 18, 2004 6:07 pm
Location: GA, USA
Contact:

Re: Databse recommendation

Post by pentapenguin »

mgaidia wrote: i know but for example mysql have a bad full text search.

phpBB has a search engine built in that doesn't rely on MySQL. Use the one your host provides since they all should work equally well.
phpBB.com Support Team Member and Incident Investigation Team Member
My phpBB MODs || Professional phpBB Customization, Transfers, and Conversions
User avatar
jojobarjo32
Registered User
Posts: 164
Joined: Wed Jun 22, 2005 7:38 pm
Location: France

Re: Databse recommendation

Post by jojobarjo32 »

pentapenguin wrote: they all should work equally well.

They all work well, I agree... equally... no :)
Don't compare SQLite with Oracle for example :P

But for a "normal" board, which does not have millions of posts, the simplest DBMS (i.e. MySQL I think with PHP... especially because it's the one mainly provided by hosts) is quite good :)
The only DBMS you should avoid IMHO, except if you have a really small board, is SQLite.
User avatar
pentapenguin
Registered User
Posts: 618
Joined: Sun Jul 18, 2004 6:07 pm
Location: GA, USA
Contact:

Re: Databse recommendation

Post by pentapenguin »

jojobarjo32 wrote: Don't compare SQLite with Oracle for example

If you're using Oracle you probably already know that. :P

And let me clarify what I said...deciding what database system to use is more of a personal choice based on the nature of your board (as you said, SQLite probably isn't the best choice for a really active site) because all those DBMS are supported.
phpBB.com Support Team Member and Incident Investigation Team Member
My phpBB MODs || Professional phpBB Customization, Transfers, and Conversions
Post Reply