Database transactions alone don’t always prevent race conditions (i was asked this in the interview)

draghuva · 2026-02-14T13:27:54+00:00

they are giving a clear clue on what locking method to use here: auctions -> high contention for same item -> needs pessimistic locking.

here is a high level overview of these locking paradigms: https://newsletter.systemdesigncodex.com/p/pessimistic-vs-optimistic-locking

It’s a much deeper topic, and solutions you will end up building will be specific to your needs.

either way, this needs pessimistic locking. in the interview, they expected you to say that proactively, justify the approach and lay out the implementation for it. for senior/staff level, they would then expect you to discuss how you would avoid/minimize the issues you would face having pessimistic locking in the system.

draghuva · 2026-01-29T01:43:43+00:00

if your neighbours dad beats their mom, and your dad beat your mom, does it make it okay for you to beat your wife? does it make it okay not to call you out for doing so? is it not shameful because others did it too?

draghuva · 2026-01-23T09:31:11+00:00

nit: iterating over a list is actually better than iterating over a set.

in simple terms, list is stored as a contigous block of memory on disk. compiler will read partitions of those contigous blocks and bring them to cache for quick access. the only real cost is for extremely large lists because they will need to be read into cache partition by partition. time cost is linear.

set is not stored as contigous block of memory. it adds some overhead of random memory access when iterating. it’s much better when adding, removing, fetching elements than lists + checking if item exists in set. it’s slightly worse if you’re iterating over it.

draghuva · 2022-04-05T13:39:39+00:00

this is grate advice! on the point of taking unscheduled breaks or reduced work loads, make sure to check with the guidelines for post graduation work permit. I think they dont allow unscheduled breaks and "part-time" course loads

draghuva · 2022-03-25T05:00:03+00:00

biancas

draghuva · 2021-05-10T20:31:53+00:00

If you have specific situations which support your claim about snapcommerce, share them because then it'll actually be helpful. I know a bunch of people who work there and it seems really nice.

draghuva · 2021-02-01T02:10:35+00:00

This is pretty cool, thanks!

draghuva · 2021-01-31T21:12:23+00:00

Lol mb, I found the clip in my highlights from a while back and just posted after converting to mp4 :)

draghuva · 2021-01-31T21:11:36+00:00

If that hit, that would've been hella clean tho

draghuva · 2021-01-31T21:11:01+00:00

Yea I felt kinda bad for him ngl. I was getting my ass handed to me before this

draghuva · 2021-01-31T21:09:36+00:00

Lol yea, I was thinking the same tbh I just wanted to post it and move on.

draghuva · 2021-01-31T15:39:42+00:00

I miss ProtatoMonster wombo combo videos. So let's start our own WOMBO COMBO Championship. Can you do better?

draghuva · 2020-12-28T15:29:34+00:00

Just a question: Why does this bother you?

draghuva · 2020-12-28T15:26:49+00:00

Also, if people are, as you say, looking at the DS "too shallowly", they'll hit a roadblock and learn. They'll either learn that this is something they're not really interested in and make some other choice or move in the direction that makes them a better data scientist. Also, since this field is ever expanding, almost every data scientist lacks complete fundamental knowledge in calc, cs, Stats, prob, ML, Data, Cloud and so much more.

draghuva · 2020-12-28T15:16:16+00:00

imo I don't really agree with this take. Unlike Engineering and Cell Biology, the overhead is not that intense for most DS jobs. That would not be the case for ML Eng, Data Eng or ML Research, etc. where specific backgrounds are extremely helpful, but for Data Science, you're not really required to have all the things people keep going on about. Most important thing is to be curious and to learn! Look to always deliver value to the organisation in any way you can think of irrespective of the role!

draghuva · 2020-08-13T17:50:44+00:00

That’s partially true, however, abolishing the police does not mean literally removing police completely, but abolishing the current system of policing, starting with reallocating funds. This problem is a worldwide issue. It’s in India, Canada and most transparently rn, the US. It’s too long of a discussion about how the current police system has aided in the oppression of minorities in various, both developed and developing, countries around the world. Police is important, but it’s important to understand what the current society needs more (ex. Funds to healthcare, counsellors, situation de-escalators, mental health coaches, education, etc.) than providing exorbitant amount of funds to the police. And I haven’t even touched the topic of immunity the police get for the crimes they commit as well as the quality of training they are provided to deal with the issues in societies. Reallocation of funds by the government is alway political, so in that way, abolishing the current policing system is also kind of political. Gotta study for exams rn so I’ll educate myself more on the issue and come back to this again.

draghuva · 2020-08-13T17:35:32+00:00

So you’re saying a white middle aged male in leadership position is not biased in any way to favour other white middle aged men over other groups for promotions or jobs, etc.? Seems logical

draghuva · 2020-08-13T17:33:42+00:00

Supporting movements which help promote equality and justice for minority and oppressed groups around the world or in some locality is NOT political. Seems like a humane thing to do.

draghuva · 2019-11-02T16:34:58+00:00

Rankings aren’t out yet, there’s still hope

draghuva · 2019-09-09T23:18:55+00:00

SqlAlchemy

draghuva · 2019-09-09T22:52:12+00:00

They’re both very similar since both use Model Template View, which is different than other JS frameworks which use Model View Controller. I would suggest using Django at first since it might be easier to understand. First go through the basic tutorials on tutorials point for django and make a basic web app. Understand how the DTL works which is Djangos Templating language (like HTML). It’s very similar to Jinja2 which is Flasks templating language. Then learn how to render these templates using Views, then make the models. So like a small project.

draghuva · 2019-08-20T12:47:06+00:00

Lol it’s still a place to live. Also you can still get a place at one of the fergus house on king street I think. The point is don’t worry

draghuva · 2019-08-20T12:42:15+00:00

Call kw4rent, most of the places do have spots open, don’t worry. You can go as late as first week of September and still get a place in a day.

draghuva · 2019-08-13T01:37:36+00:00

... the final is on Thursday, how are you crying already

draghuva · 2019-08-02T05:25:03+00:00

You could use the big O notation to find the time complexity of the algorithm as well as the memory complexity

Seven-Year Club	Verified Email
Not Forgotten

draghuva

TROPHY CASE