When is a connection closed or can we explicitly close a connection?

[JonathanFu]

I haven't seem an example for closing a connection.
There are some logic related creating connection pool and closing connection pool shown as below.

new sql.ConnectionPool(config).connect().then(pool => {...
pool.close();

So when is a connection released?
Or can we explicitly close a connection (if necessary)?

[patriksimek]

It depends on your configuration. Connections are created automatically when you execute a request. Maximum number of concurrent connections is configurable via pool.max option. The pool. idleTimeoutMillis option tells the pool how long should the connection stay idle before it is removed from the pool. You can also change the pool.min option that specifies the minimum number of connections there can be in the pool.

So, the connections are created/released automatically based on those three options. There is no way to close the connection explicitly. Once you call pool.close(), all active connections in the pool will be closed.

[JonathanFu]

@patriksimek
Thanks for explanation.
Yes, I agree, basically the pool settings are enough.