api: add configurable database connection pool settings

Miroslav Vadkertirequested to merge
mvadkert/nucleus:api/database-pool-settings into main

Add support for configuring SQLAlchemy connection pool parameters via settings to help prevent pool exhaustion under high load:

  • DATABASE_ENGINE_MAX_OVERFLOW: max overflow connections (default: 10)
  • DATABASE_ENGINE_POOL_TIMEOUT: connection wait timeout in seconds (default: 30)
  • DATABASE_ENGINE_POOL_PRE_PING: test connections before use (default: true)

The pool_pre_ping option helps handle stale connections from database restarts or network interruptions.

Generated-By: Claude Code

Signed-off-by: Miroslav Vadkerti mvadkert@redhat.com

Edited by Miroslav Vadkerti

Merge request reports