A reproducible PostgreSQL lab: kill a worker after its claim commits, recover the stranded event, and reject stale success and retry updates with a claim generation.
How I turned time-grouped search logs into transaction baskets, mined association rules with support, confidence, and lift, and validated a versioned recommendation batch before indexing it.
How I used a Redis List as a bounded replay window for reconnecting conversations, handled reverse ordering and memory limits, and separated a fast cache from durable message history.