SQLite
The default backend, where the file lives, and backing it up.
SQLite is a database in one file, with nothing to install. It is the default and right for a single server.
storage {
type = "sqlite"
file = "kotl.db"
}
| Key | Default | Meaning |
|---|---|---|
file | "kotl.db" | The file name, inside plugins/uxmKotl/data/ |
table-prefix | "uxmkotl_" | The prefix of every table |
The file is plugins/uxmKotl/data/kotl.db, with kotl.db-wal and kotl.db-shm beside it while the server
runs. A file an older version left in the plugin folder is moved into data/ on the first start.
SQLite takes one writer, so the pool uses one connection whatever pool-size says, and sync-seconds reads nothing:
one file belongs to one server.
Backing up
Stop the server, then copy data/kotl.db and, if present, the -wal and -shm files. A copy taken while the server
runs may miss the last writes. uxmBackup can archive the folder on a schedule.
Related: Overview, MySQL and MariaDB
Was this page helpful?