knex——nodejs连接数据库-526互联

前言：最近用到了新工具knex——nodejs连接数据库，感觉很不错的库，记录一下使用过程。

一、介绍

二、配置

import dotenv from 'dotenv'
dotenv.config()

const Config = {
  client: 'pg',
  connection: process.env.DB_URL,
  acquireConnectionTimeout: 5000,
  pool: {
    min: 2, // Minimum number of connections in the pool
    max: 20, // Maximum number of connections in the pool
    // propagateCreateError: false, // enabling knex to automatically reconnect on create connection failure instead of throwing the error.
  },
  migrations: {
    directory: './migrations',
  },
  seeds: { directory: './seeds' },
}

const knexConfig = { Dev: Config, Beta: Config, Prod: Config }

export default knexConfig