Anyone have any experience building/using an MP3 database? I thought I'd ask before wasting too much time on it. I have 23,000 songs I'm putting in a db. Right now I have a Web-based CF app to search the collection, and I'd like to be able to build playlists from it. Eventually I'd like to build a stand-alone app using VB.net once I get it all sorted out. Here's the DB schema I have right now:
SubDirectories (Letter A-Z) subdir_id subdir Artists artists_id subdir_id artist Album album_id artist_id album MP3 mp3_id album_id artist_id subdir_id Year [File] Type Encoding Extra Frequency BitRate BitRateMin BitRateMax Channels Tracks Original Copyright Title Artist Album Genre Seconds FileSize Comments Source Lyrics Country Language ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists