Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


create searchable database for audio files

Posted on 2006-03-21
Medium Priority
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
  • 3
  • 2

Expert Comment

ID: 16247458
 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.

Expert Comment

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

Author Comment

ID: 16247808
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 16248919
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

ID: 16249271
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

Accepted Solution

Nazermohideeen earned 750 total points
ID: 16253767
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

572 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