FWIW, we are discussing the internal DBI pooling mechanism at the dbi-dev list and having already a sort-of-working prototype. So hopefully there will be no need for Apache::DBI in the near future, as DBI will be able to handle pooling internally. However it may take some time, as the drivers will have to adjust to support the new functionality.
You can see the thread here: http://archive.develooper.com/[EMAIL PROTECTED]/index.html#02118
Some working examples are attached to this message: http://archive.develooper.com/[EMAIL PROTECTED]/msg02134.html
This is totally cool, Stas! Nice work. I look forward to answering "yes" when people ask if mod_perl has database connections pooling.
By the way, to completely get rid of Apache::DBI this would need to cover the safety functionality in there as well, i.e. the pinging and the part where it rolls back any pending transactions when a a handle is returned to the pool.
- Perrin
