This project can use the most popular SQL databases such as PostgreSQL, MySQL, Oracle, MSSQL and Sqlite. This is achieved with Sequelize, the most popular ORM for Node.js
Start the postgres database and other services:
$ npm run docker:up
Connect to the database:
$ psql "postgres://postgres:password@localhost:6432/dev?sslmode=disable"
Here is an example of the configuration for Postgres:
"db":{
"url": "postgres://postgres:password@localhost:6432/dev?sslmode=disable",
"options": {
"logging": true
}
}
Database migration are not necessary for development environment but only for system already in production.
Run the following command to migrate the database:
$ npm run db:migrate