Skip to main content
JCR.DEV
All work

v1.0.0, Android and iOS

01.4Case Plates

Agriova

A farm ledger that works without signal.

Role
Solo developer
Stack
React Native and Supabase
1,207
Jest tests against real SQLite
56 dp
touch targets for older hands
20
assistant questions a day, per farmer
Decisions
  1. 01Local-firstSQLite on the phone is the source of truth; screens never wait on the network.
  2. 02Exact moneyInteger centavos on phone and server, so profit totals never drift.
  3. 03A private assistantGemini sits behind an Edge Function; the phone sends a farm summary, never a name.
  4. 04Built for the userBisaya and English, 56 dp targets, checked at 1.3x font scale.
Technical notes
Context
Smallholders rarely know whether a season made or lost money, because records live in memory or loose notebooks. Pilot users average 57 years old, farm under weak signal on budget Android phones with 2 to 4 GB of RAM, and read Bisaya first. Every screen answers one of three validated questions: am I earning, will my harvest spoil, am I getting a fair price.
Role
Solo developer: product, design adaptation, mobile app, backend, sync engine, AI assistant, CI and release pipeline. Shipped as v1.0.0.
Architecture
Local-first. SQLite on the phone is the source of truth, so screens never wait on the network. A custom outbox engine pushes rows parents-first and pulls by server timestamp, with last-write-wins because each farm has one owner. Only sign-in, the assistant and account deletion need a connection.
Money
Amounts are integer centavos and quantities integer thousandths, identical on SQLite and Postgres, so profit totals never drift. Conversions live in one units module at every input and display boundary.
Assistant
Heat, rain and spoilage warnings come from a rules engine on the phone and work offline. Chat runs Gemini behind a Supabase Edge Function: the key never ships in the app, the phone sends a farm summary with no name or email, and a security-definer function enforces a 20-question daily quota in one statement.
Security
Row-level security on every farmer table, plus composite foreign keys on (id, owner_id) so the database itself refuses links to another farmer’s plot. Account deletion runs server-side from the caller’s token and cascades through every table before the phone is wiped.
Design
Adapts a Figma prototype to the real user: 56 dp touch targets, Bisaya and English for every string, layouts checked at 320 to 412 dp and 1.3x font scale. About 25 primitives on colour, type and spacing tokens; iOS uses native Liquid Glass tabs.
Correctness
1,207 Jest tests against real SQLite, pgTAP tests for RLS and cascading deletes, and Maestro flows for onboarding and recording. Network calls carry a 20 s deadline with a warm-up health check after idle, tuned on the pilot hotspot. GitHub Actions runs every check on push; EAS Build and EAS Update ship releases.

Full stack

  • React Native
  • Expo
  • TypeScript
  • expo-router
  • SQLite
  • Drizzle ORM
  • Supabase
  • PostgreSQL
  • Deno Edge Functions
  • Google Gemini
  • Jest
  • pgTAP
  • Maestro
  • EAS Build
  • GitHub Actions
Next projectRoad Restoration