Image Optimization, Rebuilding Image Checksum & Size

[LEckley]

Hi Guys,

I am looking to utilize jpegoptim and optipng to optimize images uploaded to my Chevereto website, however before I implement either I would like to have a solution in place to update the database entries for each image (checksum, size, etc.) to ensure all data stored in the DB is correct.

The idea would be to run jpegoptim and optipng on a daily cron and after they complete run another script to update the Chevereto database with the new data.

Any ideas?

 

[Rodolfo]

You need to create a cron and call it each day to a given PHP file or a simple wget to the target script URL.

You will need to update image_md5 and image_size, you could add an auxiliar table to keep a record of which rows you have already optimized.

 

[LEckley]

You need to create a cron and call it each day to a given PHP file or a simple wget to the target script URL.

You will need to update image_md5 and image_size, you could add an auxiliar table to keep a record of which rows you have already optimized.

Would this be something you would consider adding to Chevereto or should I look to hire someone (maybe even you?) to build the script?

The crons I can do no issue, but the scripting and DB work are outside my abilities as a sysadmin

 

[Rodolfo]

I've plans to add optimizations, my original idea was to dedicate 3.8 for optimizations, however, maybe I will push money making features to 3.8 and optimizations for 3.9... Anyway, I will add several optimizations in the future.