Soham De Roy (@_sohamderoy) header
Soham De Roy (@_sohamderoy) profile picture

Senior SDE @ Mastercard • IIT Kanpur

Kanpur
Joined November 2019
Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)Photo by Soham De Roy (@_sohamderoy)
Introducing FAPI — get mock API endpoints instantly, right in your terminal. Just run: npx start-fapi NPM: npmjs.com/package/start-fapi What you get: ✅ Custom endpoints ✅ 100% local ✅ Simulate network failures & edge cases #SoftwareEngineering #coding #developer
8
Soham De Roy retweeted
Data Scientist Roadmap #Infographic by @DataScienceDojo
2
232
1,279
105,302
Soham De Roy retweeted
- everything is a file (Unix) - everything is an object (Java) - everything is a string (Perl) - everything is a global variable (PHP) - everything is an app (Macromedia Flash) - everything is XML (too many to name) - everything is an HTML attribute (Angular.js) - everything is a stream (RxJS) - everything is a component (React) - everything is a hook (React but 5 years later) - everything depends (senior developer)
305
486
96
6,560
412,703
Soham De Roy retweeted
The tower has caught the rocket!!
44,092
130,157
22,598
1,102,298
144,884,722
Soham De Roy retweeted
Famous words of IND Proud #RatanTata
278
5,456
171
39,853
2,141,290
You were and still will remain a true leader. May your soul Rest in Peace.🙏🏻🙏🏻🙏🏻
The clock has stopped ticking. The Titan passes away. #RatanTata was a beacon of integrity, ethical leadership and philanthropy, who has imprinted an indelible mark on the world of business and beyond. He will forever soar high in our memories. R.I.P
60
Soham De Roy retweeted
The clock has stopped ticking. The Titan passes away. #RatanTata was a beacon of integrity, ethical leadership and philanthropy, who has imprinted an indelible mark on the world of business and beyond. He will forever soar high in our memories. R.I.P
2,835
9,919
1,880
71,039
4,009,932
Soham De Roy retweeted
Best pull to refresh I have ever seen
461
2,493
509
27,467
2,510,371
¿Sabías que en JavaScript las funciones se tratan como ciudadanos de primera clase? 🤓 Descubre cómo estas potencian las funciones de orden superior y optimizan tu código. Un excelente artículo de @_sohamderoy. Traducido por @EliasPereyraGo1. freecodecamp.org/espanol/new…
9
28
3,886
Soham De Roy retweeted
Life of a developer
17
167
17
875
78,198
X is free Internet is free YouTube is free ChatGPT is free Freecodecamp is free Learn everything for free. All you need is a laptop and an Internet connection. No more excuses.
151
105
24
908
67,694
Soham De Roy retweeted
🐲Dragonfly is a drop-in #Redis replacement built for modern data workloads. If you are running a large Redis instance, Dragonfly can: - reduce costs (up to 80%) - boost performance (30X throughput on same instance) - simplify operations (vertical scaling)

15
80
1
791
3,093,587
𝗧𝗼𝗽 𝟮𝟬 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝘆 𝗼𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝘁𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀 Here is the list of the top 20 SQL query optimization techniques I found noteworthy: 1. Create an index on huge tables (>1.000.000) rows 2. Use EXIST() instead of COUNT() to find an element in the table 3. SELECT fields instead of using SELECT * 4. Avoid Subqueries in WHERE Clause 5. Avoid SELECT DISTINCT where possible 6. Use WHERE Clause instead of HAVING 7. Create joins with INNER JOIN (not WHERE) 8. Use LIMIT to sample query results 9. Use UNION ALL instead of UNION wherever possible 10. Use UNION where instead of WHERE ... or ... query. 11. Run your query during off-peak hours 12. Avoid using OR in join queries 14. Choose GROUP BY over window functions 15. Use derived and temporary tables 16. Drop the index before loading bulk data 16. Use materialized views instead of views 17. Avoid != or <> (not equal) operator 18. Minimize the number of subqueries 19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join. 20. For retrieving the same dataset, frequently try to use temporary sources. Do you know what is 𝗤𝘂𝗲𝗿𝘆 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗲𝗿? Its primary function is to determine 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁 𝘄𝗮𝘆 to execute a given SQL query by finding the best execution plan. The query optimizer works by taking the SQL query as input and analyzing it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query. Next, the optimizer generates 𝗮𝗹𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝘃𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻𝘀, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a 𝗰𝗼𝘀𝘁 to each execution plan based on the number of disk reads and the CPU time required to execute the query. Finally, the optimizer 𝗰𝗵𝗼𝗼𝘀𝗲𝘀 𝘁𝗵𝗲 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗽𝗹𝗮𝗻 with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query. Check in the image the 𝗼𝗿𝗱𝗲𝗿 𝗶𝗻 𝘄𝗵𝗶𝗰𝗵 𝗦𝗤𝗟 𝗾𝘂𝗲𝗿𝗶𝗲𝘀 𝗿𝘂𝗻. #technology #softwareengineering #programming #techworldwithmilan #sql
69
1,634
36
8,057
984,499
CSS can be tricky – after all, there are many different ways to do one thing. But there are some helpful tools that can make your life easier, like Tailwind CSS. In this guide @_sohamderoy shows you what Tailwind can do & how to use it in your projects. freecodecamp.org/news/what-i…
2
41
216
36,629
Soham De Roy retweeted
1/10 - FY 2022-23 - Here is your cheat sheet for filing taxes with the right ITR👇, and don't forget to join our Twitter Spaces on Friday!
68
488
16
1,667
515,774
Future CSS Tip! 🔮 Use scroll-driven animations to create those cool Apple-style text reveals 🔥 No JavaScript required 👀 Responsive too! 🙌 .sentence { animation: highlight; animation-timeline: view(); animation-range: cover 40% cover 75%; } @CodePen link below! 👇
25
440
14
2,838
348,182
CSS can be tough, partly because there are many ways to do the same thing. But there are some helpful tools that can make your life easier - like Tailwind CSS. In this guide @_sohamderoy shows you what Tailwind can do & how to use it in your projects. freecodecamp.org/news/what-i…
40
275
46,804