Thread: Pool of connections
Hi. What is the best way to make connections to pgsql from PHP? Today I use pg_connect but I dislike having username and password written in plain text in my source. Besides, I would like to be able to limit the number of simultaneous connections to pgsql. Any hint will be apreciated. TIA, Carlos Felipe Zirbes DBServer Assessoria em Sistemas de Informação E-mail: carlosz@dbserver.com.br Fone: (51) 342-8055 Fax: (51) 342-4838
As far as I know, pgconnect is the only way you can. Include your database conenction information in an include file and have your include directory outside the www-root directory. That way no one can see it. The only other way is to purchase zend encoder which will encrypt the files. O you could write your own include routine that unecrypts the file and then includes the reulst. Then, when you are making includes, you'd have another program that would take the text and encrypt it. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Carlos Felipe Zirbes" <carlosz@dbserver.com.br> To: <pgsql-php@postgresql.org> Sent: Thursday, June 07, 2001 1:11 PM Subject: [PHP] Pool of connections > > Hi. > > What is the best way to make connections to pgsql from PHP? > > Today I use pg_connect but I dislike having username and password written in > plain text in my source. Besides, I would like to be able to limit the > number of simultaneous connections to pgsql. > > Any hint will be apreciated. > > TIA, > > Carlos Felipe Zirbes > DBServer Assessoria em Sistemas de Informação > E-mail: carlosz@dbserver.com.br > Fone: (51) 342-8055 > Fax: (51) 342-4838 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Thanks for your help. There's this Internet site where I was working on until last month where they used an application/http server called WebLogic that could also handle database connections. This way, in their pages, you can find only references to the pool created in the server and never find any password or user name on it. . I just thought there could be some software I could use to do something similar in our architecture (they use java applets, jsp and ejb's, connecting to a SQL Server). Carlos Felipe Zirbes DBServer Assessoria em Sistemas de Informação E-mail: carlosz@dbserver.com.br Fone: (51) 342-8055 Fax: (51) 342-4838 -----Original Message----- From: Adam Lang [mailto:aalang@rutgersinsurance.com] Sent: Quinta-feira, 7 de Junho de 2001 14:49 To: pgsql-php@postgresql.org Subject: Re: [PHP] Pool of connections As far as I know, pgconnect is the only way you can. Include your database conenction information in an include file and have your include directory outside the www-root directory. That way no one can see it. The only other way is to purchase zend encoder which will encrypt the files. O you could write your own include routine that unecrypts the file and then includes the reulst. Then, when you are making includes, you'd have another program that would take the text and encrypt it. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com
Well, that's one of the advantages of ASP and JSP over PHP. You make compiled modules (EJB, COM, DLL, etc.) that hold all that code to reference, whereas PHP can't do that. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Carlos Felipe Zirbes" <carlosz@dbserver.com.br> To: "'Adam Lang'" <aalang@rutgersinsurance.com>; <pgsql-php@postgresql.org> Sent: Thursday, June 07, 2001 2:50 PM Subject: RE: [PHP] Pool of connections > Thanks for your help. > > There's this Internet site where I was working on until last month where > they used an application/http server called WebLogic that could also handle > database connections. This way, in their pages, you can find only references > to the pool created in the server and never find any password or user name > on it. . > > I just thought there could be some software I could use to do something > similar in our architecture (they use java applets, jsp and ejb's, > connecting to a SQL Server). > > Carlos Felipe Zirbes > DBServer Assessoria em Sistemas de Informação > E-mail: carlosz@dbserver.com.br > Fone: (51) 342-8055 > Fax: (51) 342-4838 > > > > -----Original Message----- > From: Adam Lang [mailto:aalang@rutgersinsurance.com] > Sent: Quinta-feira, 7 de Junho de 2001 14:49 > To: pgsql-php@postgresql.org > Subject: Re: [PHP] Pool of connections > > > As far as I know, pgconnect is the only way you can. > > Include your database conenction information in an include file and have > your include directory outside the www-root directory. That way no one can > see it. The only other way is to purchase zend encoder which will encrypt > the files. > > O you could write your own include routine that unecrypts the file and then > includes the reulst. Then, when you are making includes, you'd have another > program that would take the text and encrypt it. > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > http://www.rutgersinsurance.com