NodeJS

패키지 설치

"dependencies": {
  "dotenv": "latest",
  "knex": "latest",
  "mysql2": "latest"
}

npm install

모듈

/modules/db.js

import knex from 'knex';
import dotenv from 'dotenv';

dotenv.config();

const db = knex({
  client: 'mysql2',
  connection: {
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_DATABASE,
  },
});

export default db;