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. It 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 SQLite database engine has limited support for ALTER TABLE statements. For more information, refer to the SQLite documentation.
Consequently, some of ADOdb's Data Dictionary functions are not supported, as per the table below:
| Meta Function | ADOdb | SQLite |
|---|---|---|
| alterColumnSql() | Unsupported | |
| renameColumnSql() | >= 5.23.0 | >= 3.25.0 |
| dropColumnSql() | >= 5.23.0 | >= 3.35.0 |
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: 2024/12/15 15:38 by dregad