git/slrpg
1
0
Code Issues Projects 1 Packages Wiki Activity Actions

feat(backend): SQL-Migrationen für Global Leaderboard #7

New issue
Closed
opened 2026-02-17 14:56:12 +01:00 by git · 0 comments
git commented 2026-02-17 14:56:12 +01:00
Owner
Copy link

Erstellung performanter SQL-Views im Backend, um Ranglisten basierend auf Level, XP oder Total Strength bereitzustellen.

Technische Details:

  • Erstellung von Indizes für schnelle Sortierung.
  • API-Endpunkt /api/leaderboard bereitstellen.

Akzeptanzkriterien:

  • SQL Migration für Leaderboard-View (Aggregation der User-Stats).
  • API-Endpoints liefern korrekt sortierte JSON-Daten.
  • Performance-Check bei vielen Usern.
Erstellung performanter SQL-Views im Backend, um Ranglisten basierend auf Level, XP oder Total Strength bereitzustellen. Technische Details: - Erstellung von Indizes für schnelle Sortierung. - API-Endpunkt /api/leaderboard bereitstellen. Akzeptanzkriterien: - [x] SQL Migration für Leaderboard-View (Aggregation der User-Stats). - [x] API-Endpoints liefern korrekt sortierte JSON-Daten. - [x] Performance-Check bei vielen Usern.
git added this to the Milestone: Phase 3: Social & Advanced Features milestone 2026-02-17 14:56:12 +01:00
git added this to the slrpg project 2026-02-17 14:56:12 +01:00
git closed this issue 2026-02-17 15:09:13 +01:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
No results found.
No results found.
Labels
Clear labels   
backend

   
bug

Something is not working

  
database

   
duplicate

This issue or pull request already exists

  
enhancement

New feature

  
feature

   
frontend

   
help wanted

Need some help

  
invalid

Something is wrong

  
localization

   
question

More information is needed

  
refactor

   
security

   
ui/ux

   
wontfix

This won't be fixed

No labels
backend
bug
database
duplicate
enhancement
feature
frontend
help wanted
invalid
localization
question
refactor
security
ui/ux
wontfix
Projects
Clear projects
No items
No project
slrpg
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: git/slrpg#7
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?