The Joomla! Community Magazine™

Help Wanted - Testing Joomla! Multi-Database Compatibility

Written by | Wednesday, 01 May 2013 00:00 | Published in 2013 May
Over the course of the last year and a half, the Joomla! CMS has made great strides to expand the environments it is supported in. Through those efforts, the project officially supports using the CMS on multiple web server technologies and database servers. Though the CMS functions relatively well in these environments, the project needs your help to improve that support.

Background

During the later part of 2011, the first push for multi-database support was made for the CMS, with a team from Hooduku implementing support for Microsoft's SQL Server (and inherently, the Windows SQL Azure Database). With the release of 2.5 in January 2012, the CMS was officially supported for the first time on a non-MySQL driven database. This support expanded with the release of 3.0 when PostgreSQL support was added.

Current Status

The Joomla CMS continues to support MySQL, PostgreSQL, and SQL Server, but there are areas that need to be improved upon. If you browse the CMS Issue Tracker, you'll find that there are several reports of issues with these environments with the root issue being how the queries are formed in the code.

How Can I Help?

If you have access to a SQL Server or PostgreSQL environment, or are able to set one up (many *AMP software packages used for local development already support PostgreSQL, you just need to install the database server separately), we can use your help! We need people willing to install the CMS in these environments and use it as usual, noting any database related errors they may find. If you're able, we need to fix these queries or PHP methods, or in some less common instances, alter the database schema to allow these tasks to complete properly, while still functioning in all three supported database environments.

Sign Me Up!

If this interests you, I can be contacted via e-mail at michael.babker [AT] joomla [DOT] org. Help us help the millions of users of the Joomla CMS and improve our code along the way.

Read 11181 times
Tagged under Developers, English
Michael Babker

Michael Babker

Michael is an active member of the Joomla! community, participating in the Bug Squad, contributing code to the CMS and Framework, and is currently a member of the Production Leadership Team.

His contributions to the community have been recognized with the 2012 J!OSCAR "GitHub Junkie" Award. His high standards for code and focus on automated testing have raised the overall quality of Joomla's code and helps ensure a stable and quality product for every Joomla user.

When he isn't working on core code, he can be found working on his own set of extensions, opinionating on Twitter, or out in the real world enjoying the sights and sounds of wherever he may be at the time.