| Driver Name | sqlite3 |
|---|---|
| Data Provider | sqlite |
| Status | Active1) |
| Windows | Yes |
| Unix | Yes |
| ADOdb V5 | Yes |
| ADOdb V6 | Yes |
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.
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 |
| 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.
| 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.