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
