BE-24: Add pagination to game history and tournament list endpoints

[chinweobtagaz]

Context: Fetching the game list returns the entire database table, which will crash the server and client at scale.
Location: backend/modules/api/src/games.rs
Acceptance Criteria:

• Implement limit/offset pagination and return metadata (total_count, next_page).

[GdAyo19]

@GdAyo19 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Abeg give me this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @GdAyo19 to this issue.

[Danielobito009]

@Danielobito009 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

I would love to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Danielobito009 to this issue.

[SpacePanda7077]

@SpacePanda7077 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi maintainer, I’ll be happy to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @SpacePanda7077 to this issue.

[roycebtx]

@roycebtx has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hello Maintainer, I've taken the time to understand the issue and its expected outcome. I'm confident I can deliver a reliable implementation with a clean pull request. I'd appreciate the opportunity to work on it.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @roycebtx to this issue.

[Cashman-Exchange]

@Cashman-Exchange has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hello! I’d love to work on this issue. I have experience implementing efficient pagination for API endpoints and optimizing data retrieval. I can add pagination to the game history and tournament list endpoints while ensuring consistent responses, good performance, and compatibility with the existing API design.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Cashman-Exchange to this issue.

[vincentchimene]

@vincentchimene has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi! I’d like to contribute to #872 – Add pagination to game history and tournament list endpoints. I’m interested in improving backend scalability and ensuring APIs remain reliable as application data grows.

I can update the game and tournament listing endpoints to support limit/offset pagination, prevent full-table fetches, and return structured pagination metadata including total_count and next_page. I’ll ensure the implementation handles edge cases gracefully, follows existing Rust backend patterns, and includes tests covering pagination logic, response consistency, and large dataset scenarios.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @vincentchimene to this issue.

[mercy60]

@mercy60 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi. Can I be assigned to this please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @mercy60 to this issue.

[drips-wave]

Congratulations, @mercy60! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @mercy60: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊