We help IT Professionals succeed at work.

create searchable database for audio files

asamuel
asamuel asked
on
Medium Priority
1,106 Views
Last Modified: 2008-01-09
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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
 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.
Luan JubicaProject Manager

Commented:
you want to store the songs on your database, or store just the links to the mp3 files?

Author

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
CERTIFIED EXPERT

Commented:
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.

Author

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
CERTIFIED EXPERT
Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.