How to Build Music streaming backend with V0

1// Paste this prompt into V0's AI chat:
2// Build a music streaming backend. Create a Supabase schema:
3// 1. artists: id (uuid PK), user_id (uuid FK to auth.users), name (text), bio (text), image_url (text)
4// 2. albums: id (uuid PK), artist_id (uuid FK to artists), title (text), cover_url (text), release_date (date)
5// 3. tracks: id (uuid PK), album_id (uuid FK to albums), artist_id (uuid FK to artists), title (text), duration_seconds (int), file_url (text), file_size_bytes (bigint), genre (text), play_count (int DEFAULT 0)
6// 4. playlists: id (uuid PK), user_id (uuid FK to auth.users), name (text), description (text), is_public (boolean DEFAULT true), created_at (timestamptz)
7// 5. playlist_tracks: playlist_id (uuid FK to playlists), track_id (uuid FK to tracks), position (int), added_at (timestamptz), PRIMARY KEY (playlist_id, track_id)
8// 6. play_history: id (uuid PK), user_id (uuid FK to auth.users), track_id (uuid FK to tracks), played_at (timestamptz), duration_listened (int)
9// Add RLS policies. Also create a private Storage bucket called 'audio' with 100MB file size limit.

1import { createClient } from '@supabase/supabase-js'
2import { NextRequest, NextResponse } from 'next/server'
3
4const supabase = createClient(
5  process.env.SUPABASE_URL!,
6  process.env.SUPABASE_SERVICE_ROLE_KEY!
7)
8
9export async function GET(
10  req: NextRequest,
11  { params }: { params: Promise<{ trackId: string }> }
12) {
13  const { trackId } = await params
14
15  const { data: track } = await supabase
16    .from('tracks')
17    .select('file_url, title')
18    .eq('id', trackId)
19    .single()
20
21  if (!track?.file_url) {
22    return NextResponse.json({ error: 'Track not found' }, { status: 404 })
23  }
24
25  const { data: signedUrl } = await supabase.storage
26    .from('audio')
27    .createSignedUrl(track.file_url, 3600)
28
29  if (!signedUrl) {
30    return NextResponse.json({ error: 'Failed to generate URL' }, { status: 500 })
31  }
32
33  return NextResponse.redirect(signedUrl.signedUrl, {
34    headers: {
35      'Cache-Control': 'public, max-age=3600',
36      'Accept-Ranges': 'bytes',
37    },
38  })
39}

1// Paste this prompt into V0's AI chat:
2// Create music streaming pages:
3// 1. app/page.tsx — featured playlists Card grid + trending tracks Table (title, artist, album, duration, play_count, play Button)
4// 2. app/library/page.tsx — user's playlists grid + recently played history Table
5// 3. app/playlist/[id]/page.tsx — tracklist Table with position, title, artist, duration. Add inline play Button per track. Show playlist cover, name, description, track count.
6// 4. Add a persistent audio player bar at the bottom: track title + artist, Slider for scrubber, volume Slider, play/pause/skip Buttons, Sheet for now-playing queue
7// Use shadcn/ui Card for albums, Table for tracklists, Slider for audio controls, DropdownMenu for track options (add to playlist, share), Sheet for queue.

1import { createClient } from '@supabase/supabase-js'
2import { NextRequest, NextResponse } from 'next/server'
3
4const supabase = createClient(
5  process.env.SUPABASE_URL!,
6  process.env.SUPABASE_SERVICE_ROLE_KEY!
7)
8
9export async function POST(req: NextRequest) {
10  const { track_id, user_id, duration_listened } = await req.json()
11
12  if (!track_id) {
13    return NextResponse.json({ error: 'Missing track_id' }, { status: 400 })
14  }
15
16  await supabase.rpc('increment_play_count', { p_track_id: track_id })
17
18  if (user_id) {
19    await supabase.from('play_history').insert({
20      user_id,
21      track_id,
22      played_at: new Date().toISOString(),
23      duration_listened: duration_listened || 0,
24    })
25  }
26
27  return NextResponse.json({ success: true })
28}

1// Paste this prompt into V0's AI chat:
2// Add playlist management:
3// 1. Server Action createPlaylist: insert playlist with name, description, is_public
4// 2. Server Action addTrackToPlaylist: insert into playlist_tracks with max position + 1
5// 3. Server Action removeTrackFromPlaylist: delete from playlist_tracks and reorder positions
6// 4. Server Action reorderTrack: update position values for drag-and-drop reordering
7// 5. 'New Playlist' Dialog on library page: name Input, description Textarea, public Switch
8// 6. On track DropdownMenu, add 'Add to Playlist' option that opens a Dialog listing user's playlists with add Buttons
9// 7. On playlist page, add DropdownMenu per track: Remove from playlist, Move up, Move down
10// Also create the Supabase RPC function: increment_play_count that does UPDATE tracks SET play_count = play_count + 1 WHERE id = p_track_id