Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18

    Unanswered: reg: music file upload into db

    am looking for a process to upload music files into Mysql database.. this is just an interest... i don't want to give file path in the database, trying to put complete file.

    Please through your view on this.....

    thanks for reply....

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    in short don't do it
    like storing images there are two schools of though, some advocate storing the image, or some in the db, some advocate storing the path to the resource.

    personally I'm a believer in storing the path tot he resource rather than the actual resource in the db.
    why
    ..stops db bloat
    ..reduce time take for backup & restores
    ..reduces costs involved in the db
    ..reduces the load on the db server
    ..allows resources to be located / stored wherever required or wherever available.
    ..allows you to point to resources outside your own control, reduces the bandwidth costs if its stored elsewhere.

    but then again i'm a jaded developer who deep down inside doesn't like relying entirely on netwrok trolls to do the backup and be in a position to restore the db after the event
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18
    hello healdem,

    thanks for reply, i understand the problem when i go with complet file storage in db.... but am curiosity about how to implement.... can i take datatype as String to store... ( this is just for understanding... not for implementation)
    Last edited by sree1030; 06-29-09 at 08:42.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I would expect to use the blob datatype for this sort of application
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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