← Back to Stage 3
Stage 3#311Architecture · Senior~8 min read

Design IndexedDB pending-operation persistence

Operation State Architecture · Pending Continuity

Choose fields, expiry, schema versioning, conflict handling, and cleanup rules for pending transfer records.

Prompt

Design IndexedDB pending-operation persistence

This is a whiteboard rep. Start by naming ownership boundaries, then walk from requirements to state, API shape, UI behavior, testing, and rollout risk.

💡
Tip

The key phrase: frontend owns continuity; backend owns canonical records.

Foundation

What to ground before answering

Choose fields, expiry, schema versioning, conflict handling, and cleanup rules for pending transfer records.

Focus vocabulary: IndexedDB, pending state, reload recovery.

The useful mental model is not to memorize a perfect answer. It is to explain what owns the data, what can fail, what the user sees, and what test would prove the behavior.

System design

Interview explanation prompt

  • What problem is this practice item really testing?
  • What state or contract boundary must be explicit?
  • What edge case would cause a production regression?
  • What would you test first?
  • How would you explain the tradeoff in two minutes?
Self-grade

Self-grade

  • Strong answer starts with ownership boundaries and user risk.
  • Strong answer names failure modes and test strategy.
  • Weak answer jumps to components before clarifying data flow and source of truth.

Model Answer

A strong answer for this prompt should cover:

  • Interview target: Choose fields, expiry, schema versioning, conflict handling, and cleanup rules for pending transfer records.
  • Production nuance: The key phrase: frontend owns continuity; backend owns canonical records.
  • Focus vocabulary: IndexedDB, pending state, reload recovery.
  • Execution shape: Lead with ownership boundaries, then describe state, contracts, edge cases, tests, and rollout risk.

Use this answer spine:

  1. Open with the user or team risk behind "Design IndexedDB pending-operation persistence".
  2. Name the source of truth, API boundary, UI state, or ownership boundary that controls the design.
  3. Give one concrete example from PR TIMES editor work, React/TypeScript migration, performance work, or systems/blockchain practice.
  4. Close with the smallest test, artifact, or rollout guard that proves you would ship it safely.
Review

Recall before moving on

  • What is the one-sentence answer for "Design IndexedDB pending-operation persistence"?
  • Which real experience from PR TIMES, React/TypeScript migration, or systems work supports it?
  • What edge case would you volunteer before the interviewer asks?
  • What is the smallest test or artifact that proves the design works?