Connect MariaDB or JawsDB MariaDB with Heroku and MariaDB node connector

node-jawsdb-mariadb.js

// https://github.com/mariadb-corporation/mariadb-connector-nodejs/blob/master/documentation/connection-options.md

require("dotenv").config();
const mariadb = require("mariadb");

(async () => {
  let conn;
  
  if (process.env.APP_ENV == "heroku") {
    conn = await mariadb.createConnection(
      `${process.env.JAWSDB_MARIA_URL}?decimalAsNumber=true&bigIntAsNumber=true`
    );
  } else {
    conn = await mariadb.createConnection({
      host: process.env.DB_HOST,
      user: process.env.DB_USER,
      password: process.env.DB_PASSWORD,
      database: process.env.DB_DATABASE,
      decimalAsNumber: true,
      bigIntAsNumber: true,
      trace: true,
    });
  }
})();