We are a small MSP using PHP. Photos our users currently upload are stored on-server (the process managed by standard PHP methods) and their meta info is inserted (or updated) to the database. A background task makes various thumbnail sizes, copies them to an s3 bucket and updates the database of their s3 availability there. Our system has become bloated by multi-megabyte, uncropped pictures. We need to:
-Enable users to crop as part of the upload process
-Downscale and compress for better storage efficiency
-Notify users of most wasteful pictures already uploaded and give them the tools to crop, rotate and compress.
-Automated scan the photo database to auto-compress (and maybe auto-crop) the old photos.
I am guessing this is a common migration path to your system. Is there a step-by-step dealing with this?