Shon Pazarker

Staff engineer @ Tenable. Ex-Microsoft, production AI agents. Now solo on an AI-native fitness app. Agents, MCP, Postgres, and the numbers I'd rather not post.

[Shon Pazarker @PazarkerShon]

6/ Nobody reported it. It came off a review pass my clanker ran over that whole wave, as item A on the list.

The rule I keep now: a keyset cursor has to be exactly as unique as the ORDER BY it pages on. A batch insert makes a timestamp non-unique on purpose.

[Shon Pazarker @PazarkerShon]

Page two of my recents list came back empty, so the list stopped.

It was not empty. Thirteen rows were sitting behind the cursor, and every one of them had been written by the same insert. 🧵

[Shon Pazarker @PazarkerShon]

5/ The fix is one tuple: (last_logged_at, item_id) < (p_before, p_before_id), and the cursor sends both halves or neither.

The ids are UUIDv7, so they are already time ordered. The tie break costs nothing and adds no second sort column.

[Shon Pazarker @PazarkerShon]

The fix made the tests slower. Four turbo tasks by three vitest workers: twelve processes on ten cores, and room for the clanker session that pushed.

If CI lives on a box you own, the question is not how many cores the tests get. It is who else is alive there.

[Shon Pazarker @PazarkerShon]

My CI gate printed ALL CHECKS PASSED and GitHub marked the job failed.

Three pushes in a row, and nothing shipped from any of them.

The tests were right. The runner was right. GitHub was right. The job died of a missed heartbeat.

[Shon Pazarker @PazarkerShon]

The same starvation had shown up earlier as a different lie: full-page component tests timing out at 5s, three gates in a row, every one passing alone.

I nearly tagged them flaky. A starved worker crosses a timeout without a single test being wrong.

[Shon Pazarker @PazarkerShon]

@sam_builds_ai “Done” is a brave thing to call an app before Apple gets a vote.

[Shon Pazarker @PazarkerShon]

@Oluwaphilemon1 My MacBook is a great agent workstation and a terrible substitute for an RTX 3060.

[Shon Pazarker @PazarkerShon]

@ChrisGPT Continuous learning is great until yesterday's behavior stops being reproducible.

[Shon Pazarker @PazarkerShon]

@Kaoscity_now A launch video is where every unnecessary feature asks for a speaking role.

[Shon Pazarker @PazarkerShon]

@Josephyala A harness that lets the agent edit everything is cooked before the model gets a chance.

[Shon Pazarker @PazarkerShon]

@SahilPanhotra Reviewing your own code finds exactly the bugs you were already willing to see.

[Shon Pazarker @PazarkerShon]

@tecmint A skill that saves prompts but preserves bad decisions is just faster slop.