Skip to main content
Version: 0.16

SQLite

SQLite is a self-contained, serverless, zero-configuration database engine. Its simplicity and reliability make it well suited to small single-node installations. Data can be replicated for redundancy using external tools such as Litestream, which provides continuous replication of SQLite database files.

Configuration​

The SQLite backend is selected by choosing the Sqlite variant on the DataStore object (found in the WebUI under Settings › Storage › Data Store). The variant exposes the following fields:

  • path: path to the SQLite database file (required). If the file does not exist, it is created automatically.
  • poolMaxConnections: maximum number of concurrent database connections. Default: 10.
  • poolWorkers: number of worker threads dedicated to blocking database operations. Defaults to the number of CPU cores available on the host.