I'm considering an audit trail for both visibility (seeing that it is working) and security (seeing who triggered which posts to be edited).
This would be in the form of a database table that simply logs:
- postId of post edited
- userId of registered user that triggered the edit
- timestamp of when the edit occured
I wouldn't provide a front-end, just the logging.
This would allow you to create your own queries to determine:
- from the postId, you could see who posts the most large images
- from the userId, you might detect any possible abuses where a registered user might make an AJAX app that emulates this script
- from the timeStamp, you could create a chart showing when most edits occured. over time this should hopefully show that the problem of large images is for the most part eradicated, and then managed going forward
If there is interest from others in an audit log like this, please let me know and I'll add it
It would be a SQL change (new table), but beyond that nothing out of the ordinary.