Ansh Yadav

software engineer

[Ansh Yadav @ansh_ydv27]

@krunalbuilds While using cursor , make sure the column you are using for cursor , it should be indexed , better to use primary key of the table

[Ansh Yadav @ansh_ydv27]

@krunalbuilds When we use limit offset , it loads all the data filtered by where condition in the memory and the remove the offset rows, thats why it becomes slow when offset increase

Solution - use cursor based pagination , so before loading in the memory the query will filter it out

[Ansh Yadav @ansh_ydv27]

@Adrian_Sajjan what helu

[Ansh Yadav @ansh_ydv27]

trying to read about database , can someone suggest good resources

[Ansh Yadav @ansh_ydv27]

@BATA_India what is the price of this article

[Ansh Yadav @ansh_ydv27]

#cfbr

[Puneet Patwari @system_monarch]

1) Load Balancing: https://t.co/IytjJseO11

2) CDN: https://t.co/xxzUuwV5GD

3) Caching: https://t.co/QvyGIyKNHM

4) Cache Invalidation: https://t.co/FyDLJWZVOE

5) Rate Limiting: https://t.co/auDKgPpLeA

6) API Gateway: https://t.co/H1y0htWDub

7) CAP Theorem: https://t.co/AglSd993oa

8) Sharding: https://t.co/HT316hgoEr

9) Replication: https://t.co/NXessCjYp4

10) Partitioning: https://t.co/01bpFCZBhZ

11) Queues: https://t.co/Lenx1Pfw95

12) Microservices: https://t.co/Hx9Yn2yRBw

13) Microservices Vs Monoliths: https://t.co/g9lGFHydVj

14) Fault Tolerance: https://t.co/jCJk6d52z2

15) Database Scaling: https://t.co/h7pYha8x6x

16) Service Discovery: https://t.co/vEDMvhWYj5

17) Consistency models: https://t.co/cb3zNtdZNA

18) Eventual Consistency: https://t.co/aFjL3flHNY

19) Distributed Transactions: https://t.co/s0ZWdtTqiW

20) Leader Election: https://t.co/IxrWO9AvB3

21) Horizontal vs Vertical Scaling: https://t.co/I8CH64dL5l

22) Back of the Envelope Estimation: https://t.co/gyatcqpaqO

23) Idempotency, Data Latency & Finale: https://t.co/fNArLx4MrW

[Ansh Yadav @ansh_ydv27]

@BATA_India what is the price ??

[Ansh Yadav @ansh_ydv27]

@_jaydeepkarale Exceptional coding skills

[Ansh Yadav @ansh_ydv27]

@SumitM_X Downloading is faster because ISPs allocate more bandwith for download w.r.t to upload

And

And network infrastructure is structured in such a way , that more spectrum are allocated for downstream

[Puneet Patwari @system_monarch]

A month ago, I told everyone:

"I've been a backend Engineer for 12+ years. Today, I'm a Principal Engineer at Atlassian.

I've designed systems that handle millions of requests. Sat on both sides of system design interviews.

Reviewed more architecture docs than I can count.

Starting today, I'm breaking down the fundamentals of scaling for the next 25 days.

If you're learning system design bookmark this thread, you're going to get a lot of learning from this."

FYI, the series has concluded. Here are all the concepts, please bookmark, share, learn and the most important build from the learnings you get.

Also, if you have any ideas on what you'd like to see from me, please let me know, any other series or concepts to be broken down.

[Ansh Yadav @ansh_ydv27]

@DAIEvolutionHub Sql

[Browser Use @browser_use]

Introducing: Vibetest-use MCP - automated QA using Browser-Use 🧨

In just one line👀
⇢ 10+ browser-use agents spin up in parallel
⇢ crawl your dev site in < 60s
⇢ flag every 404, dead button & UI glitch

Runs out-of-the-box in Cursor, Claude Code & Codex (soon?). 100% Open Source.

Unleash the swarm ↓