← Back to Portfolio

Airtable Clone

A fullstack Airtable-like table with 50 000+ row virtualization, inline editing, optimistic updates, and realtime sync via WebSocket.

Overview

A fullstack monorepo that replicates core Airtable functionality. The frontend (Next.js 19 + TanStack Table + TanStack Virtual) renders 50 000+ rows without performance degradation. Cell edits are applied optimistically on the client, sent via REST to an Express 5 backend, persisted in PostgreSQL, and broadcast to all connected clients through Redis Pub/Sub and WebSocket — enabling realtime multi-tab sync. The entire stack runs via Docker Compose.

Technologies Used

Next.jsReactTypeScriptNode.jsExpressPostgreSQLRedisDocker

Key Features

  • Virtualized table rendering 50 000+ rows via TanStack Virtual
  • Inline cell editing — text, number, select, date, decimal
  • Optimistic updates with automatic rollback on server rejection
  • Realtime sync across tabs via WebSocket + Redis Pub/Sub
  • Horizontally scalable BFF — tested with multiple Docker instances

Screenshots

Airtable Clone screenshot 1
Airtable Clone screenshot 2
Airtable Clone screenshot 3
Airtable Clone screenshot 4