Jump to content

Uploading Photos To Mysql Or File


Redroest
 Share

Recommended Posts

Hey people, I am working on a photoalbum script for my phpnuke version. I can accomplish almost anything on it. Since I am not satisfied with the Gallery2 module I decided to make my own photoalbum. Since I don't have any experience in building a photoalbum I want to ask you people on how to work. I read that there are two ways to store files on a server. -The first one is by making a binary version of the photo and than store it into a mysql database. -The second one is to just store the files on the server and storing the metadata in a mysql database wich can be retrieved trough a unique url or photoname.Here's my question. What version is the best one considering: speed, serverspace, security, large files, small files, number of pictures etc??Thanks in advance

Edited by Redroest
Link to comment
Share on other sites

Speed: FSSpace: DB, but sometimes hosts have additional restrictions on DB space.Security: DB, if you mean unauthorized access of the photos.Large files: FSSmall files: DBThe main reason you would store the photos in the DB, IMO, is because of portability - if you moved hosts in the future, you only have to move the DB, instead of having to also try to recreate your old filesystem on the new server, which can be irritating especially depending on what sort of backups you have.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...