SQLite connection strings

• In-Memory Database

  An SQLite database is normally stored on disk but the database can also be stored in memory. Read more about SQLite in-memory databases here.

  Data Source=:memory:;Version=3;New=True;

  SQLite

• Using UTF16

  Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;

  SQLite

• With password

  Data Source=c:\mydb.db;Version=3;Password=myPassword;

  SQLite

• Using the pre 3.3x database format

  Data Source=c:\mydb.db;Version=3;Legacy Format=True;

  SQLite

• With connection pooling

  Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.

  Data Source=c:\mydb.db;Version=3;Pooling=True;Max Pool Size=100;

  SQLite

• Read only connection

  Data Source=c:\mydb.db;Version=3;Read Only=True;

  SQLite

• Using DateTime.Ticks as datetime format

  Data Source=c:\mydb.db;Version=3;DateTimeFormat=Ticks;

  The default value is ISO8601 which activates the use of the ISO8601 datetime format

  SQLite

• Store GUID as text

  Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.

  Data Source=c:\mydb.db;Version=3;BinaryGUID=False;

  Note that storing GUIDs as text uses more space in the database.

  SQLite

• Specify cache size

  Data Source=c:\mydb.db;Version=3;Cache Size=2000;

  The Cache Size value measured in bytes

  SQLite

• Specify page size

  Data Source=c:\mydb.db;Version=3;Page Size=1024;

  The Page Size value measured in bytes

  SQLite

• Disable enlistment in distributed transactions

  Data Source=c:\mydb.db;Version=3;Enlist=N;

  SQLite

• Disable create database behaviour

  If the database file doesn‘t exist, the default behaviour is to create a new file. Use the following parameter to raise an error instead of creating a new database file.

  Data Source=c:\mydb.db;Version=3;FailIfMissing=True;

  SQLite

• Limit the size of database

  Data Source=c:\mydb.db;Version=3;Max Page Count=5000;

  The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.

  SQLite

• Disable the Journal File

  This one disables the rollback journal entirely.

  Data Source=c:\mydb.db;Version=3;Journal Mode=Off;

  SQLite

• Persist the Journal File

  This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.

  Data Source=c:\mydb.db;Version=3;Journal Mode=Persist;

  SQLite

• Controling file flushing

  Data Source=c:\mydb.db;Version=3;Synchronous=Full;

  Full specifies a full flush to take action after each write. Normal is the default value. Off means that the underlying OS flushes I/O‘s.

  SQLite

? Problems connecting?   Get answer in the SQLite Q & A forum →

SQLite connection strings

标签：