Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
I'm being encouraged to offer image-hosting for members of my site.

I can not find any existing software to fulfill my needs. The only image-hosting applications I've found are those geared toward offering simple galleries in which limitations are only tracked and imposed when access is made directly through the application's interface.

Required Features:
  • Upload, rename, delete, view and categorize images.
  • Create account levels, allowing limitations on number of images, maximum size of images, maximum size of all combined images, number of views per image and combined views.
  • Track and impose the above limits.

    I've only devised two solutions.

    The first is to use ModRewrite and when a key path exists in the URL, kick off a script to update an SQL database to count the hit and calculate the bandwidth usage. If any limits are exceeded, the image is not displayed and access is denied. The downside is that ModRewrite, an SQL UPDATE/INSERT and an SQL SELECT for every image serged is a massive amount of overhead.

    The second solution is to have a small script that parses the Apache log files on a regular basis (hourly?) and updates the database to calculate various usage stats. When limits have been exceeded, the script would back the original image up and replace it with a very small (few bytes) PNG containing an error message.

    If anyone has input on this - or even better, happens to know of an existing application that I somehow could not find - please inform me!

    In reply to Image Hosting Application by Seumas

    Use:  <p> text here (a paragraph) </p>
    and:  <code> code here </code>
    to format your post; it's "PerlMonks-approved HTML":

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and all is quiet...

    How do I use this? | Other CB clients
    Other Users?
    Others imbibing at the Monastery: (3)
    As of 2018-05-26 11:02 GMT
    Find Nodes?
      Voting Booth?