Database Connection Pooling and Timeouts

[Baskarayelu]

Description:

Configure connection pooling and timeouts for the database client to avoid exhausting connections and long hangs.

Requirements

• Set pool size (e.g. min 1, max 10 for serverless; adjust for Node server)
• Set connection timeout and query timeout (e.g. 5s) in Prisma or DB client
• Health check uses a simple query and fails fast if timeout
• Document pool and timeout settings in README
• If using serverless (Vercel): follow Prisma/serverless best practices (connection limit, warm-up)

Acceptance Criteria

• Pool and timeouts configured
• Health reflects DB availability
• Documented

[gelluisaac]

I’m interested in tackling this! I have a strong background in smart contract development and full-stack systems, so I'm well-equipped to handle the requirements here. Could you please assign this to me?

[drips-wave]

This issue has been added to the Stellar Wave Program and is worth 200 Points.

🧑‍💻 Interested in contributing? Apply to work on this issue on Drips Wave, earn points, and receive rewards.

Warning

Only applications submitted via the apply link above will be considered. Please do not apply by commenting on the issue or opening a PR directly.

🤠 Repo maintainers: You can manage this issue's Points and Complexity on your Maintainer Dashboard here. Please keep an eye on applications and respond quickly 💙

ℹ️ Learn more about Drips Wave

[firstJOASH]

@firstJOASH has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

i can solve this issue please assign me

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

[Franklivania]

@Franklivania has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi, I am Franklin. I have configured Prisma and Node database clients with controlled pooling and strict timeouts to prevent connection exhaustion and hanging requests, especially in serverless environments. I’ve implemented fast-fail health checks and documented environment-specific tuning strategies.

For this issue, I would:

• Configure pool limits appropriately (serverless vs Node server).
• Set connection and query timeouts (~5s) to prevent long-running hangs.
• Implement a lightweight health check query with fail-fast behavior.
• Document pooling and timeout decisions in the README with deployment context.

ETA: 6–8 hours.

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

[Sundayabel222]

@Sundayabel222 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Pls i will love to work on this issues

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

[iGEORGE17]

@iGEORGE17 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

hello team 👋🏼
i would like to take on this task
I have 5 years of experience using React, /nestJS, Javascript, nextjs

thanks 🙏🏻

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