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
Last revisionBoth sides next revision
v5:database:sqlite [2016/01/13 01:53] – ↷ Page moved from database:sqlite to v5:database:sqlite mnewnhamv5:database:sqlite [2016/02/01 21:49] – [sqlite3] mnewnham
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.
  
 ==== Limitations in Meta Functions ==== ==== Limitations in Meta Functions ====
 The driver does not support the following metaFunctions: The driver does not support the following metaFunctions:
-  * [[dictionary:alterColumnSql()]]  +  * [[v5:dictionary:altercolumnsql|alterColumnSql()]]  
-  * [[dictionary:dropColumnSql()]]+  * [[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]] This is a limitation of Sqlite itself, not ADOdb. For more information see [[http://www.sqlite.org/lang_altertable.html|Here]]
Line 53: 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.txt · Last modified: 2020/01/13 12:47 by dregad