Catalog intelligence
Search tracks, artists, albums, and playlists through normalized MPD entities.
Music streaming analytics app
Statify
Explore a playlist-scale catalog, play 30-second previews, and turn listening events into ranked artists, trend deltas, heatmaps, and discovery paths.
Normalized tables
12
Advanced queries
6
Preview source
iTunes
Artwork source
Spotify
Designed for the demo loop
Everything the app does is one click away.
Statify keeps the rubric-heavy pieces visible: relational data, preview playback, playlist creation, admin ingest controls, and analytics backed by hand-written SQL.
Preview listening
Play iTunes previews and record listening history with idempotent events.
SQL-backed stats
Turn raw history into top artists, heatmaps, trends, and hidden gems.
Playlist lab
Create collections, reorder tracks, and compare public playlists.
Connected stack
MPD catalog in Postgres, previews from iTunes, artwork from Spotify.
The frontend is not a static mock: every browse, play, playlist, and analytics route is wired through the API and shared DTOs.
Auth and admin controlsTokenized UI
Demo path
A short route through the working app.
1
Search the catalog
2
Play an iTunes preview
3
Review history and stats
Project scope
Built around the Million Playlist Dataset.
Statify combines normalized playlist data, account sessions, listening history, playlist creation, admin operations, and SQL analytics into one demoable product.