ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
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
v5:database:sqlite [2016/01/13 22:25] – [sqlitepo] mnewnhamv5:database:sqlite [2024/12/15 15:38] (current) – [sqlite3] 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 ==
 ^Driver Name|sqlite3| ^Driver Name|sqlite3|
Line 11: Line 13:
 ^ADOdb V5|Yes| ^ADOdb V5|Yes|
 ^ADOdb V6|Yes| ^ADOdb V6|Yes|
 +
 == Alternatives == == Alternatives ==
 [[v5: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.+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]] 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.
  
 ==== Limitations in Meta Functions ==== ==== Limitations in Meta Functions ====
-The driver does not support the following metaFunctions: 
-  * [[v5:dictionary:altercolumnsql]]  
-  * [[v5:dictionary:dropcolumnsql]] 
  
-This is a limitation of Sqlite itself, not ADOdb. For more information see [[http://www.sqlite.org/lang_altertable.html|Here]] +The SQLite database engine has limited support for ALTER TABLE statements.  
-{{tag>[sqlite3 active]}}+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 ===== ===== sqlite =====
 <WRAP right box round 300px> <WRAP right box round 300px>
Line 53: Line 64:
  
 </WRAP> </WRAP>
-This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries. The Sqlite3 driver 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.1452720356.txt.gz · Last modified: 2017/04/21 11:23 (external edit)