Page 1 of 1

storing and retrieving wav files + mysql

Posted: Sat Jan 02, 2010 7:01 pm
by droid17
Hi all :)

I am new to php, but have been programming (mostly Java) for the last 10 yrs. I just setup a site on go daddy, which doesn't have java server side support and now trying to pick up php.

What I want to be able to do is store and retrieve wav files. I guess I am looking to get pointed in the right direction. Is it better to store the wav in mysql or to store an id and store the file local? Can I even do this on a non dedicated go daddy server? Any thoughts to get me going would be great!

Thanks,

droid

Re: storing and retrieving wav files + mysql

Posted: Sun Jan 03, 2010 2:49 am
by cpetercarter
The advantage of keeping wav files in the database is that they can only be accessed using the database user-name and password. But if you want users to be able to download the iles, this may not be important. The big disadvantage is that the files will use up a large amount of memory within the db. If the web host limits the size (MB) of database which you can have, it may be best to store the files in a separate folder, and keep only the file names and other relevant details in the database. This is what most podcasters etc do.

Re: storing and retrieving wav files + mysql

Posted: Sun Jan 03, 2010 10:05 am
by droid17
Thanks cpetercarter,

Is it common on shared hosting plans (like go daddy) that they allow you to have client users upload files?

Thanks,

droid