v5:database:sqlite
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
database:sqlite [2015/07/18 15:49] – created mnewnham | v5:database:sqlite [2016/01/13 22:25] – [sqlitepo] mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== SQLite Database ===== | ===== SQLite Database ===== | ||
- | See also the [[PDO]] driver for SQLite | + | ~~NOTOC~~ |
- | ==== sqlite3 ==== | + | ===== sqlite3 ===== |
- | + | < | |
- | < | + | == Specification == |
- | |Driver Name|sqlite3| | + | ^Driver Name|sqlite3| |
- | |Status|Active| | + | ^Data Provider|sqlite| |
- | |Windows|Yes| | + | ^Status|Active((This driver is actively supported by ADOdb project members))| |
- | |Unix|Yes| | + | ^Windows|Yes| |
+ | ^Unix|Yes| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | == Alternatives == | ||
+ | [[v5: | ||
</ | </ | ||
- | This preferred driver supports connections to SQLite version 3 databases | + | ** This is the preferred driver for connecting to sqlite databases ** |
- | {{tag> | + | This preferred driver supports connections to SQLite version 3 databases. |
- | ==== sqlite ==== | + | Note that SQLite table and index names are case-sensitive, |
- | < | + | |
- | |Driver Name|sqlite| | + | ==== Limitations in Meta Functions ==== |
- | |Status|Deprecated| | + | The driver does not support the following metaFunctions: |
- | |Windows|Yes| | + | * [[v5: |
- | |Unix|Yes| | + | * [[v5: |
+ | |||
+ | This is a limitation of Sqlite itself, not ADOdb. For more information see [[http:// | ||
+ | {{tag> | ||
+ | ------------------------------- | ||
+ | ===== sqlite ===== | ||
+ | < | ||
+ | == Specification == | ||
+ | ^Driver Name|sqlite| | ||
+ | ^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| | ||
</ | </ | ||
This deprecated driver supports SQLite Version 2 databases. | This deprecated driver supports SQLite Version 2 databases. | ||
{{tag> | {{tag> | ||
+ | --------------------------------------------- | ||
+ | ===== 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| | ||
</ | </ | ||
- | This deprecated driver | + | This deprecated driver |
- | {{tag> | + | {{tag> |
v5/database/sqlite.txt · Last modified: 2020/01/13 12:47 by dregad