db.js

import mariadb from 'mariadb'
import dotenv from 'dotenv'
dotenv.config();
const pool = mariadb.createPool({
     host: process.env.MARIA_DB_HOST, 
     user: process.env.MARIA_DB_USER,
     password: process.env.MARIA_DB_PASSWORD,
     connectionLimit: 5,
     database: process.env.MARIA_DB_DATABASE
});

const connection = await pool.getConnection();

export default connection;