app/config/database.js
const config = require('config');
const log = require('../src/components/log')(module.filename);
const Sequelize = require('sequelize');
module.exports = {
username: config.get('db.username'),
password: config.get('db.password'),
database: config.get('db.database'),
host: config.get('db.host'),
define: {
charset: 'utf8',
freezeTableName: true,
paranoid: true, // Prevents hard deletions by flagging deletedAt instead
timestamps: true,
underscored: false, // Makes attributes be named with underscores
},
dialect: 'postgres',
isolationLevel: Sequelize.Transaction.SERIALIZABLE,
logging: (query) => log.verbose('Database', query),
migrationStorageTableName: 'sequelize_meta',
pool: {
max: 5,
idle: 10000,
acquire: 60000,
},
seederStorage: 'sequelize',
seederStorageTableName: 'sequelize_data',
};