{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/679eb54f26de4ab98d895c8f9c7f493b\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/679eb54f26de4ab98d895c8f9c7f493b-1fc8c1849fc2b522.gif","duration":237.805,"title":"Enterprise Profitability Guardrail (n8n &amp; ClickUp + Postgres State Machine) - 22 February 2026","description":"A technical walkthrough of a Fault-Tolerant Financial Monitor designed to prevent project budget overruns in real-time.\n\nArchitecture Highlights:\nTech Stack: n8n (Self-Hosted Docker), PostgreSQL, ClickUp API, Webhooks.\nState Machine Logic: Uses a local database to track atomic state changes, ensuring alerts are only sent during critical status shifts (Idempotency).\nDead Letter Queue (DLQ): A dedicated error-handling branch that logs failed API calls to Postgres for audit and retry, preventing silent data loss.\n\nThis system demonstrates how to move beyond simple \"Trigger-Action\" automations into robust, state-aware engineering."}