All projects
Case study — Full Stack · Offline-First
RepoBooknScore
Offline-first cricket scoring with a dual database
Flutter
Supabase
PostgreSQL
SQLite
Python
Gemini
01The problem
Cricket scoring is most needed where the connection drops. The app had to keep working locally and reconcile perfectly 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 sync target.
- 03Synchronized on reconnect with a zero-data-loss design across network interruptions.
- 04Built a Python + Gemini multimodal AI service using agents to turn match data into commentary scripts.
03Outcomes
- App continues scoring offline with zero data loss on reconnect.
- Dual DB gives local speed with cloud durability.
- AI commentary service derives story from raw match events.