Composting Platform

Overview

API (Fastify, Prisma, PostgreSQL) for farms and leira measurements; JWT auth and roles (USER, ADMIN, MASTER, DEV). Mobile app (Expo, React Native, Redux Toolkit, NativeWind) with offline storage (Expo SQLite) and automatic sync when online. Optional Google Sheets integration for Masters.

Problem

Field workers need to record compost measurements (temperature, humidity, smell, phase) often without reliable connectivity. Data must sync when back online and align with a central API and optional spreadsheets.

Solution

Backend: REST API with signup/signin, farms CRUD, measurements CRUD, and sync endpoints (upload/download). Mobile: login, dashboard, farms and measurements lists, create/edit measurements offline; auto-sync with conflict handling. Optional Google Sheets worksheet per Master for reporting.

My Role

• Designed the offline sync flow and conflict-resolution strategy (SQLite ↔ REST API).
• Built the JWT role system (USER / ADMIN / MASTER / DEV) and farm/measurement data model.
• Implemented real-time sync to Google Sheets on connect, replacing manual spreadsheet entry.

Impact & Results

Replaced paper-and-pen field collection followed by manual spreadsheet entry with direct in-app capture. When connectivity is available, measurements sync in real time to the central API and optionally to a Google Sheets worksheet — giving managers instant visibility. Offline SQLite storage ensures zero data loss in areas without signal, which was the core motivation for the offline-first architecture.

Tech Stack

Architecture

Backend: use-cases (auth, farms, measurements, sync), repositories, controllers, JWT plugin. Mobile: Expo Router tabs, store slices (auth, farm, measurement, sync), SQLite repositories, sync service. See the architecture section for database model and diagrams.

Screenshots

Login

Dark theme

Light theme