All projects
Case study · Full Stack · Offline-First
RepoBooknScore
Offline-first cricket scoring with a dual database
Flutter
Supabase
PostgreSQL
SQLite
Python
Gemini
LLM Agents
01The problem
Tape-ball cricket is scored where connections drop. The app had to keep working offline and reconcile every match once it came back online.
02Approach
- 01Designed the relational schema and scoring engine for offline-first use.
- 02Ran SQLite locally and Supabase/PostgreSQL as the source of truth in the cloud.
- 03Synchronized records on reconnect with a zero-data-loss design.
- 04Built a companion Python and Gemini multimodal AI service that turns match data into cinematic commentary and production scripts.
03Outcomes
- Scoring continues through network interruptions with zero data loss on reconnect.
- Player, team, and match analytics come out structured.
- The AI service derives commentary and video-ready scripts from raw match events.