knexfile.js

// Update with your config settings.
require("dotenv").config();


const {
  NODE_ENV = "development",
  DEVELOPMENT_DATABASE_URL,
  PRODUCTION_DATABASE_URL,
} = process.env;
const URL = 
NODE_ENV === "production"
  ? PRODUCTION_DATABASE_URL
  : DEVELOPMENT_DATABASE_URL;

module.exports = {

  development: {
    client: 'postgresql',
    connection: URL,
    migrations: {
      directory: __dirname + "/src/db/migrations",
    }
  },

  staging: {
    client: 'postgresql',
    connection: URL,
    pool: {
      min: 2,
      max: 10
    },
    migrations: {
      directory: __dirname + "/src/db/migrations",
    }
  },

  production: {
    client: 'postgresql',
    connection: URL,
    pool: {
      min: 2,
      max: 10
    },
    migrations: {
      directory: __dirname + "/src/db/migrations",
    }
  }

};