Differences

This shows you the differences between two versions of the page.

--- database:sqlite [2015/07/18 15:49] – created mnewnham
+++ v5:database:sqlite [2020/01/13 12:47] (current) – Add tier1 tag dregad
@@ Line 1: / Line 1: @@
 ===== SQLite Database =====
-See also the [[PDO]] driver for SQLite
+~~NOTOC~~
-==== sqlite3 ====
+===== sqlite3 =====
+<WRAP right box round 300px>
-<WRAP left 300px box>
+== Specification ==
-|Driver Name|sqlite3|
+^Driver Name|sqlite3|
-|Status|Active|
+^Data Provider|sqlite|
-|Windows|Yes|
+^Status|Active((This driver is actively supported by ADOdb project members))|
-|Unix|Yes|
+^Windows|Yes|
+^Unix|Yes|
+^ADOdb V5|Yes|
+^ADOdb V6|Yes|
+== Alternatives ==
+[[v5:database:pdo#pdo_sqlite|PDO driver for SQLite]]
 </WRAP>
-This preferred driver supports connections to SQLite version 3 databases
+** This is the preferred driver for connecting to sqlite databases **
-{{tag>[sqlite3 unix windows active]}}
+This preferred driver supports connections to SQLite version 3 databases.
-==== sqlite ====
+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.
-<WRAP left 300px box>
-|Driver Name|sqlite|
+==== Limitations in Meta Functions ====
-|Status|Deprecated|
+The driver does not support the following metaFunctions:
-|Windows|Yes|
+  * [[v5:dictionary:altercolumnsql|alterColumnSql()]]
-|Unix|Yes|
+  * [[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|
-==== sqlitepo ====
-<WRAP left 300px box>
-|Driver Name|sqlitepo|
-|Status|Deprecated|
-|Windows|Yes|
-|Unix|Yes|
 </WRAP>
-This deprecated driver adds portability to the sqlite driver by stripping the table names from the column names in queries.
+This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries.
-{{tag>[sqlite2 unix windows deprecated portable]}}
+{{tag>[sqlite2 deprecated]}}