dazamarquez

Hi HN, I'm searching how to build a system to daily digest emails, on top of an existing legacy database / application.

Does it make sense to send daily digests to every user of your app every day? I think that iterate through each user will be very computation expensive.

Then if you need to aggregate some data (maybe with SQL JOIN) or other business logic, in order to build the email content, and you keep doing that for each user, your resource usage will be so high.

Beside then there's more issues: e.g. users may live all over the world and not have the same timezone, so the time of "daily" digest can't be the same for everyone.

Do you have a strategy for this daily digest? Is there some learning resources you could point to?

Muito Obrigado!