create searchable database for audio files

Posted on 2006-03-21
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
Question by:asamuel
    LVL 4

    Expert Comment

     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.
    LVL 7

    Expert Comment

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

    Author Comment

    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
    LVL 4

    Expert Comment

    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 Comment

    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
    LVL 4

    Accepted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how the fundamental information of how to create a table.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now