mysql-pool

Make pooling connections with MySQL

Install

$ npm i @tadashi/mysql-pool

Environment variable

| Variable | Type | Required | Default | Description | | -------------------- | ------- | -------- | --------- | ----------------------------------- | | MYHOST | string | no | localhost | Hostname or server address | | MYPORT | number | no | 3306 | Port number for the connection | | MYUSER | string | no | root | User authentication | | MYPASS | string | no | | Authentication password | | MYLIMIT | number | no | 5 | Limit or threshold value | | MYCONNECTTIMEOUT | number | no | 30000 | Connection timeout in milliseconds | | MYMULTIPLE | boolean | no | true | Allowing multiple statements | | MYWAITFORCONNECTIONS | boolean | no | true | Waiting for available connections | | MYENCODE | number | no | 0 | MYUSER and MYPASS encoded in base64 |

Usage

import MysqlPool from '@tadashi/mysql-pool'

const pool = new MysqlPool() // => https://sidorares.github.io/node-mysql2/docs/examples/connections/create-pool
const { results: [{ total }] } = await pool.query('SELECT 1 + ? as total', [1])
// => 2

// Closing all the connections in a pool
await pool.end()

Team

[!IMPORTANT]
Buy me a coffee!
BTC: bc1q7famhuj5f25n6qvlm3sssnymk2qpxrfwpyq7g4

License

MIT © Thiago Lagden