The picture here is what AI struggled to give me at all costs, circling me here and there, hallucinating and stuff. I just wanted to have glue NS case along with non-glue NS case + some terminology definitions, to see where are these IPs are coming from to connect the dots in my mind, and this AI mfcker couldnt do it, none of them could.

#aifail

Btw this is legit trace from dig cmd, so it is the representation of real world scenario with real ips, server names, etc. You can trust it

Noted, pushing it to my “content queue”. Thanks for feedback

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