Not planned Will xenforo be ported to postgres?

[jtorral]

Mysql is a fine database but pales in comparison to Postgres. Are there any plans on making Xenforo run with a Postgres backend?

JT

 

[Kirby]

Hmm ...

It's a relatively simple coding exercise to finish the Postgres adapter that XenForo already did 95% of. The coding time to do it is less than the time people have spent writing posts in this thread.

There's likely to be a fair number of queries in the core which are specific to MySQL, so fully swapping out the database engine would require more significant changes than just switching the adapter

So who's right?

 

[Xon]

Finishing the Postgres adapter would be simple. Migrating XF to efficiently run on Postgres would absolutely be not.

For XenForo, Postgres doesn't actually have a way to pin execution plans or provide optimizer hints. The official way is to rewriting the entire query. This is a huge overhead for the custom ORM/Query builder XF uses.