aws-samples / aws-samples/aws-serverless-app-with-aurora-and-python-sql-alchemy-example
Question related Connection Pool settings
- 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
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