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 :1 placeholders.
  • 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.