goauthentik / goauthentik/authentik
Add database indexes for `authentik_core_user.email`
Open
enhancement/confirmed
- Dominant language
- Python
- Stars
- 25.6k
- Forks
- 2k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 651
Description
Add database indexes for `authentik_core_user.email`, including case-insensitive lookups such as `UPPER(email::text)`.
Adding appropriate indexes would improve lookup performance and reduce unnecessary database load for deployments that use email as a primary user identifier.
Contributor guide
Research direction
Start by locating the model and migration that define authentik_core_user, then inspect the existing email lookup patterns, including the UPPER(email::text) expression named in the issue. Done means appropriate indexes support case-insensitive email lookups and the resulting queries reduce unnecessary database load.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- backend, databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 58/100