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/11/26 21:57] 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> +<WRAP right box round 300px
-==Alternative Drivers== +== Specification == 
-[[database:pdo#pdo_sqlite|PDO driver for SQLite]]+^Driver Name|sqlite3| 
 +^Data Provider|sqlite| 
 +^Status|Active((This driver is actively supported by ADOdb project members))| 
 +^Windows|Yes| 
 +^Unix|Yes| 
 +^ADOdb V5|Yes| 
 +^ADOdb V6|Yes| 
 +== Alternatives == 
 +[[v5:database:pdo#pdo_sqlite|PDO driver for SQLite]]
 </WRAP> </WRAP>
-<WRAP left 300px box> 
 ** This is the preferred driver for connecting to sqlite databases ** ** This is the preferred driver for connecting to sqlite databases **
-|Driver Name|sqlite3| +This preferred driver supports connections to SQLite version 3 databases.
-|Status|Active| +
-|Windows|Yes| +
-|Unix|Yes| +
-</WRAP> +
-This preferred driver supports connections to SQLite version 3 databases. If you are using this driver in a portable application, consider using the sqlitepo driver.+
  
-===== Support Status ===== +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.
-This driver is actively supported by ADOdb project members+
  
 +==== 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 unix windows active supported]}} +{{tag>[sqlite3 active tier1]}} 
- +------------------------------- 
-==== sqlite ==== +===== sqlite ===== 
-<WRAP left 300px box> +<WRAP right box round 300px
-|Driver Name|sqlite| +== Specification == 
-|Status|Deprecated+^Driver Name|sqlite| 
-|Windows|Yes| +^Data Provider|sqlite| 
-|Unix|Yes|+^Status|Obsolete((This driver is obsolete and will be removed in ADOdb V6))
 +^Windows|Yes| 
 +^Unix|Yes
 +^ADOdb V5|Yes| 
 +^ADOdb V6|No|
 </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 =====
 +<WRAP right box round 300px>
 +== Specification ==
 +^Driver Name|sqlitepo|
 +^Data Provider|sqlite|
 +^Status|Obsolete((This driver is obsolete and will be removed in ADOdb V6))|
 +^Windows|Yes|
 +^Unix|Yes|
 +^ADOdb V5|Yes|
 +^ADOdb V6|No|
  
-==== sqlitepo ==== 
-<WRAP left 300px box> 
-|Driver Name|sqlitepo| 
-|Status|Deprecated| 
-|Windows|Yes| 
-|Unix|Yes| 
 </WRAP> </WRAP>
-This deprecated driver adds portability to the sqlite 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 unix windows deprecated portable]}} +{{tag>[sqlite2 deprecated]}}
v5/database/sqlite.1448571458.txt.gz · Last modified: 2017/04/21 11:23 (external edit)