azerothcore-wotlk
azerothcore-wotlk copied to clipboard
azerothcore
Feature: SQLite support
Describe your feature request or suggestion in detail
SQLite is an alternative database solution that removes the need for a mysql service to run alongside the server. This can improve development workflows, decrease repack dependencies, and increase accessibility to a wider audience.
The CMaNGOS emulator recently implemented this and even includes a sqlite database with their databases releases.
Describe a possible solution to your feature or suggestion in detail
As mentioned, CMaNGOS has already implemented this. There will be some differences between the emulators, but it should act as a decent guide.
Relevant PRs
- https://github.com/cmangos/mangos-wotlk/pull/473
- https://github.com/cmangos/mangos-wotlk/pull/486
- https://github.com/cmangos/mangos-wotlk/pull/487
Additional context
Due to AzerothCore's modules and the popularity of its repacks, particularly those that aim at a single player or limited player experience, this removes an extra service that the user is required to run. Character and World databases become a single file. Easily backed up or transferred between servers. This can help developers who want to quickly swap between a stock database and a modified one (swap out the world.db file).
