Description
Review src/db/client.ts for pool size, idle timeout, and SSL options for managed Postgres.
Requirements and context
- Document recommended settings per environment.
- Health check integration.
Suggested execution
Fork and branch
Fork the repo and create a branch:
git checkout -b chore/db-pool-tuning
Implement changes
- Update client configuration.
- Add tests in
src/db/client.test.ts.
Test and commit
Run tests, cover edge cases, and attach test output plus security or ops notes (auth, PII, Stellar keys) in the PR.
Run tests
Example commit message
chore(db): connection pool tuning and tests
Guidelines
-
Minimum 95% coverage on touched modules where applicable (npm test / coverage report).
-
Clear documentation (OpenAPI openapi.yaml, README, and inline comments for non-obvious logic).
-
Timeframe: 96 hours.
-
Run npm run build or tsc if types change.
-
Keep OpenAPI in sync with route behavior.
Description
Review
src/db/client.tsfor pool size, idle timeout, and SSL options for managed Postgres.Requirements and context
Suggested execution
Fork and branch
Fork the repo and create a branch:
Implement changes
src/db/client.test.ts.Test and commit
Run tests, cover edge cases, and attach test output plus security or ops notes (auth, PII, Stellar keys) in the PR.
Run tests
npm testExample commit message
Guidelines
Minimum 95% coverage on touched modules where applicable (
npm test/ coverage report).Clear documentation (OpenAPI
openapi.yaml, README, and inline comments for non-obvious logic).Timeframe: 96 hours.
Run
npm run buildortscif types change.Keep OpenAPI in sync with route behavior.