Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: Storing media in MySql

    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.

  2. #2
    Join Date
    Oct 2003
    Posts
    63
    Hi!

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •