Pascal Data Objects

SQLite DSN Options

The PDO SQLite 3 Data Source Name (DSN) is composed of the following elements:

The DSN prefixes are sqlite-2 and sqlite-3

location: To access a database on disk, append the absolute path to the DSN prefix.
memory: To create a database in memory, append true to the DSN prefix.

Examples

pdo:sqlite-3://location=/opt/databases/mydb.sq3
pdo:sqlite-2://memory=true