Databases Pages (Article) Database Pages — A deep dive Databases often use fixed-size pages to store data. Tables, collections, rows, columns, indexes, sequences, documents and more eventually en...
Table of Contents ACID Properties Understanding Database Internals Row-Based vs Column-Based Databases Primary Key vs Secondary Key Database Indexing SQL Query Planner and Optimizer ...
System design interviews are a critical part of the hiring process for software engineering roles, especially for senior positions. These interviews assess your ability to design scalable, maintain...
Finally, let’s touch on a few more advanced topics, including database access control, network analysis tools, and challenges in protocol evolution, before concluding with a reflection on the impor...
Transport Layer Security (TLS): Securing Network Communication Modern internet security relies heavily on encryption, particularly through Transport Layer Security (TLS). Let’s explore how we’ve e...
The Network Journey Behind Clicking a Link When you click a hyperlink in your browser, a complex sequence of networking events occurs: DNS Resolution: The domain name (e.g., pravin.dev) is res...
Proxy Systems: Intermediaries in Network Communication Networks often involve intermediaries that route or manage traffic. This article distinguishes between client-side proxies and server-side rev...
The Cost of Connections Establishing and managing connections comes with inherent costs. This article explores why connections are expensive, how connection pooling mitigates this, different loadin...
Network Address Translation (NAT) Beyond the basics, TCP’s performance can be significantly impacted by various factors and algorithms. This article explores Network Address Translation, connection...
TCP (Transmission Control Protocol) While UDP offers speed and simplicity, TCP provides reliability. This article delves into the details of the Transmission Control Protocol, its connections, str...