@tadashi/mysql-pool
TypeScript icon, indicating that this package has built-in type declarations

3.0.0 • Public • Published

mysql-pool

NPM version Build Status Coverage Status

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

Lagden


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

License

MIT © Thiago Lagden

Package Sidebar

Install

npm i @tadashi/mysql-pool

Weekly Downloads

1

Version

3.0.0

License

MIT

Unpacked Size

17.3 kB

Total Files

15

Last publish

Collaborators

  • lagden