hypothesis / product-backlog

Where new feature ideas and current bugs for the Hypothesis product live
118 stars 7 forks source link

Cleanup outstanding user registrations #982

Open hmstepanek opened 5 years ago

hmstepanek commented 5 years ago

We currently have 26,014 user's with activation id's. Meaning they created an account but did not complete the confirmation process. 14,346 of these are more than a year old. I wonder if we should clean these up? Having a bunch of unused data can affect query times not to mention I think we have to pay for the space. Perhaps this could be a lambda job or something. Send them an email if they don't confirm within 30 days, at 60 days we delete their unconfirmed account.

seanh commented 5 years ago

Would it be possible to do this using a Celery periodic task? I'd prefer not to add Lambda to our stack, if we can avoid it

lyzadanger commented 5 years ago

I had a question about what the user experience would be for this if they do attempt to use an activation link for a registration that we delete. I presume we have sensible error handling for that, but it seems worthwhile to verify!

hmstepanek commented 5 years ago

^ Good question @lyzadanger. @seanh Yes that's fine too.