Blog

Articles and guides on software engineering, system design, career growth, and more.


What are Different Types of SQL Indexes?

What are Different Types of SQL Indexes?

Unlock database performance with our guide to SQL index types. Learn how B-Tree, clustered, non-clustered, and hash indexes speed up your queries.

DatabaseConcepts
Rohit LakhotiaApr 8, 2026
How Slack Built Secure Enterprise Search?

How Slack Built Secure Enterprise Search?

Slack enables secure enterprise search using real-time fetch, RAG, ACL & OAuth, no data storage, always permission-aware & private across tools.

SlackSystem Design
Rohit LakhotiaApr 6, 2026
Aspect-oriented design vs OOPs vs Functional Programming

Aspect-oriented design vs OOPs vs Functional Programming

Discover aspect-oriented design vs oop vs functional programming and how to apply each approach for scalable, maintainable software.

BeginnerConcepts
Rohit LakhotiaApr 1, 2026
How Airbnb Migrated a Petabyte Without Users Noticing

How Airbnb Migrated a Petabyte Without Users Noticing

Airbnb rebuilt Mussel into a cloud-native KV store and migrated 1PB+ data using Apache Kafka with zero downtime.

AirbnbSystem Design
Rohit LakhotiaMar 30, 2026
API Gateway vs Load Balancer

API Gateway vs Load Balancer

Discover the differences between API gateway vs load balancer and find out which is best for your system's performance and security needs.

Cloud InfrastructureDistributed SystemConceptsSystem ArchitectureSystem DesignMessage Queues
Rohit LakhotiaMar 25, 2026
How Slack cut their E2E Build Time by 80%?

How Slack cut their E2E Build Time by 80%?

Slack cut E2E time 80% by skipping redundant frontend builds and reusing cached assets, saving compute, storage, and hours.

SlackSystem Design
Rohit LakhotiaMar 23, 2026
What are Immutable Data Structures?

What are Immutable Data Structures?

Explore why immutable data structures: why they matter in modern coding. Discover how they enhance reliability, simplify concurrency, and prevent bugs.

ConceptsSystem Design
Rohit LakhotiaMar 18, 2026
How Shopify Made Commerce Data Queryable Without SQL

How Shopify Made Commerce Data Queryable Without SQL

ShopifyQL Notebooks lets merchants explore business data without SQL, using commerce-focused models built for clarity, speed, and action.

ShopifySystem Design
Rohit LakhotiaMar 16, 2026
What is Backpressure?

What is Backpressure?

Learn what is backpressure in distributed systems, why it’s vital for stability, and key strategies to prevent overloads in large-scale systems.

Distributed SystemSystem ArchitectureSystem Design
Rohit LakhotiaMar 11, 2026
How Slack Automatically Stops Suspicious Activity in Real Time

How Slack Automatically Stops Suspicious Activity in Real Time

Slack’s AER detects suspicious activity and automatically terminates user sessions, shrinking response time from hours to minutes.

SlackSystem Design
Rohit LakhotiaMar 9, 2026
Normalized vs Denormalized Database?

Normalized vs Denormalized Database?

Choosing between a normalized vs denormalized database? This guide breaks down the performance trade-offs to help you make the right architectural choice.

DatabaseConcepts
Rohit LakhotiaMar 4, 2026
How Shopify Built Super-Fast Search at C++ Speed

How Shopify Built Super-Fast Search at C++ Speed

Shopify built RankFlow to run ML-powered search at C++ speed, letting data scientists iterate fast without sacrificing latency or scale.

ShopifySystem Design
Rohit LakhotiaMar 2, 2026

Showing 12 of 195 articles