How to Store and take audio file from database?

Discussion in 'Databases' started by heeromai, Nov 15, 2007.

  1. #1
    Hello how to store and take audio file from databse?? and which database software are suitable for doing this kind of job??
     
    heeromai, Nov 15, 2007 IP
  2. N_F_S

    N_F_S Active Member

    Messages:
    2,475
    Likes Received:
    56
    Best Answers:
    0
    Trophy Points:
    90
    #2
    Why do you need to make your life harder? Store the location of audio file in db. Any thoughts on why do you need this?
     
    N_F_S, Nov 15, 2007 IP
  3. msaqibansari

    msaqibansari Peon

    Messages:
    84
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Do you really want to store audio files in DB. :eek: strange.

    Why don't you use DB for music file location repository and direct access music file by FLASH or Server side language.
     
    msaqibansari, Nov 15, 2007 IP
  4. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    While is is technically possible it just isn't practical to do this. You can't use standard SQL to store/retrieve your audio files and the database will grow in size so quickly that backup/recovery will become a real problem.

    Just store audio catalogue information in your database with a link to the location of the audio file. Even better, store a symbolic link to the file so you can change the actual location without disturbing the database.

    Petey
     
    Petey, Nov 16, 2007 IP