Hi Jesse, Please take a look at Commons DBCP and how your proposal would fit in.
Gary On Wed, Nov 8, 2023, 4:49 PM Jesse Harris <jesse.har...@veeva.com.invalid> wrote: > Would there be any interest in contributing an implementation of a multi > tenant connection pool implementation? > > One implementation of a multi-tenant architecture is to have a schema per > tenant, the downside is that you need to set the default database on each > connection pulled from the pool, this creates a lot of overhead. Ideally a > pool with "affinity" based on an arbitrary key, pull a connection already > prepared for the given schema, if there is not one, steal one from another > schema and reset the default schema in that case. > > The problem with the per-user pool is that it requires a per schema user, > also when stealing connections you have to recreate the socket when the > user changes. > > thanks in advance > -jesse >
