# Orchard: Finding iPhone App Niches Where Small Publishers Earn

Apps & experiments · Creator, sole engineer · prototype

A research dashboard for choosing an app to build from where small publishers already earn, not from an idea.

## The detail

It discovers up to the top 100 grossing apps in each of 27 App Store categories, reads public revenue estimates for them, and finds niches: groups of at least two differently named publishers earning above a floor you choose.

One scheduled collector runs per category, with locks so a scheduled and a manual scan cannot overwrite each other. Interrupted scans save their completed batches and resume. A failed re-check keeps the previous figure but removes it from niche evidence.

The limits are part of the interface: amounts are a provider's rounded estimates rather than verified revenue, coverage is bounded, and an upper bound is never shown as a point estimate.

Next.js, React, TypeScript, Drizzle, PostgreSQL, Docker.

## What I did

- Built a dashboard that discovers top-grossing apps across 27 App Store categories
- Read public revenue estimates and grouped apps into niches with at least two different publishers
- Ran one scheduled collector per category with locks so scans cannot overwrite each other
- Made slow scans resumable and kept failed re-checks out of the evidence
- Kept upper-bound estimates as upper bounds instead of point values
- Deployed it privately behind sign-in, with a local Docker mode

## Stack

Next.js, React, TypeScript, Drizzle, PostgreSQL, Recharts, Docker, Task Scheduling, Data Extraction

Case study: https://www.siddhvasudev.com/projects/orchard-finding-iphone-app-niches-where
