Robin Singh

notes

Postgres SKIP LOCKED for Work Queues

SELECT ... FOR UPDATE SKIP LOCKED can support a modest Postgres work queue: workers claim rows without blocking, while leases, fencing, retries, and indexes provide the recovery behavior.

architecture

Durable Workflow Engines: A Queue Is Not the Source of Truth

Follow one five-day automation to see what queues, idempotency, and durable workflow engines each solve when processes crash.

architecture

Building a Durable Workflow Engine

Build durable execution around Postgres and a queue, including unique starts, outbox delivery, fenced work, timers, signals, and safe side effects.

architecture

Durable Workflows with Temporal

Follow the same multi-day automation on Temporal to learn replay, activities, sagas, versioning, and the guarantees applications still own.

architecture

Designing an AI Gateway

Follow one model request through identity, policy, routing, failover, streaming, cost accounting, caching, and observability.

architecture

Semantic Caching for LLM Calls

Learn when a semantic cache can safely reuse an LLM answer, how false hits happen, and how tenant boundaries, evaluation, and freshness limit the risk.

researching

Evaluating Retrieval for Transcript Search

A measurement plan for transcript search: separate retrieval from generation, build a fair test set, calibrate automated judges, and compare dense, hybrid, reranked, and timestamp-aware search.