Cursor State { user_id, user_name, color, position: { line, col } // for text, or { x, y } for […]

OT for Text Operations are insert(pos, text) and delete(pos, len). Transformation Function transform(op1, op2) adjusts positions of concurrent ops to

Overview An ML-powered content moderation service classifies user-submitted content (text, images, video) at scale, routes borderline cases to human reviewers,

Quiz Engine Data Model A quiz engine supports timed assessments, randomization, auto-grading, leaderboards, and anti-cheat mechanisms. Core Tables Quiz (id,

Content Archival Service: Storage Tiers The archival service manages long-term content retention across four S3 storage tiers with different cost

Reading List Service: Core Schema The reading list service saves articles for later reading with content extraction and offline availability.

Bookmark Service: Core Schema The bookmark service persists saved URLs with rich metadata and organizational structure. Bookmark Table id BIGSERIAL

Data Model Dashboard Table Dashboard ( id, name, owner_id, layout JSONB, — grid positions created_at ) Widget Table Widget (

Tile Coordinate System Map tiles use a Z/X/Y (zoom / column / row) scheme: Zoom 0 = 1 tile covering

Entity Types Nearby search must handle two fundamentally different entity classes: Static entities — restaurants, venues, stores; position rarely changes

Data Model EmailTemplate ( id SERIAL PRIMARY KEY, name VARCHAR NOT NULL, locale VARCHAR NOT NULL DEFAULT ‘en’, subject_template TEXT

Template Syntax Core syntax: {{variable}} for variable substitution, {{#if condition}}…{{/if}} for conditionals, {{#each items}}…{{/each}} for loops, {{> partial_name}} for partials,

What Is an Access Log Service? An access log service captures structured HTTP request/response details from every service in the

What Is a Request Routing Service? A request routing service directs incoming HTTP requests to the appropriate upstream based on

Returns Processing System: Low Level Design Core Data Model Two primary tables capture return requests and the individual items within