Support SQLProvider without connection pool
Description
This MR adds suppport to create SQLProvier
without a connection pool. This can be useful when setting up simple test cases or the connection endpoint is already managed by a 3rd-party connection pool, e.g., pgbouncer.
This behavior is triggered when configuring pool-size == 0
. When set, other pool-*
parameters are naturally ignored.
Changes proposed in this merge request:
- Use
poolclass=NullPool
whenpool-size == 0
. - Update minimum value of
pool-size
to 0.
Validation
A unit-test for this change is pretty hard. Instead, I added a docker-compose
example that connects to pgbouncer.