📝 Parottasalna Blog
249 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
Introduction to DDL (Data Definition Language) in SQL
When we talk about databases, we usually think of inserting, updating, or deleting data. But before doing any of that, we must first define the struc…
SQLUnderstanding Common Table Expressions (CTE) in SQL — Simplifying Complex Queries
In SQL, we often deal with queries that involve multiple subqueries, aggregations, or recursive lookups. When these start to get long and unreadable,…
Database ManagementPostgreSQL Backups: Protecting Your Data Like an Architect
When you run a database, your data is everything. It powers your applications, analytics, and often, your entire business. Now imagine a sudden power…
ProjectsInventory and Order Management System - MongoDB Capstone Project - MDB-P-002
Overview The Inventory and Order Management System is an end-to-end MongoDB project focused on managing products, suppliers, and customer orders. It …
EducationStudent Progress Tracker - MongoDB Capstone Project - MDB-P-001
Objective Build a Student Progress Tracker to manage students, courses, and their grades — focusing on CRUD, indexing, transactions, aggregation, and…
TechConsistent Hashing in Load Balancer
The standard hashing algorithm is inefficient while processing network queries. This traditional technique presupposes that we have a set number of s…
ProgrammingPython Generators – The Lazy Workers of Python
When you first learn Python, you’re introduced to functions and loops. As you go deeper, you meet one of Python’s coolest features, Generators . But …
GitGit Reset - A tool to correct your (commited) mistakes.
Terminologies Work Tree : Your working tree are the files that you are currently working on. Your local folder. Git Index/Staging Area : The git “ind…
ProgrammingLet's Build a Bank Account Simulation
Problem Statement 🧩 Overview Build a bank system to create and manage user accounts, simulate deposits, withdrawals, interest accrual, and overdraft …
ProgrammingLet's Build a Library Management System With OOPS
Problem Statement 🧩 Overview Design a command-line-based Library Management System that simulates the basic operations of a library for both users an…
Learning📊 Learn PostgreSQL in Tamil: From Zero to 5★ on HackerRank in Just 10 Days
PostgreSQL is one of the most powerful, stable, and open-source relational database systems trusted by global giants like Apple, Instagram, and Spoti…
ProgrammingRedis Strings – The Building Blocks of Key Value Storage
Redis is famously known as an in-memory data structure store , often used as a database, cache, and message broker . The simplest and most fundamenta…