2.2.4.1 Database Config (Sequelize + PostgreSQL)

// src/config/db.js
require('dotenv').config();
const { Sequelize } = require('sequelize');

const sequelize = new Sequelize(process.env.DATABASE_URL, {
  dialect: 'postgres',
  logging: false, // set true if you want SQL logs
});

module.exports = sequelize;

syncing & connection:

// src/index.js
const sequelize = require('./config/db');

(async () => {
  try {
    await sequelize.authenticate();
    console.log('PostgreSQL connected.');

    // optionally sync models in dev mode
    // await sequelize.sync({ force: false });

    // start server...
  } catch (err) {
    console.error('Error connecting DB:', err);
  }
})();

Last updated