Pakka

Open-source milestone escrow reference implementation for Indian marketplaces. Built as a portfolio artifact — production-grade infrastructure code, simulated money by design.

🔗 Live demo:mypakka.vercel.app · License: MIT · Status: 🚧 In development (Phase 4 of 8)

---

What this is

Pakka is a milestone-based escrow system for two-sided service marketplaces (e.g., construction, repair, home services). It's designed as a reference implementation that any marketplace builder can fork and adapt.

The money is simulated by design — real INR escrow in India requires an RBI-approved PPI license. The engineering (atomic ledger, state machine, RLS, dispute resolution, realtime sync) is 100% production-grade. A 1-page production-swap guide shows how to wire in Razorpay Route when you have the license.

Why it exists

This repo demonstrates the kind of infrastructure work senior engineers ship:

• 🔐 Atomic state machine in Postgres — SECURITY DEFINER functions with SELECT FOR UPDATE row locking, never trust the client with money
• 🛡️ RLS as the auth layer — every table policy-protected, admin bypass via is_admin(), defense-in-depth via column-locking triggers
• 📒 Append-only escrow ledger — every wallet movement is a row, sums to zero across the system, verifiable by property tests
• ⚡ Realtime sync — Supabase Realtime pushes state changes to both client and worker UIs simultaneously
• 📱 PWA + TWA — one codebase, web demo for recruiters, Play Store install for end users

Architecture

┌─────────────────┐ ┌──────────────────┐ ┌─────────────────┐ │ Next.js 15 │────▶│ Supabase │────▶│ Postgres │ │ PWA (Vercel) │ │ Auth + Realtime │ │ RLS + Triggers │ └─────────────────┘ └──────────────────┘ └─────────────────┘ │ │ ▼ ▼ ┌──────────────────┐ ┌─────────────────┐ │ pg_cron │ │ SECURITY │ │ (auto-release) │ │ DEFINER fns │ └──────────────────┘ └─────────────────┘

State machine (milestone status):

​ pending → funded → submitted → released │ ▼ disputed → resolved_client | resolved_worker | split

See docs/adr/0001-escrow-state-machine-in-postgres.md for the full reasoning.

Stack

Layer	Choice	Why
Frontend	Next.js 15 (App Router) + TypeScript strict	Hireable, RSC-native
Styling	Tailwind v4 + shadcn/ui	Fast, accessible, composable
State	Zustand + TanStack Query	Client + server state separation
Backend	Supabase (Postgres + Auth + Realtime + Storage + Edge Functions)	RLS, free tier covers demo
Auth	Phone OTP + RLS	Real auth boundary, not middleware
Payments	Mock wallet (Demo Mode)	RBI/PPI license required for real money
Mobile	PWA + TWA via PWABuilder	One codebase, Play Store install
Observability	Sentry + PostHog	Error tracking + analytics

Demo credentials

The live demo runs in Demo Mode. Log in at /login with any phone below. OTP is always 123456 — no SMS is sent.

Role	Phone	Notes
Client	+91 98765 00001	Priya — active jobs, escrow funded
Client	+91 98765 00002	Rohit — milestone awaiting review
Client	+91 98765 00003	Anjali — has an open dispute
Worker	+91 98765 00011	Ravi — gold tier, verified, job completed
Worker	+91 98765 00012	Suresh — submitted milestone
Worker	+91 98765 00014	Deepak — KYC pending (browse-only)
Admin	+91 98765 00099	Demo admin — use /admin route

Local development

Prerequisites

• Node.js 20+, pnpm 9+
• A free Supabase project
• The Supabase CLI (optional, for migrations)

Setup

​

1. Clone git clone https://github.com/shaiksohelll/Pakka.git cd Pakka
2. Install pnpm install
3. Configure cp .env.local.example .env.local Fill in NEXT_PUBLIC_SUPABASE_URL, NEXT_PUBLIC_SUPABASE_ANON_KEY, DEMO_MODE=true
4. Run migrations against your Supabase project supabase link --project-ref YOUR_REF supabase db push
5. Add your service role key to .env.local (see .env.local.example) Then seed demo data: pnpm seed

   or to wipe and re-seed:

   pnpm seed --reset
6. Start pnpm dev

Open http://localhost:3000.

Project structure

​ src/ app/ # Next.js App Router routes components/ ui/ # shadcn primitives features/ # feature-specific components lib/ supabase/ # client, server, middleware Supabase clients schemas/ # Zod validation schemas hooks/ # TanStack Query + custom hooks supabase/ migrations/ # numbered SQL migrations (schema, RLS, escrow fns, hardening) seed.sql # demo data for every UI state docs/ adr/ # Architecture Decision Records production-swap.md # how to wire in Razorpay Route

Status

• Phase 0 — Foundations (repo, Vercel, Supabase, brand)
• Phase 1 — Schema, RLS, escrow functions, hardening triggers, seed data
• Phase 2 — Auth (phone OTP) + role bifurcation + KYC onboarding
• Phase 3 — Job posting + browse + apply
• Phase 4 — Escrow ledger + state machine UI (in progress)
• Phase 5 — Materials, disputes, admin
• Phase 6 — PWA, polish, i18n
• Phase 7 — Tests, observability, security audit
• Phase 8 — Deploy + Play Store

Documentation

• ADR-0001 — Escrow state machine in Postgres SECURITY DEFINER functions
• More ADRs and a production-swap.md arrive in Phase 8.

License

MIT. Fork it, ship it, modify it. Attribution appreciated but not required.

Author

Built by Shaik Sohel — a portfolio artifact demonstrating production-grade marketplace infrastructure.