Product case study

Deliberate playlist building, designed around real platform constraints.

TuneFacet is a full-stack portfolio project built to demonstrate careful API integration—not just a pretty dashboard. The public demo is complete on its own, while approved reviewers can exercise the live Spotify workflow.

Product surface

A focused working interface with search, sources, ordering, drafts, empty states, errors, and success flows.

Secure integration

Server-side OAuth, encrypted refresh tokens, HTTP-only sessions, minimal scopes, and explicit disconnection.

Durable backend

Cloudflare D1 persistence with prepared statements, relational draft items, ownership filters, and indexed queries.

Why it is different

A compliant companion, not a taste profiler.

TuneFacet displays user-controlled Spotify sources directly and keeps playlist decisions human. It does not derive personality, mood, genre percentages, listening benchmarks, or AI recommendations from Spotify content.

  • Public sample mode with original fictional catalogue
  • Server-side Spotify Authorization Code flow
  • Top tracks, playlist browsing, and catalogue search
  • Manual playlist assembly, ordering, and private creation
  • Durable drafts with ownership checks and deletion
  • Encrypted tokens, refresh handling, and disconnect cleanup
  • Responsive, keyboard-friendly interface and clear states