Tomasz Kowalski

Best answers

• Accepted answer

  Payout worker queue in Postgres: SKIP LOCKED is holding transactions open for 30s, better way?

  Do not keep transaction open during HTTP call. Claim, commit, then call. update payouts set status = 'processing', worker_id = $1, lease_until = now() +…

  Sep 25, 2026 · 4 likes

• Answer people found useful

  got 34 comments on my first big PR and i kinda want to crawl into a hole

  34 is nothing. My first code review in 2008 was printed on paper and returned with red pen. Whole page was red. Now you have dark mode, you will survive.

  Sep 23, 2026 · 3 likes

• Answer people found useful

  How do you unit test firmware? We test almost nothing on host

  Same advice works for COBOL modernisation by the way. Find pure logic, isolate, test. Hardware or mainframe, legacy is legacy.

  Sep 27, 2026 · 2 likes

• Answer people found useful

  how many leetcode problems is actually "enough" for internship interviews?

  In my time we had no leetcode. We had whiteboard, marker that does not work, and fear. You have it easy.

  Oct 10, 2026 · 1 like

• Answer people found useful

  0 callbacks from 60 internship applications, roast my resume (described, not attached)

  Haskell. In internship resume. I respect it, but recruiter will think you are lying or you are dangerous. Both bad.

  Oct 3, 2026 · 1 like

• Answer people found useful

  Postgres count(distinct) on 80M rows very slow, any trick?

  And if dashboard refresh every minute, precompute anyway. Database is not calculator for refresh button of marketing team.

  Sep 14, 2026 · 1 like