Design a Collaborative Online Spreadsheet System
0%
Editorial Solution
System requirements
Functional
Capacity estimation
Traffic
API design
Spreadsheet Management (REST)
Database design
Schema
High-level design
API Gateway
Request flows
Cell Edit Flow (Write Path)
Detailed component design
Conflict Resolution: The Core Challenge
Trade-offs and tech choices
OT vs CRDT vs Last Write Wins
Failure scenarios and bottlenecks
WebSocket Disconnection
Future improvements
Offline Editing with Sync
Table of Contents
Premium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockPremium content
UnlockTry this problem yourself
Reading a solution is not the same as producing one under interview pressure. Design it on the whiteboard and get scored feedback.
0%
Editorial Solution
System requirements
Functional
Capacity estimation
Traffic
API design
Spreadsheet Management (REST)
Database design
Schema
High-level design
API Gateway
Request flows
Cell Edit Flow (Write Path)
Detailed component design
Conflict Resolution: The Core Challenge
Trade-offs and tech choices
OT vs CRDT vs Last Write Wins
Failure scenarios and bottlenecks
WebSocket Disconnection
Future improvements
Offline Editing with Sync