PDO_SQLITE DSN
(PECL PDO_SQLITE >= 0.2.0)
PDO_SQLITE DSN — Connecting to SQLite databases
Description
The PDO_SQLITE Data Source Name (DSN) is composed of the following elements:
- DSN prefix (SQLite 3)
-
The DSN prefix is sqlite:.
-
To access a database on disk, append the absolute path to the DSN prefix.
-
To create a database in memory, append :memory: to the DSN prefix.
- DSN prefix (SQLite 2)
-
The SQLite extension in PHP 5.1 provides a PDO driver that supports accessing and creating SQLite 2 databases. This enables you to access databases you may have created with the SQLite extension in previous versions of PHP.
Note:
The sqlite2 driver is only available in PHP 5.1.x if you have enabled both PDO and ext/sqlite. It is not currently available via PECL.
The DSN prefix for connecting to SQLite 2 databases is sqlite2:.
-
To access a database on disk, append the absolute path to the DSN prefix.
-
To create a database in memory, append :memory: to the DSN prefix.
Examples
Example #1 PDO_SQLITE DSN examples
The following examples show PDO_SQLITE DSN for connecting to SQLite databases:
sqlite:/opt/databases/mydb.sq3 sqlite::memory: sqlite2:/opt/databases/mydb.sq2 sqlite2::memory:
