SQLite Driver
Driver Name: sqlite
Driver Connection String Options:
- path: Required. Filesystem path to SQLite database.
- journal_mode: Optional. Defaults to "WAL" if not specified, other options include "DELETE".
- analyze: Optional. Defaults to "TRUE" if not specified. On first connect, automatically runs an analyze to update index statistics if set to "TRUE".
- integrity_check: Optional. Defaults to "FALSE" if not specified. On first connect, automatically runs an integrity check to verify the database integrity if set to "TRUE".
- shared_cache: Optional. Defaults to "TRUE" if not specified. Enables shared cache mode for multiple connections to the same database.
- autocreate: Optional. Defaults to "TRUE" if not specified. The default is to auto-create the database if not found, set this to "FALSE" to error if the database does not exist.