← Back To API Reference

Resource management

Managing resources properly without leaks can be challenging. Simply using .finally is not enough as the following example demonstrates:

function doStuff() {
    return Promise.all([
        fs.readFileAsync("file.sql", "utf8")
    ]).spread(function(connection, fileContents) {
        return connection.query(fileContents).finally(function() {
    }).then(function() {
        console.log("query successful and connection closed");

It is very subtle but over time this code will exhaust the entire connection pool and the server needs to be restarted. This is because reading the file may fail and then of course .spread is not called at all and thus the connection is not closed.

One could solve this by either reading the file first or connecting first, and only proceeding if the first step succeeds. However, this would lose a lot of the benefits of using asynchronity and we might almost as well go back to using simple synchronous code.

We can do better, retaining concurrency and not leaking resources, by using:

  • disposers, objects that wrap a resource and a method to release that resource, together with
  • Promise.using, a function to safely use disposers in a way that automatically calls their release method
var using = Promise.using;

      fs.readFileAsync("file.sql", "utf8"), function(connection, fileContents) {
    return connection.query(fileContents);
}).then(function() {
    console.log("query successful and connection closed");

Continue by reading about disposers and Promise.using