@srvjha

All you need to know about SQL Queries

6d ago · 8 min read · In this article, we will cover how to write SQL commands, along with a few tips and things to keep in mind while writing queries, and how to write optimized queries. SQL commands are categorized into

Your Data Is Not Actually Stored in a Database

6d ago · 8 min read · While you may wonder why I wrote this title, but you will get the point once you read the whole article. So whenever we talk about databases, one thing that comes to our mind is that to store data we

System Design : Consistent Hashing

Mar 23 · 6 min read · Why do we need Consistent Hashing ? Imagine you are building a bookMyShow system which is used to book tickets. Initially what would be your system? All user requests (search, booking, payments) go

System Design: Understanding Kafka Architecture

Mar 16 · 4 min read · Suppose you are watching a cricket match IND vs AUS, World Cup Final 2023 :( . While checking the live score, you expect updates to appear in the correct sequence. For example: After 2 overs → IND 10

System Design : Message Queue (RabbitMQ)

Mar 9 · 7 min read · What is a Queue? A queue is a fundamental concept in software engineering used to manage tasks or messages that need to be processed in a specific order (FIFO). It provides a mechanism for decoupling