PostgreSQL experience, maybe even thru migration

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: 5841
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

PostgreSQL experience, maybe even thru migration

Post by AmigoJack »

Whoever runs phpBB with PostgreSQL for a longer time here: are there known limitations or spots that can become problematic? Right now I'm sitting here, being used to MySQL and MariaDB for years, having little to no problems with it (those few that came were solved easily). But every way I look the latter two DBMSes are legacy software, which in my phpBB world only exist because phpBB rose with it. PostgreSQL seems to outsmart the other two in every aspect, and potential problems or shortcomings that may have existed don't exist as of today (anymore).

Does anyone know a reason against migrating to PostgreSQL?
  • "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." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
Lady_G
Registered User
Posts: 263
Joined: Fri Jun 08, 2012 12:38 pm
Location: US

Re: PostgreSQL experience, maybe even thru migration

Post by Lady_G »

I've been using postgreSQL since phpBB 2.x.

I'm not a database expert, but my server administrator says that postgreSQL has much better performance (compared to mySQL) for large databases.

Another criteria is migrating to postgreSQL. Moving from one database to another is not an easy process. I have never done this myself, but my opinion is based on discussions with someone who knows databases.

Perhaps you should try the migration first, then decide if you should make the change.
User avatar
AbaddonOrmuz
Recognised Extension Developer
Posts: 1053
Joined: Wed Dec 25, 2013 9:06 pm
Location: /dev/null
Name: Alfredo
Contact:

Re: PostgreSQL experience, maybe even thru migration

Post by AbaddonOrmuz »

AmigoJack wrote:
Mon Feb 08, 2021 1:20 pm
Does anyone know a reason against migrating to PostgreSQL?
If you use a shared hosting, portability could be a problem since not all shared hosting companies offer PostgreSQL.

If you use a VPS or dedicated server, I see no other reason against using PostgreSQL.

I used this tool when I moved my boards to PostgreSQL some years ago, no problems at all.

https://github.com/AnatolyUss/FromMySqlToPostgreSql
Some of my phpBB extensions:
Image Imgur | :chart_with_upwards_trend: SEO Metadata | Image Markdown | :lock: Auto-lock Topics
:trophy: Check out all my validated extensions :trophy:

:penguin: Arch Linux user :penguin:
Post Reply

Return to “phpBB Discussion”