Hi

I am creating a online record store website at the moment using MySql and PHP. I have also developed a custom application for managing the database. In the application the user types in the usual data (price, stock artist etc) and can choose a picture for the album cover. The user can also record multiple track samples that are compressed into WMA format. My question is. Should the media (picture, WMA's) be stored as blobs in the database or should I implement a FTP client in the application to upload the media separately and store the names in the database. What are the advantages and disadvantages of storing media in a database? Any advice would be appreciated.

Thanks
John Cleary.

Hi!

IMHO the second way you described will be more preffered and faster(to store only path of media file on the server).