Can i make a connection pool from nodejs to Azure table Storage?

Juan David 0 Reputation points
2023-09-19T18:45:41.4366667+00:00

Hello everyone, I have a question: I want to establish a connection between Node.js and Azure Table Storage. To achieve this, I have been using the @azure/data-tables library for the connection. I would like to know if it's possible to improve the connection (since multiple queries to tables in a data lake are required to display their entities) by implementing something similar to a connection pool, like in database queries, or if it's not necessary. Thank you!

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
138 questions
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,128 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,129 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Siva Villa 85 Reputation points Microsoft Employee
    2023-09-26T03:25:58.1766667+00:00

    I would like to update you that azure storage operates on an HTTP-based Request/Response model. When you send a request to Azure Storage, it promptly responds, after which the connection is gracefully closed. Hence, it is not feasible to maintain an open connection to an Azure Storage account, and the implementation of connection pooling is not possible in this context.

    The thread below discussed a similar query.
    https://stackoverflow.com/questions/24531458/connection-pooling-on-azure-storage

     The following article talks about the azure storage rest api.  https://learn.microsoft.com/en-us/rest/api/storageservices/

    Please do let me know if you have any additional questions with regards to this question.

    0 comments No comments