iEntry 10th Anniversary Webforumz RegistrationAnnouncements Contact Webforumz StaffContact
Home Resources Blogs Meet the Team Contact Register
 

Go Back   WebForumz.com > Putting it Together > Databases

Reply
 
LinkBack Thread Tools
Old July 12th, 2008, 06:30 PM   #1
New Member
 

Join Date: Jun 2008
Location: Madison, WI
Age: 23
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 soulkarver is on a distinguished road
music files and mysql database design

Hey everyone,
I'm new to this site, so sorry for any n00b mistakes. I'm building a website for rock music where each rock band will be represented by an id, each album will be represented by an id, and each song represented by an id (all of these will be in a mysql v5 database). Users will be able to register for the site and add bands, songs, and albums and maybe music files (although originally I will be the only one uploading music files to the site--making sure i have each band's consent). I'm planning on having each unique song have data in the database independent of whether a music file exists on the site for that song (each version of a song will have a unique id -- different id for demos, final masters, live recordings, acoustic recordings, remasters, remixes, and other edits). The music will mostly be used just for streaming to the users. I have thought up this as a way to handle the music files:
just have a folder called songs/ on the site where i have the individual mp3 files each named with the id of the song in the database. for example, if song "Killing It" has id 345, i would name the file 345.mp3.

My question is: is this a good way to do things? What are the advantages and disadvantages of doing things this way? Can you suggest any better ways of handling the mp3 files?

Thanks guys!

Last edited by soulkarver; July 12th, 2008 at 06:37 PM..
soulkarver is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Bookmarks

Tags
database , design , files , mp3 , music , mysql


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Music Database design help! browno Databases 10 December 30th, 2008 01:13 AM
uploading multiple files path in the database franknu PHP 4 January 23rd, 2007 12:37 PM
bootleg music database - help with structure of db rustenrat Databases 4 June 22nd, 2006 06:29 AM
mysql database ezagents Databases 4 June 2nd, 2006 03:32 PM
Limiting Users Files in a Database... JohnMitch Classic ASP 3 May 13th, 2005 12:30 PM


Search Engine Optimization by vBSEO 3.2.0 RC8