0

I need to design a website for music streaming. There will be a database of songs and the user can pick a song and listen to it. What database should I use and how should I store the songs on my server. I also need to have a very efficient search algo .
what database should I use ???

Thanks :)

3
Contributors
7
Replies
8
Views
6 Years
Discussion Span
Last Post by debasisdas
0

That depends on how much you can afford to spend on your server and database. Any standard database will that for you.

0

I need to design a website for music streaming. There will be a database of songs and the user can pick a song and listen to it. What database should I use and how should I store the songs on my server. I also need to have a very efficient search algo .
what database should I use ???

Thanks :)

I'm a fan of MySQL and have used it a fair bit. It's easily scaleable and normal SQL queries will give you the search facilities you need.

Best to simply store the songs within the server file system and record the file paths on the database.

What language(s) are you using for the site?

0

I am using php as my language . I too am a big fan of mysql . I just wanted to ask if I can use optimised search algos like hashing , indexing on it . If yes , please tell me how

0

how should I store my songs ... I have to work with atleast 10,000 songs. What format should I use?

0

you can use the following two methods.

1. Convert the songs file into binary format and store in DB (will consume a lot of space and retrieval will be slow)

2. Store the actual file in your desired format in file system in the and in the DB store the absolute / relative path of the file.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.