For SQLite

sqlite://path-to-DB-file?
   autocommit=1& [3.3.0]
   
multi_statements=0& [3.3.0]


Path to file with database specified from document_root.
As path to file with database the driver also accepts special values
:memory: and :temporary:. First one means that for this session will be created temporary database in memory. Second one-for this session will be created temporary database on disk (you don't need to remove database file manually).

autocommit-by default SQLite commits all queries automatically. If this option sets to 0, Parser executes BEGIN statement at the beginning and COMMIT/ROLLBACK at the end of operator connect, so all statements in one connect operator will be executed in single transaction;
multi_statements-if set to 1, the single SQL query can contains more then one SQL statements separated by ";" character (character ";" must be escaped by character "^").

Examples:
Assume, file my.db with database located in data directory which located near your document root directory. Connect string should look like this:
sqlite://../data/my.db

Assume, you need temporary table in memory without autocommit (one connect-one transaction). Connect string should look like this:
sqlite://:memory:?autocommit=0




Copyright © 1997–2021 Art. Lebedev Studio | http://www.artlebedev.com Last updated: 03.07.2008