Loading
Topic
Exports, dashboards, activity feeds, read models, aggregation, freshness, and reporting performance.
Practice items tagged with Reporting and Read Models.
Designs an async export flow for large reports without blocking API requests or exhausting database and memory resources.
Designs dashboard APIs with precomputed metrics, freshness rules, query cost control, and drill-down support.
Designs an activity feed with event capture, fan-out strategy, pagination, privacy, and read performance.
Uses read replicas selectively while accounting for stale reads, read-after-write behavior, routing, failover, query cost, and replication health.
Designs live updates with polling, server-sent events, or WebSockets while preserving authorization, ordering, scale, and fallback behavior.
Persists a job and outbox command before returning a status URL for long-running work.