1

I am setting up a website that will have users. Users can search for songs and (if signed in) save them to a playlist or their library of songs.

I want it to be like iTunes in that all the songs on the the playlists are part of the library so when the user choses to view their library of songs, the songs on the playlists are shown as well as the songs just added to the library. I'd like a song to be able to be stored in multiple playlists.

Right now I am using Mongodb, doing something like such:

var UserSchema = new Schema();

var Library = new Schema({
    songs: [SongsSchema],
    user: Schema.ObjectId
});

var Playlist = new Schema({
title: String,
description: String,
user: Schema.ObjectId   
});

var SongsSchema = new Schema({
position: Number,
name: String,
artist: String,
    artistGid: String,
album: String,
    albumGid: String
time: Number,
url: String,
    gid: String,
    location: String (either youtube, vimeo, soundcloud for now),
    playlist: [Schema.ObjectId] (array of object ids that point to playlists?)
});

Does this seem the best? I am used to relational so it seems like there is lots of duplication but I was having a hard time normalizing it in a way that would work.

Community
  • 1
  • 1
Jonovono
  • 3,437
  • 5
  • 42
  • 64

2 Answers2

2

Looks reasonable to me. Though in this design you can't support ordered playlists. I would include both an ObjectId for the playlist and the position in the playlist in the playlist array if you want to support that feature.

Kareem
  • 844
  • 2
  • 8
  • 15
  • ah true that is needed. How would that look in mongoose? playlist: [Schema.ObjectId, Integer] ? – Jonovono Jan 13 '12 at 19:46
  • Never used Mongoose, but I think you're looking for Embedded Documents: http://mongoosejs.com/docs/embedded-documents.html Maybe a PlaylistEntry Schema you embed in playlist. – Kareem Jan 13 '12 at 20:43
1

welcome to Mongo!

That sounds good, just make sure you have an index on songs.playlist

db.collection.ensureIndex({"songs.playlist": 1})

Might make sense to make libraries / playlists the same thing, just have the title of the library object be "Library"

Tyler Brock
  • 29,626
  • 15
  • 79
  • 79
  • hmm. So like have the playlist model contain a embedded doc of the songs. And have one to store the songs added to the library. Then when showing the library just display all the songs from the library 'playlist' as well as all the songs from the users playlists, but get rid of duplicates. That seems to be the best way right now – Jonovono Jan 14 '12 at 22:05