I am developing a web based application using perl. I need to use the concept of connection pooling in it. I am using apache server & my db is postgres. Can any one help me in this regard.
If any sample script or the site provide will be of greater help.
Thanks & Regards,
Alma
For CGI-based Web application, most likely you can't because CGI scripts are executed fresh as a process with each access. All connections must be closed when the script is complete. So pooling has little use here.
You probably can implement it with mod_perl though. By designing your own mod_perl handler, you may likely implement this functionality as mod_perl handlers are persistent across requests. I have little experience with mod_perl, so I cannot give you much information.
But before you start implementing it yourself, take a look at these modules first. They should satisfy your requirements.