backdrop-contrib / githubapi

GitHub API integration module
GNU General Public License v2.0
0 stars 3 forks source link

githubapi_payload is never emptied #19

Closed quicksketch closed 4 years ago

quicksketch commented 5 years ago

We were making a database dump of backdropcms.org and found that the githubapi_payload table was nearly 4GB. It appears as though we're never cleaning up old entries. We should add a cron job that simply deletes old payloads after some amount of time.

I couldn't find any place where these payloads are actually even being accessed, seems like this might be a "just in case" record of these payloads? A generous expiration time might do the job, e.g. 30 days.

quicksketch commented 4 years ago

Really basic cron clean-up implemented in https://github.com/backdrop-contrib/githubapi/pull/23. No UI, but at least there's an option and (most importantly) we clean up the entries instead of letting them pile up forever.