azerothcore / Keira3

Official Database Editor for AzerothCore. Completely open-source and cross-platform, built with modern web technologies.
https://www.azerothcore.org/Keira3
GNU Affero General Public License v3.0
351 stars 148 forks source link
azerothcore azerothcore-tools database-editor tools

Keira3

CodeFactor Actions Status Discord

Keira3 Website

Keira3

Cross-platform desktop application featuring a Database Editor for the AzerothCore MMORPG framework.

With Keira3 you don't have to know the SQL language in order to change contents: it will generate the SQL queries automatically for you. The SQL code will be displayed, so you can learn, and then you can copy or execute it directly to your database.

Made with ❤ and TypeScript, Electron, Angular, Bootstrap.

Support us

You can support the Keira3 development by donating with PayPal.

Inspired by

We created Keira inspired by the old indomit's Quice/Truice database editor, and by the Discover-'s SAI Editor. Our primary goal was to provide an editor with the same features that was cross-platform, so we built it as a web app.

Keira3 is the direct successor of Keira2. We kept the cross-platform promise as well as adding the possibility to execute the generated queries and simplifying the application setup.

AzerothCore Database

In order to use Keira3 you have to connect to an instance of the AzerothCore Database.

If you don't have any, you can easily create one following this guide.

Alternatively, you can use a public database of AzerothCore with read-only access. Details here.

How to install Keira3

To use Keira3, you don't need to install any dependency. Just download and run it.

:warning: Windows 7 or older Windows versions are not officially supported.

How to run Keira3 in development mode

Dependencies

Note: these are the dependencies if you want to run Keira3 in development mode. If you just want to use Keira3, download it from the releases page.

You need to first install node in order to have npm available in your system.

This project uses NX, you can install it globally using npm install -g nx@latest

Then install the dependencies using:

npm install

Only for Windows (Windows 7 or older versions are not officially supported), install windows-build-tools as administrator:

npm install --global-production windows-build-tools

This installation will take time and probably your PC will reboot during the installation.

Running checks on projects

The entire codebse is organised in NX projects (apps and libraries), that are located in:

All lib paths are declared in the tsconfig.base.json and their names are:

Examples:

You can run checks such as lint or test of any project using:

Examples:

Run the app

To run the app in local development with hot reload:

npm start

More commands:

Command Description
npm run lint Run lint of affected projects
npm run test Run unit tests of affected projects
npm run e2e Run e2e tests. It requires to run npm run build:prod first
npm run build Build the app. Your built files are in the /dist folder.
npm run build:prod Build the app with Angular aot. Your built files are in the /dist folder.
npm run electron:local Builds your application and start electron
npm run electron:linux Builds your application and creates an app consumable on linux system
npm run electron:windows On a Windows OS, builds your application and creates an app consumable in windows 32/64 bit systems
npm run electron:mac On a MAC OS, builds your application and generates a .app file of your application that can be run on Mac

Note: Only /dist folder and node dependencies will be included in the executable.

Learn