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

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

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock

Premium content

Unlock
Try 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.


Markdown supported

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

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