Stitchify
A hybrid offline-first application designed to help tailoring businesses manage customer measurements, orders, inventory, stock, and expenses, with seamless cloud synchronization.
- React Native
- Expo
- TypeScript
- Zustand
- AsyncStorage
- SQLite
- Firebase
- Google Cloud Console
Project Overview
Platform
Mobile App
Frontend
React Native, Expo
Database
SQLite, Firestore
Authentication
Firebase Auth
The Problem
Tailoring businesses often rely on physical notebooks to store sensitive customer measurements, manage orders, and track expenses. This traditional method leads to lost records, inefficient stock tracking, and scaling difficulties as the business grows.
The Solution
I built Stitchify to digitize the entire tailoring workflow. By combining an offline-first architecture for fast, reliable data access with cloud synchronization for backups, the application ensures that business owners can securely manage orders and inventory without worrying about internet connectivity or data loss.
Key Features
Customer Measurements
Detailed digital profiles for clients tracking their exact tailoring measurements securely.
Order Tracking
Monitor order states from creation to completion, enabling efficient production pipelines.
Expense Tracking
Record business expenses and purchases directly in the app to track profitability.
Cloud Sync & Google Drive
Robust backup and restore workflows utilizing Firebase and Google Drive API integration.
Architecture
Engineering Challenges
Offline-First + Cloud Synchronization
Challenge: Supporting fast, reliable local data access (SQLite) while synchronizing selected records with cloud services (Firestore) without data conflict.
Solution: Established a hybrid architecture where SQLite serves as the absolute single source of truth for the local device, and Firestore acts strictly as a backup mechanism to push/pull serialized state.
Account Data Isolation
Challenge: Device-level storage needed to become user-aware so settings and data from multiple accounts didn't interfere.
Solution: Linked local SQLite database instances to Firebase Authentication UID state, guaranteeing that local schemas and data were isolated per active session.
Results & Learnings
Stitchify successfully demonstrates how to build resilient, offline-first mobile applications that solve real operational business workflows. The project greatly deepened my experience in bridging cross-platform UI with localized relational data stores while safely persisting to NoSQL cloud infrastructure.