Nishant Gaurav

Compter Science Student (Data Science) | Python • DSA • Databases • C/C++ | Software & Data Science Enthusiast | Microsoft Learn Student Ambassador (Beta) | Open-Source Contributor

Delhi, India Joined on Feb 5, 2026 https://linktr.ee/im_nishant

Pronouns

He/Him

Nishant Gaurav

Oct 22

GROUP BY In PostgreSQL

#postgres #postgressql #sql #database

3 min read

Want to connect with Nishant Gaurav ?

Create an account to connect with Nishant Gaurav . You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Nishant Gaurav

Oct 21

Views vs Materialized Views In PostgreSQL

#postgres #postgressql #database #sql

3 min read

Nishant Gaurav

Oct 20

Transactions, ACID, and MVCC In PostgreSQL

#postgressql #sql #postgres #database

5 min read

Nishant Gaurav

Oct 19

Indexes in PostgreSQL

#postgressql #postgres #sql #database

5 min read

Nishant Gaurav

Oct 18

GROUP BY, HAVING, and Subqueries in PostgreSQL

#postgres #postgressql #sql #database

5 min read

Nishant Gaurav

Oct 17

Joins In PostgreSQL

#postgressql #postgres #sql #database

5 min read

Nishant Gaurav

Oct 16

Where Clause In PostgreSQL

#postgressql #sql #database #mysql

4 min read

Nishant Gaurav

Oct 15

Constraints in PostgreSQL

#postgressql #sql #mysql #database

5 min read

Nishant Gaurav

Oct 14

INSERT, SELECT, UPDATE, DELETE: PostgreSQL

5 min read

Nishant Gaurav

Oct 13

PostgreSQL Data Types:

#postgres #sql #database #mysql

5 min read

Nishant Gaurav

Oct 12

Getting Into PostgreSQL: psql, Connections, and the First Commands You Actually Need

#postgres #sql #postgressql #database

4 min read

Nishant Gaurav

Oct 10

Egg Dropping: Min Outside, Max Inside

#discuss #ai #programming #python

8 min read

Nishant Gaurav

Oct 9

Scrambled String: The MCM Skeleton, Now With Two Strings and a Swap Choice

8 min read

Nishant Gaurav

Oct 8

Boolean Parenthesization: The MCM Skeleton, Counting Instead of Minimising

#discuss #ai #programming #python

7 min read

Nishant Gaurav

Oct 8

Coin Change I: When the Default Value Can Break Everything

#ai #programming #python #beginners

5 min read

Nishant Gaurav

Oct 7

Coin Change II: Counting Ways With Unlimited Coins

#ai #programming #python #datastructures

5 min read

Nishant Gaurav

Oct 7

Palindrome Partitioning: The MCM Skeleton With a New `tempAns`

#discuss #ai #programming #python

4 min read

Nishant Gaurav

Oct 6

Matrix Chain Multiplication: Making the Skeleton Concrete

#discuss #ai #programming #python

5 min read

Nishant Gaurav

Oct 6

Rod Cutting: Unbounded Knapsack With a Different Label on the Inputs

#discuss #datastructures #dp #python

5 min read

Nishant Gaurav

Oct 5

Matrix Chain Multiplication: A New DP Pattern Built on One Question

#ai #webdev #programming #python

5 min read

Nishant Gaurav

Sep 29

A Beginner to Intermediate Guide to Unit Testing in Python with Pytest

#python #pytest #testing #beginners

18 min read

Nishant Gaurav

Sep 27

REST Talks in Plain Text. gRPC Talks in Binary. That's Why It's 7x Faster.

#grpc #api #restapi #devops

3 min read

Nishant Gaurav

Sep 26

Every API You've Learned So Far Waits to Be Called. Webhooks Call You.

#api #webhook #restapi #websocket

3 min read

Nishant Gaurav

Sep 25

REST Asks. GraphQL Asks Smarter. WebSockets Stop Asking Entirely.

#api #websockets #restapi #devops

3 min read

Nishant Gaurav

Sep 24

REST Gives You Everything. GraphQL Gives You Exactly What You Asked For.

#graphql #api #restapi #webdev

3 min read

Nishant Gaurav

Sep 23

REST API Explained: What It Is, How It Works, and What Not to Do

#api #restapi #devops #webdev

5 min read

Nishant Gaurav

Sep 22

You Know REST. Here Are the Five Other API Types That Actually Run the Internet.

#api #restapi #graphql #websockets

8 min read

Nishant Gaurav

Sep 21

The One Function Every Feature in My Geospatial Dashboard Depends On

#haversine #geosptail #formula

4 min read

Nishant Gaurav

Sep 19

Every API in This Series Was Built for Speed. SOAP Was Built for Trust.

#api #soap #restapi #rest

3 min read

Nishant Gaurav

Sep 19

Count Subsets With a Given Difference: Two Equations, One DP Problem

#dsa #programming #dp #knapsack

5 min read

Nishant Gaurav

Sep 18

Minimum Subset Sum Difference & Target Sum

#dp #dsa #algorithms #knapsack

5 min read

Nishant Gaurav

Sep 17

Count of Subsets: One Word Changed. Everything Followed.

#dp #dsa #knapsack #leetcode

5 min read

Nishant Gaurav

Sep 16

Subset Sum and Equal Sum Partition: Same Pattern, Different Question

#algorithms #beginners #computerscience #learning

6 min read

Nishant Gaurav

Sep 15

0/1 Knapsack: The Pattern That Unlocks Half of All DP Problems

6 min read

Nishant Gaurav

Sep 14

Dynamic Programming Isn't Hard. You've Just Been Introduced to It Wrong.

5 min read

Nishant Gaurav

Jun 23

You Use UPI Every Day. Here Is What Actually Happens in Those Two Seconds.

#systemdesign #fintech #stripe #softwareengineering

7 min read

Nishant Gaurav

Jun 16

Your Code Runs Locally. GitHub Actions Makes It Run Everywhere, Automatically.

#github #githubactions #automation #devops

9 min read

Nishant Gaurav

Jun 10

GitHub Already Knows When You Push. It Can Do a Lot More Than Just Watch.

#github #githubactions #devops #automation

5 min read

Nishant Gaurav

Jun 8

You Don't Have a "Works on My Machine" Problem. You Have a Dependency Problem.

#docker #devops #backend #webdev

8 min read

Nishant Gaurav

Feb 13

How to Build a Portfolio Website From Scratch – A Complete Journey

#webdev #frontend #css #portfolio

3 min read

Nishant Gaurav

Feb 5

Building Production-Grade Networking Foundations — From Single Server to Kubernetes

#networking #devops #cloud #webdev

4 min read

Nishant Gaurav

Feb 5

Building Production-Grade Networking Foundations — From Single Server to Kubernetes

#networking #devops #cloud #webdev

4 min read

Writing Debut

Want to connect with Nishant Gaurav ?