Broken IDs: Find and Eliminate
Because of some situations and not creating cascading deletes, I've got some IDs littered throughout my database that are no longer pointing to a real row.
In the dashboard it is clear because the link is broken, but I'm hoping to find a way to efficiently get rid of those. Is there an article or helper that has been created that can help me eliminate those? Surely I'm not the only one who has run into this.
3 Replies
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!
You would write a migration for this, which could use the migrations component to avoid boilerplate. Loop through each record, check the id, delete if it doesn't exist.