Designing a URL Shortener Database Backend: Trade-offs and Scaling
Exploring two database designs for a URL shortener, their trade-offs, and scaling strategies to balance speed, security, and scalability.
Designing a Twitter-like System: Trade-offs and Core Concepts
Exploring the challenges of designing a scalable Twitter-like system, covering authentication, database design, message queues, load balancing, and handling user follows.
Understanding Database Replication: Master-Slave vs. Multi-Master
Explores database replication types (Master-Slave vs. Multi-Master), synchronous vs. asynchronous modes, and a hands-on Postgres 13 demo.
Why SQL Pagination With Offset is Slow and How to Optimize It
Learn why using OFFSET for pagination harms performance and discover efficient alternatives like keyset pagination.
Database Sharding and Consistent Hashing Explained
A deep dive into database sharding, consistent hashing, and their practical implementation using Postgres and NodeJS.
PostgreSQL Partitioning – Real-World Lessons from Hussein's Database Lectures
Detailed notes on horizontal partitioning from Hussein's lecture series. Includes real PostgreSQL examples, performance tips, automation scripts, and how partitions improve query speed.
B+ Trees vs B-Trees: How Database Indexing Really Works
Why Uber abandoned PostgreSQL's UUID indexes and how linked leaf nodes solve range query nightmares.
Comprehensive Database Indexing & Performance Notes
Detailed personal notes covering clustered/non-clustered indexes, composite indexes, UUID performance, bitmap scans, and billion-row table strategies.
76 post articles, 10 pages.