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