Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New Coder
    Join Date
    Dec 2013
    Location
    Were my backpack is!
    Posts
    20
    Thanks
    3
    Thanked 0 Times in 0 Posts

    best way to store large amounts of photos and files

    Hi. I am been racking my brain over this for the last week; I am a junior web programmer and I have been asked to find the best way to store large amounts of photos and files. I was asked to store them in a mySQL database, but as I suspected my research found that although possible this would cause query speed problems and that it was best to just store the link location and the meta data. My problem is, were the heck should I store the actual files and how do I maintain synchronization between them and the database. I considered using a file sharing service (pay cloud) to store the files because they seem to sell storage much cheaper then database services, but the problem is that if I do that I cannot create a front end for employees to add files, and I can't write scripts to link the data together, because I do not have back end access to the files sharing service (am I the only one who laughs when someone says back end access?).

    I did notice that hostings seem to claim that they although they have only 2gb database limits, they have unlimited file storage, but I highly doubt that is true, or else I could just store all the files with my hosting and store the links and meta data in my database, and create front ends to my hearts desire.

    If anyone has any ideas it would be greatly appreciated. If my question needs clarification do not hesitate to say so, I am happy to reiterate it. Just to clarify this is for a started magazine company but it will grow, and the industry is very file and picture heavy.
    Thanks a bunch,
    -Adrian

  • #2
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    105
    Thanks
    0
    Thanked 10 Times in 10 Posts
    Did you look at DropBox? Perhaps that could suit your needs?

    And if you had to use MySQL, you would store the files in the file system. Setup some kind of directory structure for where which file should go. If files are deleted then the references to it in the database should go as well.

  • #3
    New Coder
    Join Date
    Dec 2013
    Location
    Were my backpack is!
    Posts
    20
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks for the reply.

    Can I do that with TB's of files? Just store them in my file directory, and when I reach my host limit just upgrade?

    I thought dropbox was free and assumed it would not have enough storage or be secure enough.

  • #4
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    105
    Thanks
    0
    Thanked 10 Times in 10 Posts
    As long as you have enough space, sure. Although I think some people host their content across seperate servers and load balance them somehow.


    And DropBox does have a business line which could suit your needs.
    www.dropbox.com/business/pricing

  • #5
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    105
    Thanks
    0
    Thanked 10 Times in 10 Posts
    As long as you have enough space, sure. Although I think some people host their content across seperate servers and load balance them somehow.


    And DropBox does have a business line which could suit your needs.
    www.dropbox.com/business/pricing

  • #6
    Regular Coder Linux_Sage's Avatar
    Join Date
    Mar 2014
    Location
    Sterling,VA
    Posts
    105
    Thanks
    0
    Thanked 10 Times in 10 Posts
    Huh... whoops. The server lagged a bit when I tried to post and now there's two. I can't delete it.


  •  

    Posting Permissions

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