Differences

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

--- database:sqlite [2015/11/28 00:38] – mnewnham
+++ v5:database:sqlite [2016/02/01 21:49] – [sqlite3] mnewnham
@@ Line 1: / Line 1: @@
 ===== SQLite Database =====
 ~~NOTOC~~
-==== sqlite3 ====
+===== sqlite3 =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 12: / Line 12: @@
 ^ADOdb V6|Yes|
 == Alternatives ==
-[[database:pdo#pdo_sqlite|PDO driver for SQLite]]
+[[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]}}
 -------------------------------
-==== sqlite ====
+===== sqlite =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 33: / Line 41: @@
 {{tag>[sqlite2 unix windows deprecated]}}
 ---------------------------------------------
-==== sqlitepo ====
+===== sqlitepo =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 43: / Line 51: @@
 ^ADOdb V5|Yes|
 ^ADOdb V6|No|
-This deprecated driver adds portability to the sqlite driver by stripping the table names from the column names in queries.
-</WRAP>
-{{tag>[sqlite2 deprecated]}}
+</WRAP>
+This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries.
+{{tag>[sqlite2 deprecated]}}