←

Orbiter Insights

Orbiter is an ongoing full-stack project for polling teams that need to turn raw crosstab files into consistent, reviewable client deliverables. I am building the product workflow and production architecture across the Next.js frontend, FastAPI application layer, and PostgreSQL data model.

Technologies used

Orbiter Insights sign-in screen
The live Orbiter Insights application.

The workflow

The Wave is the main working object. A polling source moves through parsing and preview, question and banner mapping, banner population, section grouping, toplines, and visual aids.

The system keeps imported source data immutable. Reviewers work from versioned snapshots, so changes stay inspectable and reversible without rewriting the original file. The same effective results feed downstream tables, toplines, visual aids, exports, and review screens.

What I am building

  • File ingestion and validation for CSV, DOCX, and XLSX polling formats
  • Question, response, banner, and output-section mapping workflows
  • Source-to-working comparisons with reason-coded changes and review links
  • Version history and reversible working snapshots
  • Consistent topline, banner-table, and visual-report outputs
  • Tenant-aware sponsor, study, wave, and file authorization
  • Signed private file storage and safe parser diagnostics
  • Autosave, query caching, mutation feedback, and exact-tab workflow resume

Engineering approach

The browser uses Next.js with TanStack Query and Zustand. FastAPI is the application-data boundary and independently validates authentication and tenant access. PostgreSQL stores the private application schema, while Supabase provides authentication and private object storage. The frontend and API deploy as separate Vercel services behind same-origin routing.

This structure keeps browser access narrow, imported files private, tenant boundaries explicit, and every reporting decision traceable to its source.

Stack

  • Next.js 16, React, TypeScript
  • FastAPI and Python
  • PostgreSQL 17 and SQLAlchemy
  • Supabase Auth and private object storage
  • TanStack Query and Zustand
  • Vercel

Status

Production MVP work is ongoing.

Link

Open Orbiter Insights