E-mail integration

[davideastmond]

Feature Description Stretch goal

• Integrate an e-mail notification system
• Verify user's e-mail
• Notify user when application has been approved / rejected
• Notify admin when a new application comes in

Major User Stories/tasks

• [ ] User Story or Task #1
• [ ] User Story or Task #2
• [ ] Additional User Stories or Tasks as necessary

Additional Considerations Include anything else that may be helpful. For example, links to external resources.

[Alfrederson]

E-mail verification goes like this:

• generate a random string
• assign it to the user
• send an e-mail to the provided address with a link like www.loanapp.com/verify/(random string)

When a get request is made to /verfy/:verificationstring , then the backend will search for that verificationstring parameter and change a "activated" field within the user record to true.

The user needs to have an option to resend a verification link, which does all those 3 steps again unless the user is already activated.

In PostgreSQL it's ideal to create an index for the "Users" table based on the verification string, which makes identifying the user really fast.

Since all of this involves database operations ($$), it's ideal to use some type of rate limitting on the backend. I don't know if the ideal is to use some library like express-rate-limit or if this would be a service provided by Cloudflare or whichever load balancer would be in place.

So, question is:

How does one create indices for fields in MongoDB?