twendy1
twendy13w ago

Best practice for cleaning old events

Hi, I have a table which saves webhook IDs in order to validate if we already processed the event or not. Is there any best practice in order to clean this data? I assume we dont need all those events on the next day (or even sooner).
6 Replies
Convex Bot
Convex Bot3w ago
Thanks for posting in <#1088161997662724167>. Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets. - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.) - Use search.convex.dev to search Docs, Stack, and Discord all at once. - Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI. - Avoid tagging staff unless specifically instructed. Thank you!
erquhart
erquhart3w ago
You would typically set up a cron to delete the old events: https://docs.convex.dev/scheduling/cron-jobs
Cron Jobs | Convex Developer Hub
Convex allows you to schedule functions to run on a recurring basis. For
twendy1
twendy1OP3w ago
But we wouldnt be able to delete everything in one run, would we need to use paginated queries?
erquhart
erquhart3w ago
Right, probably have the cron be a mutation that accepts pagination opts and schedules itself if there's more pages.
twendy1
twendy1OP3w ago
I see. I think for now we just gonna remove everything manually because dashboard has Select All button.
erquhart
erquhart3w ago
yeah if that works for you it's a handy option

Did you find this page helpful?