SQlite3 Backend - "sqlite3"

SQlite3 backend allows to connect to SQlite3 database. It uses native SQlite3 C client API.

Connection String

The driver name is "sqlite3", cppdb::session::engine() returns "sqlite3"

Connection Properties are:

• db - the path to sqlite3 database file, special name ":memory:" can be used as well.
• mode - the mode to open connection with, one of "create", "readonly" and "readwrite", default is "create". The difference between "readwrite" and "create" that if the database does not exist the connection fails.
• busy_timeout - the equivalent of sqlite3_busy_timeout function. Specifies the minimal number of milliseconds to wait before returning a error if the database is locked by another process.
• vfs - the name of vfs to use

Implementation Details

Both prepared and not prepared statements are implemented using sqlite3_ API, while unprepared statements just not getting cached unlike prepared ones.

Last insert row id is fetched using sqlite3_last_insert_rowid(), the name of the sequence is ignored.