Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:
This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since ((JVer|3.3}} only):
The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in.
To make a connector available in Joomla's installer or global configuration manager, you will need to ensure the PHP library is installed (E.g. for PHP5 and MySQL the php5-mysql library would need to be installed).
|Database||Joomla Versions||Joomla DB|
|Microsoft SQL Server||Yes|
|Microsoft SQL Azure||Yes|
|PHP Data Objects (PDO)*||No|