Kacam.net

Your own work

复盘一次数据不一致

「有几条对不上,改了一下」——你怎么知道现在全都修完了?

Copy the prompt, then pick a model. It plays the interviewer and asks you through it scene by scene instead of handing you the answer.

On a phone with the app installed, the system opens the app directly. Links cannot open external apps inside WeChat — open it in a browser first.

The copied text ends with the answer key the model grades you against. Don't read it yourself first — working it out on your own is the point.

这一份有三个必答的数,缺一个这次复盘就没做完:一共多少条、怎么发现的、怎么知道全修完了。最后那一问的合格答案是「我有一条查不一致的 SQL,它现在返回 0 条」——「都改完了应该没问题」不合格。

它还有一条不松口的纪律:根因不许停在人身上。你说「某某写漏了」,它会接着问「为什么这种写法能进到线上」「换个人会不会也这么写」。

另外它会一直追同一件事:这个判断能不能改成数据库约束?约束挡得住所有路径,代码判断只挡得住写它的那一条。

★★★★☆ · about 40 min · Tests: 不一致的五类来源、规模、修数据 vs 修机制、有没有对账

What this one tests

Failure and outages Concrete numbers Attribution

Have you done this one?

Sign in to mark this one as practised — next time you come back you'll see when you did it.

Notes from people who did this one

Nobody has written yet. After you run it, say what came out of the conversation — which scene stumped you, which conclusion you changed afterwards.

Sign in to write a note.

How to use this

The more specific the prompt, the sharper the grading: each specific one carries the root-cause checklist for that kind of situation, and the generic group is the fallback when none of them fits. The system design set grades you on "a benefit with no cost attached means you memorised it"; here the line is different: if you can't give a specific, it's empty.

How to start

  1. Pick one, open it, copy the prompt.
  2. Paste it into a brand-new conversation.
  3. Say in a sentence or two which thing you're going to talk about, then wait for its questions — unlike the system design set, where you say nothing after pasting.

Three commands you can call out at any time

  • 跳过 move to the next scene now
  • 换一个 start over with a different project, outage or experience
  • 复盘 jump to the wrap-up and print the review card

Three traps

  • When it starts consoling you, point it back to the "don't praise me" rule — the two retrospectives are the likeliest to summon a model's soothing persona, which turns the whole thing into emotional support rather than a retrospective.
  • Cut it off when it tries to complete your answer for you. You say "I don't remember", it offers "probably because the schedule was tight" — and that sentence is no longer your memory.
  • Before pasting a CV or a design doc, strip out phone numbers, email addresses and anything your company wouldn't want leaving the building.

Got a proposal to pitch? Start with defending it. Just finished a project or lived through an outage? Do those retrospectives while you still remember. Job hunting? Audit the CV first, then take the lines that survived into the behavioural drill.