v5:database:sqlite
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
database:sqlite [2015/12/28 04:27] – mnewnham | v5:database:sqlite [2016/01/13 22:44] – [sqlitepo] mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== SQLite Database ===== | ===== SQLite Database ===== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | ==== sqlite3 ==== | + | ===== sqlite3 |
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
== Specification == | == Specification == | ||
Line 12: | Line 12: | ||
^ADOdb V6|Yes| | ^ADOdb V6|Yes| | ||
== Alternatives == | == Alternatives == | ||
- | [[database: | + | [[v5:database: |
</ | </ | ||
** 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, | + | Note that SQLite table and index names are case-sensitive, |
+ | ==== Limitations in Meta Functions ==== | ||
+ | The driver does not support the following metaFunctions: | ||
+ | * [[v5: | ||
+ | * [[v5: | ||
+ | |||
+ | This is a limitation of Sqlite itself, not ADOdb. For more information see [[http:// | ||
{{tag> | {{tag> | ||
------------------------------- | ------------------------------- | ||
- | ==== sqlite ==== | + | ===== sqlite |
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
== Specification == | == Specification == | ||
Line 35: | Line 41: | ||
{{tag> | {{tag> | ||
--------------------------------------------- | --------------------------------------------- | ||
- | ==== sqlitepo ==== | + | ===== sqlitepo |
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
== Specification == | == Specification == | ||
Line 47: | Line 53: | ||
</ | </ | ||
- | 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> | {{tag> | ||
- |
v5/database/sqlite.txt · Last modified: 2020/01/13 12:47 by dregad