Pankaj Tanwar

@the2ndfloorguy

Software Engineer. Blogging at - Building

Jaipur, India
pankajtanwar.in
Geregistreerd in april 2017
3 foto's en video's Foto's en video's

Tweets

Je hebt @the2ndfloorguy geblokkeerd

Weet je zeker dat je deze Tweets wilt bekijken? @the2ndfloorguy wordt niet gedeblokkeerd door Tweets te bekijken.

  1. Vastgemaakte Tweet
    30 jun.

    🎉 Product Launch : Introducing - Explore & share your personal resources with community. Personal resources of devs from Google, Amazon, Uber and many more. Powered by & 🎊 Try now :

    2 retweets 9 vind-ik-leuks
    Ongedaan maken
  2. 21 jul.

    What is the sorting algorithm behind ORDER BY query in MySQL? from

    1 retweet 5 vind-ik-leuks
    Ongedaan maken
  3. 11 jul.

    How to get freelance clients quickly? One tip which has helped me a lot - While submitting your proposal, don't just write abt you & your experience. Submit a solution & your approach to the client's problem and mention your experience in the end to build trust.

    2 vind-ik-leuks
    Ongedaan maken
  4. 10 jul.

    Learn to read other's code is one of the under rated and must have skill for a developer.

    2 vind-ik-leuks
    Ongedaan maken
  5. 3 jul.

    Subscribe to newsletter -

    1 vind-ik-leuk
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  6. 3 jul.

    I and curate and share links to one engineering article/video every day at 8:30 am IST on a wide array of topics like System Architecture, Programming constructs, Web engineering, open-source projects, and many more.

    1 antwoord 1 vind-ik-leuk
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  7. 3 jul.

    How to create partial Index? CREATE INDEX idx_country ON user (country) WHERE country='IN'; A Partial index is useful for commonly used where conditions that uses constant values - like the country code in the example.

    1 antwoord
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  8. 3 jul.

    Here, instead of having a complete index on country column, partial index on country column where country = 'IN' will make the query drastically faster (~400% faster on 5Lac rows).

    1 antwoord
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  9. 3 jul.

    An important thing to notice here is, there will always be a fix number of possible values for this column (195 countries only). I am mostly intrested in user's from India (IN). I make frequent queries where country = 'IN'.

    1 antwoord
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  10. 3 jul.

    What is partial indexes? A partial index is simply as an index that stores data on a part of a column. Let's understand with an example, at , country code is stored in country column in user table.

    1 antwoord
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  11. 3 jul.

    Partial indexing is less discussed but should be incorporated along with traditional indexes due to their dramatic performance effects in database queries.

    1 antwoord
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  12. 3 jul.

    Today's edition of "The Great Engineering Newsletter" was "Partial Indexes : Indexing selected rows". It is one of the commonly ignored database query optimisation techniques. Partial indexing is less discussed .. (a thread)

    1 antwoord 1 retweet 5 vind-ik-leuks
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  13. 1 jul.

    Start up idea : A tool which takes someone's LinkedIn profile as input and prepares a personalized cover letter.

    2 vind-ik-leuks
    Ongedaan maken
  14. heeft geretweet
    26 jun.

    600 subs on our The Great Engineering Newsletter 🎉

    1 retweet 2 vind-ik-leuks
    Ongedaan maken
  15. 26 jun.

    I recently came across a website which was DNS powered with no backend. The website was to display some contact numbers. They stored this information in DNS TXT records. And it was fetched from DNS using client side cloudflare DNS over HTTPS calls. Is it Scalable?

    1 retweet 1 vind-ik-leuk
    Ongedaan maken
  16. heeft geretweet
    17 jun.

    Mistaken Beliefs of Distributed Systems While building such a complex system, we tend to assume a few things to be true, which, in reality, are definitely not true. Here are 8 such fallacies 🧵

    1 antwoord 2 retweets 7 vind-ik-leuks
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  17. 17 jun.

    New Blog : What is latency? Let’s deep dive & understand possible ways to optimise it. from

    13 retweets 9 vind-ik-leuks
    Ongedaan maken
  18. heeft geretweet
    11 jun.

    Yesterday, when I asked "What we could have done better with our The Great Engineering Newsletter?", we got this as one of the responses. """ Can I get, once in a week (apart from the daily one), one from the previous editions? just to kind of refresh what I read. """

    1 antwoord 2 retweets 2 vind-ik-leuks
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken
  19. 9 jun.

    Adding caching to stack -

    2 vind-ik-leuks
    Ongedaan maken
  20. heeft geretweet
    4 jun.

    Interesting read. TIL there is a npm package called 'Chokidar' 😃😃 Have you ever thought, how ‘nodemon’ works internally? Let’s build our own ‘nodemon’ in under 10 minutes! { by } from

    1 antwoord 6 retweets 5 vind-ik-leuks
    Deze collectie tonen
    Deze collectie tonen
    Ongedaan maken

@the2ndfloorguy heeft nog niet getweet.

Het laden lijkt wat langer te duren.

Twitter is mogelijk overbelast of ondervindt een tijdelijke onderbreking. Probeer het opnieuw of bekijk de Twitter-status voor meer informatie.

    Je bent misschien ook geïnteresseerd in

    ·