How I implemented PostgreSQL outbox polling with SKIP LOCKED, explicit message states, and bounded retries, and where hard-crash recovery needs an additional policy.
How I implemented a Kafka notification consumer with CAS state transitions, separate data and infrastructure error paths, and deliberate acknowledgment ordering.
Why a notification pipeline used one PostgreSQL transaction for business data and event intent, then separate Kafka publishing and consuming workers—and what that structure does not guarantee.
A single parser could not handle every document reliably. This case study explains content-based routing, a compatibility fallback, streaming Excel extraction, selective OCR, and verification for search indexing.
Recursive trees made subtree reads and change detection harder than the workload required. This case study explains a path-based metadata model, prefix index scans, file diffing, and safe synchronization with Elasticsearch.