Ashok Sahoo (@ashoKumar89) header
Ashok Sahoo (@ashoKumar89) profile picture

Full-Stack Engineer | Building real-world systems across the stack | Sharing real-world lessons on performance, failures, and trade-offs

Joined October 2009
Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)Photo by Ashok Sahoo (@ashoKumar89)
Ashok Sahoo retweeted
10 things that make APIs expensive: 1. SELECT * 2. N+1 queries 3. Large JSON responses 4. Missing caching 5. Unbounded pagination 6. Repeated DB calls 7. Synchronous processing 8. Excessive logging 9. No connection pooling 10. No rate limiting
7
18
1
174
5,973
Ashok Sahoo retweeted
This code passes every unit test. Then traffic spikes. Suddenly, your database melts. What happened?
17
2
169
36,084
Ashok Sahoo retweeted
Production Scenario 🧵 You have 3 read replicas. Replication lag is 2 seconds. A user updates their profile and immediately refreshes. They still see the old data. How would you fix this without disabling read replicas?
6
1
18
2,240
Ashok Sahoo retweeted
System Design Question 🧵 Your application uses Redis. A product price changes. Some users still see the old price for several minutes. How do you guarantee cache consistency? Constraints: - Millions of requests/day - Low latency - No manual cache clears
8
4
37
4,491
Ashok Sahoo retweeted
Can you spot the deployment issue? Everything works in staging. A rollback is needed after production deployment. Why can using latest become a problem?
4
1
9
2,806
Ashok Sahoo retweeted
Grok 4.5 has surprised me. I spent almost the entire day coding with it. ⚡ Responses were consistently fast. 📉 Weekly usage: only 4%. So far, it’s proving to be a very cost-effective coding assistant.
3
1
9
1,120
Ashok Sahoo retweeted
Every microservice has a 99.9% uptime. You chain together 20 of them. How reliable is the entire request?
10
1
41
6,022
Ashok Sahoo retweeted
Your app needs to upload a 2GB video. Would you send it through your backend API? Or take a different approach?
13
4
37
8,723
Ashok Sahoo retweeted
This code passed code review. Would you approve it? Assume two requests hit it simultaneously.
9
2
18
5,604
Ashok Sahoo retweeted
When WhatsApp delivers a message to a group with 10,000 members… Is the sender’s phone actually sending 10,000 copies? How does that scale?
12
1
19
5,703
Ashok Sahoo retweeted
Top 10 database resources I still recommend to working devs: 1) Designing Data-Intensive Applications (Kleppmann). Real tradeoffs: logs vs DBs, replication, consistency. 2) Read the Postgres manual (especially indexes + MVCC). It answers 80% of production questions better than blog posts. 3) Use The Art of PostgreSQL (Dalibo). Practical query tuning with EXPLAIN and real patterns, not theory. 4) SQL Performance Explained (Markus Winand). Indexes, selectivity, and why your WHERE clause order doesn’t matter (but data does). 5) CMU 15-445/645 (Database Systems). Free lectures that explain why engines do what they do: locking, buffer pools, recovery. 6) Martin Fowler on database refactoring + migration patterns. Helps when schemas change weekly and you can’t take downtime. 7) Use, The Internals of PostgreSQL. Great when autovacuum, bloat, or WAL become your on-call problem. 8) Jepsen analyses (Kyle Kingsbury). Consistency failures in the wild; teaches you to distrust happy-path tests. 9) Practice project: build a tiny DB. Append-only log + SSTables + compaction + a simple index. You’ll stop treating storage like magic. 10) Practice project: take a slow query in your app and fix it end-to-end. Add an index, rewrite query, measure p95, watch write cost and bloat.
8
22
1
189
8,452
Ashok Sahoo retweeted
Your Docker image is 1.2GB and takes 4 minutes to build. It should be 80MB and build in 20 seconds. Here's how to fix it:
23
61
2
1,092
234,859
Ashok Sahoo retweeted
An API returns these responses. What security issue does this create?
4
1
20
3,722
Ashok Sahoo retweeted
Application-level auth or PostgreSQL Row Level Security? Which do you prefer for multi-tenant apps?
7
1
1
29
7,035
Ashok Sahoo retweeted
Your API receives 10MB JSON payloads. Traffic suddenly spikes. CPU usage explodes before business logic even runs. What would you redesign first?
12
5
1
82
10,993
Ashok Sahoo retweeted
Database query is fast in staging. Same query is slow in production. Schema is identical. What would you investigate first?
6
2
40
8,522
Ashok Sahoo retweeted
Your queue has 2 million pending messages. Workers process: 1000 msgs/sec Yet the backlog keeps growing. Do you: - add more workers - optimize processing - or something else?
10
1
64
9,880
Ashok Sahoo retweeted
Most developers run npm install without thinking twice. Have you ever checked what executes inside preinstall and postinstall in package.json?
4
1
24
3,782
Ashok Sahoo retweeted
Your API is experiencing 10x traffic spike during peak hours. Your database connection pool is exhausted. What's your immediate action plan? Do you scale horizontally, implement connection pooling, or add a caching layer?
12
2
26
4,415
Ashok Sahoo retweeted
Real-world scenario: Your API suddenly takes 5 seconds to respond during peak hours, but works fine at night. Users are complaining. What do you check first? Hint: It's rarely the code itself. Think about what changes between 2 AM and 2 PM besides traffic volume.
5
2
39
5,560