Skip to content

[Server] Database Setup Guide

Hyeonwoo Kim edited this page May 22, 2022 · 5 revisions

Summary

In this section, We explain how to setup your SQL database server

BAETAVERSE EER Diagram

배타버스eer

Create Tables by DDL script file

You can define Tables by executing sql file

Be careful as data may be lost if a table with the same name exists

Connect to Express server

Express (API) server have to know your database server informations

...
MYSQL_SERVER_HOST=
MYSQL_SERVER_PORT=
MYSQL_SERVER_USER=
MYSQL_SERVER_PASSWORD=
MYSQL_SERVER_DATABASE=

So, Remember the database server information and enter the information when building the API server

Use Another SQL database

The API server uses typeorm and is tailored to the MySQL database

However, Other sql databases, which supported by typeorm, can also be used (eg postgreSQL, mariaDB)

If you want to use other SQL database, need to edit data-source file