Pineapple TV
A Streaming Recommendation Application
Executive Summary
Pineapple TV is an application that learns viewing preferences from the videos users watch. It understands real-time events such as when a user starts watching a show, reach a 25% or 75% mark, or when they’ve finished it. Users can also rate and review shows and episodes. Based on these events, ratings, and recommendations, the application can recommend shows users are most likely to watch.
The application captures % complete, star rating, and review. This is then converted to add more meaning to the embedded text
% complete to an engagement level
pct >= 90 ? "fully-engaged completed finished watched-entirely"
: pct >= 75 ? "highly-engaged mostly-watched committed"
: pct >= 50 ? "moderately-engaged partially-watched"
: pct >= 25 ? "briefly-sampled started explored"
: "barely-started abandoned lost-interest"
star rating to a sentiment
rating >= 4 ? "loved excellent highly-recommend wonderful"
: rating === 3 ? "liked okay acceptable decent"
: "disliked poor disappointing avoid";
These points are combined with other fields into embedded text to power recommendations:
{
"VectorStore1":["$.user_id","$.genre","$.content_tags","$.themes","$.tone","$.pacing","$.emotional_beats"],
"VectorStore2":["$.review_text","$.rating_sentiment","$.engagement_level"],
"VectorStore3":["$.tone","$.emotional_beats","$.themes","$.pacing"]
}
These considerations are all taken into account when calculating the score. This allows the app to display the user’s watch history and some recommendations based on other user’s ratings/genre match
Sample Events for Railengine Ingestion
[
{"event_type":"video_started","timestamp":"2025-12-24T00:10:50.749Z","user_id":"user_qaxw4dxdt","video_id":"k_vid_45678","user_video_id":"user_qaxw4dxdt-k_vid_45678","video_title":"Cornerstone S1E1","genre":"sci-fi, epic, drama","content_tags":"space-opera, grand-scale, philosophical, world-building, political-intrigue, ensemble-cast, futuristic, intellectual","themes":"destiny, civilization, power, prophecy, legacy, imperialism, human-progress, faith-vs-science","tone":"epic, cerebral, grandiose","pacing":"slow-burn, sprawling","emotional_beats":"awe-inspiring, contemplative, dramatic, ambitious, overwhelming","duration_seconds":1860,"watched_seconds":0,"percent_complete":0,"session_id":"session_uwmiakztb","engagement_level":"barely-started abandoned lost-interest"},
{"event_type":"video_progress","timestamp":"2025-12-24T00:10:51.998Z","user_id":"user_qaxw4dxdt","video_id":"k_vid_45678","user_video_id":"user_qaxw4dxdt-k_vid_45678","video_title":"Cornerstone S1E1","genre":"sci-fi, epic, drama","content_tags":"space-opera, grand-scale, philosophical, world-building, political-intrigue, ensemble-cast, futuristic, intellectual","themes":"destiny, civilization, power, prophecy, legacy, imperialism, human-progress, faith-vs-science","tone":"epic, cerebral, grandiose","pacing":"slow-burn, sprawling","emotional_beats":"awe-inspiring, contemplative, dramatic, ambitious, overwhelming","duration_seconds":1860,"watched_seconds":465,"percent_complete":25,"session_id":"session_uwmiakztb","engagement_level":"briefly-sampled started explored"},
{"event_type":"video_progress","timestamp":"2025-12-24T00:10:53.271Z","user_id":"user_qaxw4dxdt","video_id":"k_vid_45678","user_video_id":"user_qaxw4dxdt-k_vid_45678","video_title":"Cornerstone S1E1","genre":"sci-fi, epic, drama","content_tags":"space-opera, grand-scale, philosophical, world-building, political-intrigue, ensemble-cast, futuristic, intellectual","themes":"destiny, civilization, power, prophecy, legacy, imperialism, human-progress, faith-vs-science","tone":"epic, cerebral, grandiose","pacing":"slow-burn, sprawling","emotional_beats":"awe-inspiring, contemplative, dramatic, ambitious, overwhelming","duration_seconds":1860,"watched_seconds":930,"percent_complete":50,"session_id":"session_uwmiakztb","engagement_level":"moderately-engaged partially-watched"},
{"event_type":"video_progress","timestamp":"2025-12-24T00:10:54.304Z","user_id":"user_qaxw4dxdt","video_id":"k_vid_45678","user_video_id":"user_qaxw4dxdt-k_vid_45678","video_title":"Cornerstone S1E1","genre":"sci-fi, epic, drama","content_tags":"space-opera, grand-scale, philosophical, world-building, political-intrigue, ensemble-cast, futuristic, intellectual","themes":"destiny, civilization, power, prophecy, legacy, imperialism, human-progress, faith-vs-science","tone":"epic, cerebral, grandiose","pacing":"slow-burn, sprawling","emotional_beats":"awe-inspiring, contemplative, dramatic, ambitious, overwhelming","duration_seconds":1860,"watched_seconds":1395,"percent_complete":75,"session_id":"session_uwmiakztb","engagement_level":"highly-engaged mostly-watched committed"},
{"event_type":"video_finished","timestamp":"2025-12-24T00:10:55.825Z","user_id":"user_qaxw4dxdt","video_id":"k_vid_45678","user_video_id":"user_qaxw4dxdt-k_vid_45678","video_title":"Cornerstone S1E1","genre":"sci-fi, epic, drama","content_tags":"space-opera, grand-scale, philosophical, world-building, political-intrigue, ensemble-cast, futuristic, intellectual","themes":"destiny, civilization, power, prophecy, legacy, imperialism, human-progress, faith-vs-science","tone":"epic, cerebral, grandiose","pacing":"slow-burn, sprawling","emotional_beats":"awe-inspiring, contemplative, dramatic, ambitious, overwhelming","duration_seconds":1860,"watched_seconds":1860,"percent_complete":100,"session_id":"session_uwmiakztb","engagement_level":"fully-engaged completed finished watched-entirely"},
{"event_type":"video_rated","timestamp":"2025-12-24T00:11:03.504Z","user_id":"user_qaxw4dxdt","video_id":"k_vid_45678","user_video_id":"user_qaxw4dxdt-k_vid_45678","video_title":"Cornerstone S1E1","genre":"sci-fi, epic, drama","content_tags":"space-opera, grand-scale, philosophical, world-building, political-intrigue, ensemble-cast, futuristic, intellectual","themes":"destiny, civilization, power, prophecy, legacy, imperialism, human-progress, faith-vs-science","tone":"epic, cerebral, grandiose","pacing":"slow-burn, sprawling","emotional_beats":"awe-inspiring, contemplative, dramatic, ambitious, overwhelming","duration_seconds":1860,"watched_seconds":1860,"percent_complete":100,"rating":5,"rating_sentiment":"loved excellent highly-recommend wonderful","rating_scale":5,"session_id":"session_uwmiakztb","engagement_level":"fully-engaged completed finished watched-entirely","review_text":"Very good"}
]
MCP with Claude
Using MCP to ask Claude about Pineapple TV viewers
Activate advanced, high-value agent workflows
Provide agents instant access to context-rich, searchable enterprise knowledge, enabling developers to launch advanced RAG workflows, automation, and agent runs while leveraging pre-built SaaS Data Connectors for seamless integration
