storing and retrieving wav files + mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
droid17
Forum Newbie
Posts: 3
Joined: Sat Jan 02, 2010 6:52 pm

storing and retrieving wav files + mysql

Post 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
cpetercarter
Forum Contributor
Posts: 474
Joined: Sat Jul 25, 2009 2:00 am

Re: storing and retrieving wav files + mysql

Post 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.
droid17
Forum Newbie
Posts: 3
Joined: Sat Jan 02, 2010 6:52 pm

Re: storing and retrieving wav files + mysql

Post 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
Post Reply