===== SQLite Database =====
~~NOTOC~~
===== sqlite3 =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|sqlite3|
^Data Provider|sqlite|
^Status|Active((This driver is actively supported by ADOdb project members))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|Yes|
== Alternatives ==
[[v5:database:pdo#pdo_sqlite|PDO driver for SQLite]]
</WRAP>
** This is the preferred driver for connecting to sqlite databases **
This preferred driver supports connections to SQLite version 3 databases.

Note that SQLite table and index names are case-sensitive, but do not allow full case-sensitivity like the [[v5:database:ibm_db2|IBM DB2]] driver.

==== Limitations in Meta Functions ====
The driver does not support the following metaFunctions:
  * [[v5:dictionary:altercolumnsql|alterColumnSql()]] 
  * [[v5:dictionary:dropcolumnsql|dropColumnSql()]]

This is a limitation of Sqlite itself, not ADOdb. For more information see [[http://www.sqlite.org/lang_altertable.html|Here]]
{{tag>[sqlite3 active tier1]}}
-------------------------------
===== sqlite =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|sqlite|
^Data Provider|sqlite|
^Status|Obsolete((This driver is obsolete and will be removed in ADOdb V6))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|No|
</WRAP>
This deprecated driver supports SQLite Version 2 databases. 
{{tag>[sqlite2 unix windows deprecated]}}
---------------------------------------------
===== sqlitepo =====
<WRAP right box round 300px>
== Specification ==
^Driver Name|sqlitepo|
^Data Provider|sqlite|
^Status|Obsolete((This driver is obsolete and will be removed in ADOdb V6))|
^Windows|Yes|
^Unix|Yes|
^ADOdb V5|Yes|
^ADOdb V6|No|

</WRAP>
This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries.
{{tag>[sqlite2 deprecated]}}