aws-samples / aws-samples/aws-serverless-app-with-aurora-and-python-sql-alchemy-example

Question related Connection Pool settings

Open
#9 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
67
Forks
16
PR merge metrics
No merged PRs in 30d

Description

Hey 👋

I saw that you used Pool Size = 1 and max overflow = 0

return create_engine(db_conn_string,
echo=debug_mode,
pool_size=1,
max_overflow=0,
pool_recycle=3600,
pool_pre_ping=True,
pool_use_lifo=True)

Was this by intention because of the RDS Proxy?
Could you explain why not a higher Pool Size was used as the RDS Proxy is handling the Connections anyway?

Would love to hear your reasons because I want to run this kind of setup for a productive use case.

Best regards

Contributor guide

Open the contributing guide

Research direction

Start with the create_engine configuration shown in the issue, focusing on pool_size, max_overflow, and the RDS Proxy context. Check the example’s existing documentation or configuration around this entry point; done means recording a clear explanation of why these values were chosen and whether a higher pool size is appropriate for the stated setup.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, python, sqlalchemy
Domain
databases, documentation
Issue type
Documentation
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.