[backend][ops] No graceful DB pool sizing / env-driven configuration

[Xhristin3]

Severity

Medium

Files

app/backend/src/main.ts, DatabaseModule (or equivalent)

Description

DB pool size, idle timeout, max lifetime, statement timeout are not exposed via env. Staging and production must run with the same defaults, causing cold-start failures under load.

Acceptance Criteria

• Wire DATABASE_POOL_MIN/MAX, IDLE_TIMEOUT_MS, STATEMENT_TIMEOUT_MS, MAX_LIFETIME_MS via ConfigService
• Document defaults in docs/ops-tuning.md
• Add a load-test assertion that pool saturation yields 503 (not 500)

[YfengJ]

Hi maintainers, I would like to apply for this issue if it is available.

If assigned, I would keep the change scoped to backend DB configuration: wire DATABASE_POOL_MIN/MAX, IDLE_TIMEOUT_MS, STATEMENT_TIMEOUT_MS, and MAX_LIFETIME_MS through ConfigService into the DatabaseModule or existing connection factory; document the defaults in docs/ops-tuning.md; and add a focused saturation/load-style test proving pool exhaustion returns 503 rather than leaking a 500.

I will wait for assignment or explicit maintainer/GrantFox confirmation before cloning, implementing, or opening a PR.

[Menjay7]

Hi! I came across this issue and would love to work on it. I have experience with similar tasks and I'm confident I can investigate, implement a clean solution, and thoroughly test it before submitting a PR. If the issue is still open, I would appreciate it if you could assign it to me. Thank you!

[clintjeff2]

Hello, I have 6 years of experience working on tasks like this and handling similar challenges across backend, frontend, and smart-contract development. I have carefully read and fully understood the task requirements, and I am confident I can deliver a clean, efficient, and well-tested solution promptly. I always ensure high-quality implementation, maintainability, and adherence to best practices.

Pull request in 5 hours.

[snowrugar-beep]

can I take this?

[grantfox-oss]

🦊 GrantFox — @snowrugar-beep has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #526)
2. Your PR will be reviewed by the Gatheraa maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign campaign!

@snowrugar-beep's PR #583 was approved and merged by @Xhristin3.

🏆 @snowrugar-beep: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (541 total points). Track your full progress on GrantFox.

👏 Great work, @snowrugar-beep! Keep contributing to Gatheraa.