Обсуждение: Pool of connections

Поиск
Список
Период
Сортировка

Pool of connections

От
Carlos Felipe Zirbes
Дата:
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

Re: Pool of connections

От
"Adam Lang"
Дата:
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)


RE: Pool of connections

От
Carlos Felipe Zirbes
Дата:
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

Re: Pool of connections

От
"Adam Lang"
Дата:
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