← Owen Flynn

Hand Me Downs

Textbooks from ASU students, for ASU students. No fees, campus pickup.

Status
Live on the App Store (1.0.1)
Platform
iOS and web
Stack
Next.js, Capacitor, Supabase, Postgres, Metabase
Role
Solo: design, app, backend, analytics, launch
Links
App Store · handmedowns.app

What it is

A two-sided marketplace where ASU students buy and sell used textbooks directly. Nothing works until both sides show up: sellers need a fast way to list, and buyers need to search, trust, and message.

What I built

  • The app: list a book with photos in under a minute, search by title or course code, save listings, and message the seller to set up a pickup on campus.
  • The backend: a Supabase Postgres schema for users, listings, and messages, with row-level security and image storage.
  • Analytics: a Metabase dashboard with 26 SQL cards covering growth, liquidity, pricing, and the buyer/seller balance, read through a read-only database role.
  • Launch tooling: a smart link behind the flyer QR codes that sends iPhones to the App Store and everyone else to the web app.

Why the analytics

Marketplaces live or die on liquidity. Instrumenting the funnel from day one means decisions come from real numbers, not guesses.

Hand Me Downs: Landing screen Hand Me Downs: Browsing textbook listings Hand Me Downs: A listing detail page