ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== 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.**
It 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 SQLite database engine has limited support for ALTER TABLE statements. 
For more information, refer to the [[https://www.sqlite.org/lang_altertable.html|SQLite documentation]].

Consequently, some of ADOdb's Data Dictionary functions are not supported, as per the table below:

^ Meta Function                                         ^ ADOdb           ^ SQLite    ^
| [[v5:dictionary:altercolumnsql|alterColumnSql()]]     | **Unsupported** |           |
| [[v5:dictionary: renameColumnSql |renameColumnSql()]] | >= 5.23.0       | >= 3.25.0 |
| [[v5:dictionary:dropcolumnsql|dropColumnSql()]]       | >= 5.23.0       | >= 3.35.0 |


{{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]}}