Optimize, Improve & Fix Collaborative Board SaaS Tool

Job ID: 39424806

Budget: $30 – $250 USD

I've developed collaborative board tool SaaS using Lovable & Supabase. (PM for url)

Scopes:
- Identify & fix the root cause of excessive API requests. Now, a single CRUD action can trigger up to 20 or more API calls, making the implementation inefficient and unscalable.
- Analyse & fix the current database schema, structure, functions, RLS policies, and CRUD operations.
- Evaluate & fix the real-time subscriptions, connections, and synchronisation behavior across multiple users.
- Fix the real-time view synchronisation between users on the same screen for each tabs.

Why do multiple API requests still persist despite using Supabase Realtime?
20 users collaborating on the same board simultaneously?
Multiple teams (each with 20 users) maintaining their own boards concurrently?
How can we optimize CRUD and sync operations to behave more efficiently smooth & instant, like in RetroTool? eg. https://retrotool.io/HU8aghozg7Ln4bwiryT87

I open to any suggestion for simpler approach, yet it solve the problem with great UI/UX!

Tech Stacks: React,TypeScript, Vite & Tailwind CSS, Supabase, PostgreSQL database, Realtime (Websocket).