Software engineers are the frontline in any tech company and more so in a tech product company. However, you would find that most of the software engineers lack good product sense despite being great in their software knowledge.
The fundamental problem lies in how the work is assigned in most organisations. Software engineers are given tickets to work on. Typical examples are:
“Create an API to login with email”
“Create a cron to put credits in customer’s accounts”
The issue is that tickets only carry an instruction to “implement” something. …
A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyse a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly. Specialisation is for insects.
— Robert Heinlein
What a fascinating quote! I came across this quote 3 years back and it changed my perspective on how I used to look at my career.
If you’re worried about which…
One Friday afternoon, I received a pager alert that one of the queries in production is taking 60+ seconds to execute. Here’s what it looked like:
WHERE user_id IN (...);
Why is this query slow, despite
user_id being indexed? The question had me perplexed. I went through the PostgreSQL docs, some stack overflow posts and finally understood why.
This article will explain why is the “IN” condition running slow despite the indexed column. You will understand how the query planner works for one or more relations in your queries. …
Rosh Gadol! Engineering Manager, Shuttl India.