create searchable database for audio files

Hi There,

I have a lot of mp3 files and I want to post them on site, but I want them to be searchable
for users, like by song name, auther name and so further, I thought of doing it with SQL server
because I have SQL server already, I need someone tell me how I tell SQL where is the audio files reside
asamuelAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NazermohideeenCommented:
 SQl server is not a MP3 player. It is a database. So with the database, you specify data. what ever you give, it stores. And with the stored information you can query them and sort according to your wish.

So you have type the audio information, and file name. May be you can use dos scripts to get the file names. But the autor information, I think you have to type manually once.
0
Luan JubicaProject ManagerCommented:
you want to store the songs on your database, or store just the links to the mp3 files?
0
asamuelAuthor Commented:
sound good,
So how do I store the file in the database, like for example file on the c:\audio\song1.mp3
how do I store this file in the database or link it
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

NazermohideeenCommented:
You can store the actual song inside the database. But i believe that each song should be atleast 4 MB. Also to play the song, it is not going to be a easy task.
So the best Idea is to link the file path in the database.

so you the actual song will stay in the same location, but you would store "c:\audio\song1.mp3" as a string in your database.

0
asamuelAuthor Commented:
What you are saying now that may be will have field called location, and put the path for each song
and this way will be able to create the searchable database
0
NazermohideeenCommented:
yes that is correct. But I think it will not be a good idea to search using the filenames. Use the filenames to link, but specify another field which is more user friendly and then u can create Queries and user interface to execute those queries to do your sorting / searching
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.