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 = "dailyrewards.db"
}
| Key | Default | Meaning |
|---|---|---|
file | "dailyrewards.db" | The file name, inside plugins/uxmDailyRewards/data/ |
table-prefix | "uxmdailyrewards_" | The prefix of every table |
The file is plugins/uxmDailyRewards/data/dailyrewards.db, with dailyrewards.db-wal and dailyrewards.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.
Backing up
Stop the server, then copy data/dailyrewards.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?