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 = "cosmetics.db"
}
| Key | Default | Meaning |
|---|---|---|
file | "cosmetics.db" | The file name, inside plugins/uxmCosmetics/data/ |
table-prefix | "uxmcosmetics_" | The prefix of every table |
The file is plugins/uxmCosmetics/data/cosmetics.db, with cosmetics.db-wal and cosmetics.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/cosmetics.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?