search by tag

NodeJS and MSSQL Connection Pool

March 02, 2022 | 9 min read | 354 Views

In the season of summer, the pool becomes overcrowded and needs to be managed properly; this is not the case for other seasons. On the other hand, the database connections pool needs to be managed irrespective of the seasons. So the need of the hour is to manage these connection pools in order to maintain multiple databases connections, their opening/closing, configurations, etc. In this article, we will understand how to manage NodeJS and MSSQL connection pools like a pro.

Data Access Layer for NodeJS and MSSQL - Part 2

February 06, 2022 | 6 min read | 274 Views

If you like action sequences, this read will definitely give you chills. In this article, without wasting your precious time we will jump straight to the business and understand how to use our bare minimum data access layer which we have built previously.

Data Access Layer for NodeJS and MSSQL - Part 1

December 06, 2021 | 10 min read | 1130 Views

Building a bare minimum data access layer for NodeJS and MSSQL for applications that scream for simplicity. Just like any other layered cake, applications also come in layers Data Access Layer (DAL), Business Access Layer (BAL), Presentation/UI Layer (PL), API Layers, etc. In this article, we are picking up the brush and painting our own data access layer for NodeJS and MS SQL Server.

The file melting Multer with NodeJS and Express

August 18, 2021 | 8 min read | 455 Views

Multer is a mature multipart/form-data supreme middleware for Node.js. Its been there for a long time, already explored and discussed by many elite developers. In this article, we will revisit the core capabilities of the Multer and will explore scenarios like single/multiple file upload using forms or AJAX.

Crafting paginated API with NodeJS and MSSQL

January 27, 2021 | 6 min read | 2007 Views

Paging, sorting and filtering seems too much to handle for a single soul; but the soul of a programmer craves for such trouble. When you have tons of data to show in a grid/table provided with filtering and sorting options then there is no option left to leave these duties to your backend. In this article we will see NodeJS with MSSQL acting as backend and fabricate a paginated, sort and filter enabled API.

Calling Stored Procedure with NodeJS and MSSQL

December 31, 2020 | 6 min read | 8705 Views

Stored procedures, bringing bread and butter for many full stackers. They are the heavy lifters, holds up many business logics, handles input/outputs, returns multiple record sets and tons of more features. Why in this world, one will avoid the communication to happen between the super heroic NodeJS and MSSQL stored procs. In this article we will highlight most of the common scenarios we deal with while calling stored procs with NodeJS and MSSQL.

Teaming up with NodeJS and SQL Server

December 24, 2020 | 10 min read | 1540 Views

It's always satisfying to watch our backend connecting to the database server in one go. Within this short life span we come across different weirdo errors and issues while making the simplest form of connection to a database server; teaming up NodeJS with MS SQL Server is no different. In this article will make a smooth connection between NodeJS and MSSQL, and perform the decade old tradition (CRUD).

Calling API from NodeJS API using Axios

September 18, 2020 | 4 min read | 1621 Views

I found Axios a great library to make calls to a third party API, it's easy to understand, demands lesser coding, Promise me to return the data, works perfectly with a async/await style, get along with TypeScript.

Getting Started with NodeJS Express using TypeScript

August 22, 2020 | 6 min read | 3096 Views

TypeScript teaches some manners to write JavaScript code. A well written JavaScript code (TypeScript) grabs many attention in the party; so why not we simply include TypeScript to write Nodes Express APIs? Great idea! And both NodeJS and Express play very well with this decision.