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 [2025/06/01 13:21] (current) – Remove square brackets in tags 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.  
-{{tag>[sqlite3 active tier1]}}+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 39: Line 50:
 </WRAP> </WRAP>
 This deprecated driver supports SQLite Version 2 databases.  This deprecated driver supports SQLite Version 2 databases. 
-{{tag>[sqlite2 unix windows deprecated]}}+{{tag>sqlite2 unix windows deprecated}}
 --------------------------------------------- ---------------------------------------------
 ===== sqlitepo ===== ===== sqlitepo =====
Line 54: Line 65:
 </WRAP> </WRAP>
 This deprecated driver added portability to the sqlite2 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 deprecated]}}+{{tag>sqlite2 deprecated}}
v5/database/sqlite.1578916054.txt.gz · Last modified: by dregad