Differences

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

--- database:sqlite [2015/11/26 19:12] – [Support Status] mnewnham
+++ v5:database:sqlite [2016/02/01 21:49] – [sqlite3] mnewnham
@@ 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|
+^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 **
-|Driver Name|sqlite3|
+This preferred driver supports connections to SQLite version 3 databases.
-|Status|Active|
-|Windows|Yes|
-|Unix|Yes|
-</WRAP>
-This preferred driver supports connections to SQLite version 3 databases. If you are using this driver in a portable application, consider using the sqlitepo driver.
-===== Support Status =====
+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.
-This driver is actively supported by ADOdb project members
+==== 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 unix windows active supported]}}
+{{tag>[sqlite3 active]}}
+-------------------------------
-==== sqlite ====
+===== sqlite =====
-<WRAP left 300px box>
+<WRAP right box round 300px>
-|Driver Name|sqlite|
+== Specification ==
-|Status|Deprecated|
+^Driver Name|sqlite|
-|Windows|Yes|
+^Data Provider|sqlite|
-|Unix|Yes|
+^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]}}