Arpit’s Newsletter

Arpit’s Newsletter

Home
Career Growth
System Design
Deep Dives
Papers and Musings
Outage Dissections
About

System Design

Why most TCP servers are multi threaded and how to build one from scratch
TCP is the most reliable method for communication between machines over a network.
 • 
Arpit Bhayani
Datetime vs Timestamp datatype in databases - Which one is better?
Most databases provide three types of temporal data types to store dates and times: DATE, DATETIME, and TIMESTAMP. While all three data types store date…
 • 
Arpit Bhayani
Writing Good Multi-threaded Programs: Ensuring Correctness and Optimality
Writing concurrent programs can be easy, but ensuring their correctness and optimality can be tricky, especially when dealing with multi-threaded…
 • 
Arpit Bhayani
1
Why do databases store data in B+ trees?
Relational Databases and some non-relational databases use B+ trees to hold the data but why?
 • 
Arpit Bhayani
1
Thundering Herd Problem and addressing it with randomness
When a user makes an API call to the backend and encounters a network issue causing the call to fail, one common solution is to retry the call assuming…
 • 
Arpit Bhayani
1
Designing Idempotent Payment APIs
In the world of payments, reliability and consistency are crucial.
 • 
Arpit Bhayani
2
Slack's Email Classification Service
One of the features of Slack is the ability to invite people to join a workspace by email.
 • 
Arpit Bhayani
How Shopify Balances Database Shards Without Downtime
Shopify is an e-commerce platform that enables individuals to create their online stores.
 • 
Arpit Bhayani
How Grab stores and processes millions of orders every day
Grab stores and processes millions of orders every day, here is the design of the systems that powers it ⚡
 • 
Arpit Bhayani
How Twitter keeps its Search up and stable
Managing massive, talking hundreds of terabytes here, Search clusters is no joke, especially at @Twitter's scale.
 • 
Arpit Bhayani
Razorpay's journey to microservices
Microservices are great but one of the biggest pain points of adopting them is Keeping Data Consistent across different databases.
 • 
Arpit Bhayani
How Zomato improved its search using NLP
Search is one of the most interesting problems to attempt and Zomato has made their search understand natural language; here's a quick gist about this…
 • 
Arpit Bhayani
© 2025 Arpit Bhayani
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture