Database

Dawn of Light Server Support two Database Backend:

• MySQL
• SQLite

The Database implementation rely mostly on Insert/Update/Select/Delete statements for runtime Database Schema Initialization and Upgrade need Create Table/Alter Table/Create Indexes/Drop Indexes/Create Unique Constraint/Drop Unique Constraints statements, SQLite is unable to handle Alter Table statements it won't support Automatic Schema Upgrade

You can switch backend by editing serverconfig.xml

MySQL

MySQL is the full featured Database Backend, it can work with either MySQL or MariaDB and support automatic schema upgrade.

<DBType>MYSQL</DBType>
<DBConnectionString>Server=localhost;Port=3306;Database=DOLDATABASE;User ID=DOLUSER;Password=DOLPASSWORD;Treat Tiny As Boolean=False</DBConnectionString>

SQLite

SQLite is the failsafe Backend, allowing to use DOL Server with no configuration and no third party Database, but it won't support schema upgrade, only Initialization.

<DBType>SQLITE</DBType>
<DBConnectionString>Data Source=./dol.sqlite3.db;Version=3;Pooling=False;Cache Size=1073741824;Journal Mode=Off;Synchronous=Off;Foreign Keys=True;Default Timeout=60</DBConnectionString>