2 ms·
"I'm not a Django person" 1. Using PGBouncer seems to be the ideal solution, but I'm not sure other databases actually provide a proxy. I haven't heard of some
by alexpopescu 14y ago
"I'm not a Django person"
1. Using PGBouncer seems to be the ideal solution, but I'm not sure other databases actually provide a proxy. I haven't heard of something like this for MySQL (a) I might be wrong, please provide a link, b) I'm know some will say "just don't use MySQL")
This aside, I would expect a connection pool implementation to support at least the following:
1. min: minimum number of connections
2. max: maximum number of connections
3. idleTime: time interval after which idle connections are automatically closed
4. connection cleanup (most often done when returned to the pool). Basically making sure that the connection object is pristine
If it doesn't do all these, then it's probably not something you'd want to use.