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 [2020/01/13 12:47] – Add tier1 tag dregadv5: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|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|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]]+The SQLite database engine has limited support for ALTER TABLE statements.  
 +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]}} {{tag>[sqlite3 active tier1]}}
 ------------------------------- -------------------------------
 +
 ===== sqlite ===== ===== sqlite =====
 <WRAP right box round 300px> <WRAP right box round 300px>
v5/database/sqlite.1578916054.txt.gz · Last modified: 2020/01/13 12:47 by dregad