Puneet Verma 
SQL Window Functions are powerful tools that allow users to perform calculations across a set of table rows related to the current row. What is a Window Function? A window function performs a calculation across a set of table rows that are somehow related to the current row. This set of rows is referred to … Read more
Consistent hashing is a technique used in distributed systems to evenly distribute data across a cluster of nodes, minimizing the amount of data that needs to be relocated when nodes are added or removed. This method ensures that the system remains scalable, fault-tolerant, and efficient. Introduction In a large-scale distributed system, data does not fit … Read more
Back of the envelope calculations are invaluable in the early stages of system design. These rough, rapid estimates provide ballpark figures that help engineers and architects quickly assess feasibility and compare multiple approaches, guiding more detailed analysis and design. What Are Back of the Envelope Calculations? Back of the envelope calculations are quick, simplified estimates … Read more
In today’s digital world, managing the flow of data and requests between clients and servers is critical for maintaining the performance, security, and availability of web services. One key technique used to achieve this is rate limiting. This blog will delve into the concept of rate limiting, its importance, methods, and best practices. What is … Read more
CAP theorem states that a distributed system can only guarantee two of these three properties at any given time. Introduction Distributed systems have become increasingly prevalent in today’s technology landscape, enabling scalability, fault tolerance, and high availability. However, designing and managing distributed systems comes with its own set of challenges. One fundamental concept that plays … Read more
Apache Cassandra is a highly scalable, distributed NoSQL database designed to handle large amounts of data across many servers, providing high availability with no single point of failure. This practical guide will help you understand how to use Cassandra for real-world applications. Key Points Key Concepts in Cassandra Login in console Keyspace A keyspace is … Read more
The SOLID principles are a set of five design principles that help software developers create more maintainable, understandable, and scalable code. Let’s delve into each SOLID principle and explore how they contribute to building high-quality software. Solid Overview Each principle can be applied at different levels of software design, including classes, methods, and modules. The … Read more
Dependency Inversion Principle (DIP), Dependency Injection (DI), and Inversion of Control (IoC) are pivotal concepts in software development, shaping the architecture and flexibility of modern applications. What is a dependency? A state where one class depends on another is called dependency or coupling. Example Class A is dependent on Class B, i.e. Class A has to create … Read more
Design patterns are crucial in enhancing code quality, maintainability, and scalability. One of the most influential collections of design patterns is the Gang of Four (GoF) patterns, encapsulated in the seminal book “Design Patterns: Elements of Reusable Object-Oriented Software.” What are Design Patterns? Design patterns are proven solutions to common problems encountered in software design. … Read more
A bloom filter is a probabilistic data structure that is based on hashing. It is extremely space efficient and is typically used to add elements to a set and test if an element is in a set. However, the elements themselves are not added to a set. Instead, a hash of the elements is added … Read more