Implement Connection Pooling for SQL and PostgreSQL Storage - Githubissues

Mehrn0ush / RustifyAuth

Rustify-Auth is a lightweight OAuth 2.0 & 2.1 authorization server in Rust. It supports Authorization Code + PKCE, Client Credentials, Refresh Tokens, and secure JWT token generation. Join us for #Hacktoberfest and contribute to improving security and authentication in Rust projects! #rust #oauth2 #hacktoberfest #jwt #authentication #authorization

MIT License

8 stars 4 forks source link

Implement Connection Pooling for SQL and PostgreSQL Storage #13

Open Mehrn0ush opened 1 month ago

Mehrn0ush commented 1 month ago

Description: Connection pooling is essential for optimizing the performance of SQL and PostgreSQL storage backends in rustify-auth, especially under high load. We need to implement connection pooling to manage database connections efficiently.

Requirements:

Implement connection pooling for SQL and PostgreSQL using deadpool-postgres, r2d2, or sqlx.
Ensure that connection pooling works seamlessly with asynchronous processing in Rust.
Provide configuration options for the pool size and timeout settings.

Tasks:

[ ] Integrate connection pooling for PostgreSQL and SQL backends.
[ ] Expose configuration options for managing the pool (size, timeout).
[ ] Write integration tests to validate connection pooling under load.
[ ] Ensure that pooled connections are efficiently managed during token and client operations.

github-actions[bot] commented 12 hours ago

This issue has been marked as stale due to inactivity. It will be closed if no further activity occurs.