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, the absolute path has to be appended to the DSN prefix.

  • To create a database in memory, :memory: has to be appended to the DSN prefix.

  • If the DSN consists of the DSN prefix only, a temporary database is used, which is deleted when the connection is closed.

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:
sqlite: