Solution Strategy#

The following table contrasts the quality goals of SQL-Train (Section 1.2) with matching architecture approaches and thus provides easy access to the solution.

Quality Goal

Matching approaches in the solution

Didactic Value

Beta version to receive feedback

User-friendly UI

  • Figma wireframes & prototypes

  • Beta version to receive feedback from students

Quick Responses

  • PostgreSQL Connection Pool

  • nginx to serve static files

  • Lighthouse report

Easy Login

Use of LTI with LMS and host trust with pg-stud

Internationalization

i18next, Django i18n and modeltranslations

Straightforward Deployment

Docker configured through environment variables

Security

Assessment via a separate report

Maintainability

  • Code review

  • Linters

  • Documentation

Accessibility

Lighthouse report