View source for Accessing the database using JDatabase

{{review|}}
<noinclude><languages /></noinclude>
<noinclude>{{Joomla version|version=3.x}}{{Joomla version|version=2.5|status=eos}}</noinclude>
<translate>
==Useful information== <!--T:1-->
</translate>
<translate><!--T:2-->
Being able to use JDatabase is vital when you start developing for Joomla. The tutorial is split into two independent parts:</translate>
<translate><!--T:3-->
* [[S:MyLanguage/Inserting, Updating and Removing data using JDatabase|Inserting, updating and removing data from the database]].</translate>
<translate><!--T:4-->
* [[S:MyLanguage/Selecting data using JDatabase|Selecting data from one or more tables]] and retrieving it in a variety of different forms.</translate>

<translate>
==Advanced information== <!--T:5-->
</translate>
<translate><!--T:6-->
This tutorial looks at how to use transactions with JDatabase (available since {{JVer|3.x}} only):</translate>
<translate><!--T:7-->
* [[S:MyLanguage/Using transactions in Joomla|Using transactions in Joomla]]</translate>
<translate><!--T:8-->
This tutorial looks at how to use the union methods in JDatabaseQuery (available in working form since {{JVer|3.3}} only):
* [[S:MyLanguage/Using the union methods in database queries|Using the union methods in database queries]]</translate>

<translate>
==Supported Storage Connectors== <!--T:9-->
</translate>
<translate><!--T:10-->
The table below outlines the database and storage connectors available for Joomla! as well as which version of Joomla they became available in.</translate>

<translate><!--T:11-->
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).</translate>

{| class="wikitable"
! scope="col" | <translate><!--T:12-->
Database</translate> 
! scope="col" | <translate><!--T:13-->
Joomla! Versions</translate>
! scope="col" | <translate><!--T:14-->
Joomla DB</translate>
|-
| MySQL || {{JVer|1.5}}{{JVer|2.5}}{{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:15-->
Yes</translate>
|-
| Microsoft SQL Server || {{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:16-->
Yes</translate>
|-
| Microsoft SQL Azure || {{JVer|2.5}}{{JVer|3.0}} || <translate><!--T:17-->
Yes</translate>
|-
| Postgresql || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:18-->
Yes (In {{JVer|4.0}} and higher only via the PDO library for postgres)</translate>
|-
| Oracle DB || {{JVer|3.0}} || <translate><!--T:19-->
No</translate>
|-
| SQL Lite || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:20-->
No</translate>
|-
| PHP Data Objects (PDO)* || {{JVer|3.0}}{{JVer|4.0}} || <translate><!--T:21-->
No</translate>
|}

<translate><!--T:22-->
* PHP Data Objects is a database abstraction layer and is shipped with PHP 5.1+.</translate>

<noinclude>
[[Category:Database{{#translation:}}]]
</noinclude>