SQLite
Requirements
None: SQLite is built in the driver.
Connection string
The connection string gives the path of the database file:
sqlite:///home/user/demo.db
sqlite://c:/Users/user/demo.db
The file is created if it does not exist. The user name and password are ignored.
Options
updatable_cursors-
emulate updatable cursors (
WHERE CURRENT OF); the table must have a unique key.
Behavior
- SQLite accepts the
$1,?and:1placeholders. - SQLite types are dynamic: the conversion is driven by the type of the host variable.
NoteTo be verified
Autocommit and cursor behavior of the SQLite driver.