Configuration and Pre-work for GSPC Email Enhancement

[JennaySDavis]

Tech Task:

• Complete pre-work for the GSPC Email enhancement.

[felder101]

Reached out to the service and delivery team regarding possible approved tools that could be utilize to help with resolving our email processing. Per discussion possible solutions are the following.

• Using Postgres triggers to send email when record has been added to the database. There is no current known working example within GSA and there might be limitations with application database being hosted on cloud.gov.
• Create an small application that will run independently of the training application to process queued emails from the database. This will increase the scope of the approved ATO as another application is added with this solution. This solution significantly increase effort compared to other solutions.
• Utilize FastAPI background task to send emails in the background. This utilize existing framework and will not require a lot of code changes, however there are updates that need to be made to the database with this change.

Based on the research I believe utilizing the FastAPI background task will resolve our limitation with sending emails and and will require the least amount of code changes compared to the other solutions mentioned.