Wdyt?

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 Bob's transaction - in step 8?

Daily 333d day streak

It is a bit bullshit, it should be marked as hard. I didn't know the answer, some new concepts are there that I have never met.

https://leetcode.com/problems/concatenate-non-zero-digits-and-multiply-by-sum-ii/description/?envType=daily-question&envId=2026-07-08

#daily #medium #nopattern

That vibe after the gym, evening, silence, almost no wind. Love Dublin’s summer. Never too hot, not that rainy as it was during winter, calm.

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

My punishment for not actually doing (but rather checking solution straight away) daily is this hard form the list.

Amazing problem, I would actually rate as medium - so try it out, it is from Top 100 liked list.

https://leetcode.com/problems/sliding-window-maximum/description/?envType=study-plan-v2&envId=top-100-liked

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.

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.

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😌😇

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

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

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.

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

Sound on

Literally this meme

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.