Snowflake provides the best warehouse cloud solution. Snowflake is a data warehouse built on top of the Amazon Web Services or Microsoft Azure cloud infrastructure. To connect Snowflake in NodeJS required snowflake-SDK.

The snowflake SDK lacks documentation. So in this article, we will discuss how to create a wrapper to execute snowflake SQL statements. The first step is to install the snowflake. Check below npm install.

npm i snowflake-sdk

After the snowflake is installed, create types for snowflakes.

npm i -D @types/node @types/snowflake-sdk

Now once the snowflake is installed, we are good to import it.

import * as snowflake from…

NestJS is a framework for building serverside NodeJS applications. NestJS comes with the philosophy of Angular application. When I say Angular like application that means loosely coupled, highly scalable architecture. NestJS adopted both TypeScript and Angular features. TypeScript makes it easy to define data types. TypeScript comes with both basic as well as advanced data types. We can also make complex use cases using TypeScript. Angular comes with features of Inheritance, advanced dependency injection, dynamic modules, and service. These Angular features help in creating large enterprise applications with scalability. NestJS uses both TypeScript and Angular features on the server-side.

Problem with NodeJS and NestJS abstraction

NodeJS…


JavaScript array standard library comes with a variety of methods. These methods help in finding output based on the input provided. There are plenty of articles but they are not focused on practical implementation.

Photo by Paweł Czerwiński on Unsplash

Check the attached stackblitz project.

some(any) vs every(all): Basic Difference

Is Array.any() exist in the JavaScript? The answer is no. However, Array.some() do the purpose of getting any elements. The method Some will return true when the first matching condition will be met. In the below code we have product array which consists of product name, subscription validity, and payment approval element.

let productArray =[{productName:”Netflix”,isSubscriptionValid:true, isPaymentApproved:false},{productName:”Amazon Video”,isSubscriptionValid:false, isPaymentApproved:false},

Handling large data set in the drop-down in Angular is challenging. When there are millions of records. The dropdown renders data very slow. In these scenarios, we can use web controls that are more optimized and render data when needed.

Photo by Caleb Woods on Unsplash showing the incredible vastness/hugeness of Universe

Issues with traditional dropdown and Solution in Angular

Issues with traditional drop-down is it bind all data at one go. So when data increases, i.e. 10,000 plus dataset. The dropdown is so slow it takes a few seconds to open and render each element and properties.

There are different approaches to render the dropdown row faster.

  1. Pull all the data on the client-side and render when row is…

Reactive programming is one of the old approaches of doing programming. The adoption of coding reactive programming in the Angular community is slow. In this article, we will compare the traditional and functional reactive programming in Angular.

Photo by Tim on Unsplash

What is Reactive programming in Angular?

The book definition of reactive programming is below. Reactive programming follow three basic design pattern observable, iterative, and functional programming paradigm.

Reactive programming is a declarative programming paradigm concerned with data streams and the propagation of change. With this paradigm, it is possible to express static (e.g., arrays) or dynamic (e.g., …


TypeScript supports the inheritance concept. Certain times, it is very easy to reuse the code using inheritance. If Angular components have similar or identical code, It is very easy to extend a class and reuse the code. This way we can easily avoid copy-pasting the same code block over and over in the components.

Reuse Photo by Noah Buscher on Unsplash

Benefits of using Inheritance in Angular

  • Reuse the component code when they have common code and common functionality.
  • Create a base component class and extend it to all other components. This base component may contain many reusable code blocks.
  • Create a base service class to call the APIs and reuse it in…

Hazelcast is a distributed in-memory data grid platform for java. The architecture supports high scalability and data distribution in a clustered environment. It supports auto-discovery of nodes and intelligent synchronization. In this article, we will discuss how to implement Hazelcast server-client cache implementation in spring boot.

Hazel cluster

Hazelcast is automatically imported with the discovery-client-dependency and when enabled all the hazelcast-enabled apps will attempt to join with other members(called peers) and forms a cluster. The cluster has many functions including the ability to form a distributed map such that key-value pairs can be shared across all instances.

In this article, we will…


Microsoft came with the new concept of .NET Core framework. Though the .NET Framework itself is a very old and stable framework. However, it was limited to the windows operating system. .NET Core provides the modular and cross-platform support for .NET framework. You can install .NET Core in Linux and Mac operating system. Before creating .NET Core Web API we will walk through in brief about the .NET Core framework.

What is .NET Core?

  • .NET Core is the modular and cross-platform support for .NET framework.
  • .NET Core provides support for building applications in Macintosh and Mac OS architecture.
  • .NET Core provides support for building…

Passing data between the Angular component through the route is very easy after the release of the Angular 7.2 version. NavigationExtras provides an easy way to pass data from the template and from the component. Small components are always good to manage code maintainability. Small components are much more focused and do their specific job well. Passing data using route state make small component more connected.

Photo by Javier Allegue Barros on Unsplash Routing Path

Creating Demo app using NavigationExtras

Create a demo app for learning the NavigationExtras interface. The interface comes with loads of methods that are very useful in maintaining state via routes. The demo application has two components. The first component…


Inheritance is a very powerful concept in the Angular and in the TypeScript. Creating a common base services class encapsulate common code in the other services class. This common piece of code can be used anywhere in the services when the class extends the base service class.

Photo by Bill Jelen on Unsplash

Benefits of using Base service Class

  • Common base class for calling all Get, Post, Put, and Delete calls in the application.
  • Handle the error and show custom error messages to the user is at one place. This can be done in the base service class and then encapsulated in the other service classes.
  • Whenever there is any change in…

Coding In depth

Writing about Angular, React, JavaScript, Java, C#, NodeJS, AWS, MongoDB, and Redis related articles. Please follow, clap stories to motivate us writing more!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store