📝 Parottasalna Blog
248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
Understanding 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…
Technology💾 Redis Is Open Source Again - What that means ?
Imagine you’ve been using a powerful tool for years to help you build apps faster. Yeah its Redis , a super fast database that helps apps remember th…