v5:database:sqlite
SQLite Database
sqlite3
Specification
| Driver Name | sqlite3 |
|---|---|
| Data Provider | sqlite |
| Status | Active1) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | Yes |
Alternatives
This is the preferred driver for connecting to sqlite 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 IBM DB2 driver.
Limitations in Meta Functions
The driver does not support the following metaFunctions:
This is a limitation of Sqlite itself, not ADOdb. For more information see Here
sqlite
Specification
| Driver Name | sqlite |
|---|---|
| Data Provider | sqlite |
| Status | Obsolete2) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | No |
This deprecated driver supports SQLite Version 2 databases.
sqlitepo
Specification
| Driver Name | sqlitepo |
|---|---|
| Data Provider | sqlite |
| Status | Obsolete3) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | No |
This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries.
v5/database/sqlite.txt · Last modified: 2020/01/13 12:47 by dregad