DUXPLIMA Documentation

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 = "languages.db"
}
KeyDefaultMeaning
file"languages.db"The file name, inside plugins/uxmLang/data/
table-prefix"uxmlang_"The prefix of every table

The file is plugins/uxmLang/data/languages.db, with languages.db-wal and languages.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. One file belongs to one server.

Backing up

Stop the server, then copy data/languages.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