{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/1c62649bd94b42ed9f69211fbddeabf8\" 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/1c62649bd94b42ed9f69211fbddeabf8-643382d65e31e1d0.gif","duration":280.139,"title":"Incident Updates, Diffs, and Incident Analytics Demo","description":"This Loom demonstrates an incident management workflow and the underlying data model for tracking updates with diffs. It shows an incident initially declared for product catalog missing with no severity or description, then updated in the incident channel from “cannot place order” and later acknowledged and resolved, including resolution timestamps and total incident duration. The creator discusses design decisions like sorting by fields and environment, using Ruby on Rails and SQL queries, and storing instance edit diffs in binary JSON with a note that production could use formats like Google Protobuf or CDC. It also highlights the schema and migrations and includes a simple average incidents per day stats panel for system health."}