Systems Fundamentals
How computers actually work underneath the abstractions.
11 posts · Engineering
- 1
Systems Fundamentals: The Skills That Outlast Every Framework
Why systems fundamentals like latency, storage, and the four pillars stay useful for decades while frameworks churn - and how to use them to build faster.
- 2
How a Computer Actually Runs Your Code: CPU, Memory & Threads
See how a computer runs your program, from source code to CPU, memory, and threads, and turn performance guesswork into real, confident understanding.
- 3
Concurrency vs Parallelism: How Computers Juggle Tasks
Concurrency vs parallelism, explained simply. Learn how computers juggle many tasks, why race conditions happen, and which tool fits I/O vs CPU work.
- 4
Relational Databases, SQL & ACID Explained Simply
Learn how relational databases, SQL, and ACID transactions keep your data correct under load - with clear examples, common mistakes, and practical tips.
- 5
How Databases Find One Row in a Billion (Without Reading Them All)
How database indexes find one row in a billion almost instantly. A clear guide to pages, B-trees, LSM-trees, and writing queries that stay fast.
- 6
Scaling a Database: Replication, Sharding & NoSQL Explained
Learn how to scale a database past one server with replication, partitioning, and NoSQL - and why reads are easy to scale but writes are genuinely hard.
- 7
How Data Travels the Internet: IP, TCP, UDP & DNS
A clear, practical guide to how data travels the internet: IP, TCP, UDP, and DNS explained in plain language so you can debug slow, hung, and flaky apps.
- 8
How the Web Really Works: HTTP, TLS, Load Balancing & Caching
A clear, practical tour of the web stack: how HTTP requests work, why HTTPS is safe, what load balancers and CDNs do, and how caching makes sites fast.
- 9
Distributed Systems Explained: Why Many Computers Act as One
A distributed system makes many computers behave as one. Learn partial failure, CAP, consistency, consensus, and idempotency in plain, practical language.
- 10
Data Engineering Explained: How Data Moves at Scale
Learn how data engineering moves and shapes data at scale - OLTP vs OLAP, ETL vs ELT, Kafka, lakehouses, and idempotent pipelines, explained in plain English.
- 11
System Design Trade-offs: How to Reason About Any System
Learn the repeatable system design process: back-of-envelope estimates, the five universal trade-offs, idempotency, and how to reason about any system.