Durga Prasad
Back to projects

Case study · Full-Stack

Syncro Flow

Multi-tenant realtime collaborative workspace where every mutation is validated, authorized, persisted to PostgreSQL, and propagated across connected clients over WebSockets.

Syncro Flow screenshot

Problem

Realtime collaboration tools often struggle with consistency, authorization, and scalability across multiple tenants.

Solution

Built a multi-tenant workspace with separate backend layers for persistence, authorization, and event broadcasting using WebSockets.

Architecture

  • Next.js App Router with Server Actions for validation
  • PostgreSQL + Drizzle ORM for data persistence
  • Pusher WebSockets for realtime event propagation
  • Role-based permissions and workspace invitations
  • Automatic polling fallback for WebSocket failures

Challenges

  • Ensuring mutation consistency across connected clients
  • Implementing secure multi-tenant data isolation
  • Handling WebSocket reconnection and fallback strategies

Outcomes

  • Production-ready realtime collaboration platform
  • Scalable multi-tenant architecture
  • Robust synchronization with automatic fallback

Stack

Next.jsTypeScriptPostgreSQLDrizzle ORMPusher