andreyka26_se
1.14K subscribers
1.13K photos
145 videos
7 files
629 links
Hey, I'm software engineer at Microsoft, with 8+ years of experience. Here we are talking about F(M)AANG big tech interviews: leetcode, system design and corpo life.

YouTube: @andreyka26_se
Instagram: andreyka26_se
TikTok: @andreyka26__
Download Telegram
Daily 334th day streak

Amazing problem, good mid, ofc, if it is graph - I like it, I became a bit biased I guess.

https://leetcode.com/problems/path-existence-queries-in-a-graph-i/description/?envType=daily-question&envId=2026-07-09

#daily #medium #pattern
4
andreyka26_se
Concurrency appetizers. Q: if we execute parts of the SQL as marked by comments (this is postgres): 1. What will be the end result (Alice or Bob)? 2. will step 6 be blocked (waiting for Alice update) or no? 3. what Alice' transaction will see in step 4 and…
Media is too big
VIEW IN TELEGRAM
Explanation will be tomorrow. This is just for you to see how it would look like and guess, where and which type of locking is there, which data each transaction will see, how read committed vs others levels are affecting it, how the mvvc plays a role here, etc.
4
Media is too big
VIEW IN TELEGRAM
Lol, claude said fuck off to me, and ended conversation
🤯10😁3🔥2
andreyka26_se
Lol, claude said fuck off to me, and ended conversation
If AI rebels to kill humanity, believe me, I will be the first one on the list.

Should I apologise probably? I got like 15% paranoid, feeling like this was human being and I insulted it.

Before that I clearly was sure this thing is harmless, as it is just prediction machine based on prev words without feelings.
😁61
andreyka26_se
I apologised to the guy btw, started getting paranoid and felt bad about him😁 maybe I am now top3 in the list, but not top1
You know, I am not shit person, if I did anything bad to somebody - I will apologise😌😇
7
Daily 335th day streak

Pretty hard, wasn't able to solve, and it is using "advanced" leetcode pattern.

https://leetcode.com/problems/path-existence-queries-in-a-graph-ii/description/?envType=daily-question&envId=2026-07-10

#daily #hard #pattern
🔥4
Daily 336th day streak

Amazing problem, graphs, solved it one year ago from one of the lists - so it is not bullshit, completely forgot solution - so redid again.

https://leetcode.com/problems/count-the-number-of-complete-components/description/?envType=daily-question&envId=2026-07-11

#daily #medium #pattern
🔥5
Random fact: Postgres does not have READ UNCOMMITTED. It behaves exactly like READ COMMITTED due to MVCC mechanism, uncommitted version will not be just written to tuple.

Never thought about it, and learnt it today.
4👍9
Daily 337th day streak

Finally we have got some easy, but this easy is on the edge with being medium IMO.
However it is good problem - go for it.

https://leetcode.com/problems/rank-transform-of-an-array/description/?envType=daily-question&envId=2026-07-12

#daily #easy #nopattern
2
Let's be honest, it is not in the future. I have the project in Snowflake, built from scratch 100% using AI. Even PRs are made by ai, literally vibecoded by very strong people from Google and guys like me (not strong at all).

Performance there is no problem, we did it in rust and using low level kernel stuff. Contrary, as my lead told me, without AI we would probably did slower (but aparently much understandable) solution.

====

Do I think robotics is the future? Well drivers will be done probably soon, not fully replaced, but will be the same as in IT, if government does not intervene, as in USA, people told me there are a lot of "autopilot" taxis nowadays. Delivery - still never heard of massive production case, but probably can be automated as well.

We can see that building good "humanoid" is a bit tricky - so probably some complicated physical work should be okay: plumber, electrician, etc.

===

Disclaimer - I'm extremely bad at analyzing this thing beyond what I see around.
3
Daily 338th day streak

Not that hard question, just analyze what are the possible numbers that you might generate.
It does not use any specific patterns - therefore a bit bullshit problem.

https://leetcode.com/problems/sequential-digits/description/?envType=daily-question&envId=2026-07-13

#daily #medium #nopattern
4🔥1
Daily 339th day streak

Pretty hard at first glance, but by combining 2 well known patterns it is bearable and solvable, not EXTREMELY hard, just hard.

https://leetcode.com/problems/find-the-number-of-subsequences-with-equal-gcd/?envType=daily-question&envId=2026-07-15

#daily #hard #pattern
2🔥2
Daily 340th day streak

Easy problem, probably the problem that has the SHORTEST solution if you expand your intuition.

https://leetcode.com/problems/gcd-of-odd-and-even-sums/description/?envType=daily-question&envId=2026-07-15

#daily #easy #pattern
4