chore: update database connection to use connection pooling

AmoabaKelvin commented 3 months ago

Replaced createConnection with createPool to enable connection pooling for better performance and scalability
Set connectionLimit to 20 to limit the number of concurrent connections

vercel[bot] commented 3 months ago

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
ishortn-ink	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jul 11, 2024 3:40pm

what-the-diff[bot] commented 3 months ago

PR Summary

Improved Database Connection Management This update introduces connection pooling for handling communication with the database. Connection pooling can dramatically enhance application performance as it eliminates the overhead of initiating a new connection for every database operation. However, as part of this improvement, the options for 'keep alive' in the configuration were removed and replaced with a connection limit. This limit sets a cap on the number of simultaneous connections that the application can have with the database, helping to manage resource allocation more effectively.