ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:sqlite

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
database:sqlite [2015/12/28 04:27] mnewnhamv5:database:sqlite [2020/01/13 12:47] (current) – Add tier1 tag dregad
Line 1: Line 1:
 ===== SQLite Database ===== ===== SQLite Database =====
 ~~NOTOC~~ ~~NOTOC~~
-==== sqlite3 ====+===== sqlite3 =====
 <WRAP right box round 300px> <WRAP right box round 300px>
 == Specification == == Specification ==
Line 12: Line 12:
 ^ADOdb V6|Yes| ^ADOdb V6|Yes|
 == Alternatives == == Alternatives ==
-[[database:pdo#pdo_sqlite|PDO driver for SQLite]]+[[v5:database:pdo#pdo_sqlite|PDO driver for SQLite]]
 </WRAP> </WRAP>
 ** This is the preferred driver for connecting to sqlite databases ** ** This is the preferred driver for connecting to sqlite databases **
 This preferred driver supports connections to SQLite version 3 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 [[database:IBM DB2]] driver.+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.
  
-{{tag>[sqlite3 active]}}+==== 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 ====+===== sqlite =====
 <WRAP right box round 300px> <WRAP right box round 300px>
 == Specification == == Specification ==
Line 35: Line 41:
 {{tag>[sqlite2 unix windows deprecated]}} {{tag>[sqlite2 unix windows deprecated]}}
 --------------------------------------------- ---------------------------------------------
-==== sqlitepo ====+===== sqlitepo =====
 <WRAP right box round 300px> <WRAP right box round 300px>
 == Specification == == Specification ==
Line 47: Line 53:
  
 </WRAP> </WRAP>
-This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries. The Sqlite3 exhibits this behavior by default.+This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries.
 {{tag>[sqlite2 deprecated]}} {{tag>[sqlite2 deprecated]}}
- 
v5/database/sqlite.1451273247.txt.gz · Last modified: 2017/04/21 11:23 (external edit)