ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:sqlite

SQLite Database

sqlite3

Specification
Driver Namesqlite3
Data Providersqlite
StatusActive1)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6Yes
Alternatives

PDO driver for SQLite

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 Namesqlite
Data Providersqlite
StatusObsolete2)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6No

This deprecated driver supports SQLite Version 2 databases.


sqlitepo

Specification
Driver Namesqlitepo
Data Providersqlite
StatusObsolete3)
WindowsYes
UnixYes
ADOdb V5Yes
ADOdb V6No

This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries.

1)
This driver is actively supported by ADOdb project members
2) , 3)
This driver is obsolete and will be removed in ADOdb V6
v5/database/sqlite.txt · Last modified: 2020/01/13 12:47 by dregad