@cityssm/mssql-multi-pool v3.1.5
mssql-multi-pool
A simple way to manage connections to multiple SQL Server databases using the Node.js Tedious driver.
Why?
The fantastic node-mssql package provides an easy and reliable way to connect to one SQL Server instance.
Connecting to multiple SQL Server instances is where things get trickier. Not too tricky, but it is more involved as you can't rely on the global pool. There is some sample code in the node-mssql README that shows how to do it. This project implements that sample code.
Installation
npm install @cityssm/mssql-multi-pool
Usage
Replace the connect(config);
command from the mssql
package
with the connect(config);
command from the @cityssm/mssql-multi-pool
package.
If the configuration object describes an unseen database, a new pool is made. Otherwise, the previously made pool is used.
import * as sql from '@cityssm/mssql-multi-pool'
;(async function () {
try {
let pool = await sql.connect(config)
// Use the `mssql` package like before.
} catch (e) {}
})()
16 days ago
18 days ago
19 days ago
19 days ago
19 days ago
24 days ago
10 months ago
6 months ago
11 months ago
11 months ago
1 year ago
1 year ago
2 years ago
2 years ago
2 years ago
2 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
4 years ago