SQLite connection string

SQLite connection string

Basic)
Data Source = filename; version = 3;
Using UTF16 (UTF-8 encoding)
Data Source = filename; version = 3; useutf16encoding = true;
With password (with password)
Data Source = filename; version = 3; Password = mypassword;
Using the pre 3.3x database format (using the database format before 3.3x)
Data Source = filename; version = 3; legacy format = true;
Read Only Connection)
Data Source = filename; version = 3; read only = true;
With Connection Pooling (set connection pool)
Data Source = filename; version = 3; pooling = false; Max pool size = 100;
Using datetime. ticks as datetime format ()
Data Source = filename; version = 3; datetimeformat = ticks;

Store guid as text (The GUID is stored as text, which is binary by default)
Data Source = filename; version = 3; binaryguid = false;
More storage space is required if the guid is used as the text storage.
Specify cache size (specify the cache size)
Data Source = filename; version = 3; cache size = 2000;
The cache size is in bytes.
Specify page size (specify the page size)
Data Source = filename; version = 2; page size = 1024;
Page size in bytes