Home

Why Uber abandoned PostgreSQL's UUID indexes and how linked leaf nodes solve range query nightmares.

Detailed personal notes covering clustered/non-clustered indexes, composite indexes, UUID performance, bitmap scans, and billion-row table strategies.

Lecture notes covering UUID impacts on B+Trees, Bloom filters, SQL Server index design, billion-row table strategies, and transaction costs.

Why do analytics queries crawl while transactions blaze? We break down row vs column storage, indexes, and the hidden world of database pages.

This note summarizes a lecture on consistency in database systems, covering types of consistency, eventual consistency in distributed systems, and isolation levels that help maintain reliable data states.

This note summarizes the key concepts of ACID properties (Atomicity, Consistency, Isolation, Durability) in database transactions and the definition of a transaction itself.

My detailed lecture notes on UDP, covering its fundamentals, how it compares with TCP, practical use cases, its advantages and limitations, and an overview of implementing a UDP server in Node.js and C.

A deep dive into the Internet Protocol (IP), covering IP packets, subnets, fragmentation, ICMP, and practical tools like ping and traceroute for backend systems.