Re: $$Need apache server database pool....$$

Hello Eric, On 19-Jul-00 18:39:08, you wrote: >Checkout the thread on the php-general mailing list with regard to >"Large PHP/Database driven site & scalability" but anyhow I need to have >connection pooling integrated into the mysql_pconnects in an apache/php >module environment instead of the current apache child based pool - >If i can get confirmation on the possibility of it, and >how long it would take I would enjoy looking into financing the >development of it - and I've seen threads all over the php mailing list of >people asking for it - I'm sure its possible to start a combined pool for >the funding as well I am developing a way not only to manage a database connection pools but also handle remote database connections eventually over VPN supporting compression and encription, with query caching support among other things. This would work based only on PHP code. I am facing a few technical challenges like the lack of multi-threading support (to handle multiple simultaneous connections) in PHP (unlike Java and Perl) and a ability that is still being added to PHP that is of making PHP act as a standalone deamon reachable by Unix domain or TCP socket. I am very busy with other prioritary things but that's the way to go. This will be done as soon as I get more free time apart my real day job. Anyway, this will be part of Metabase, a full blown PHP database abstraction package available here. http://phpclasses.UpperDesign.com/browse.html/package/20 Anyway, since you are with a certain hurry, you might be interested in this SQL relay package that has similar goals although fully written in C++ for Unix, but it doesn't seem to be available in PHP yet. http://www.firstworks.com/site/pages/html/projects.html#sqlrelay While you are at the money, you may want to sponsor the author so he can give some priority to support PHP. Look here for the details. http://www.firstworks.com/site/pages/html/sponsor.html Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --