pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Pool of connections
4+ messages / 2 participants
[nested] [flat]

* Pool of connections
@ 2001-06-07 17:11  Carlos Felipe Zirbes <carlosz@dbserver.com.br>
  0 siblings, 1 reply; 4+ messages in thread

From: Carlos Felipe Zirbes @ 2001-06-07 17:11 UTC (permalink / raw)
  To: pgsql-php


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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Pool of connections
@ 2001-06-07 17:49  Adam Lang <aalang@rutgersinsurance.com>
  parent: Carlos Felipe Zirbes <carlosz@dbserver.com.br>
  0 siblings, 0 replies; 4+ messages in thread

From: Adam Lang @ 2001-06-07 17:49 UTC (permalink / raw)
  To: pgsql-php

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)




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* RE: Pool of connections
@ 2001-06-07 18:50  Carlos Felipe Zirbes <carlosz@dbserver.com.br>
  0 siblings, 1 reply; 4+ messages in thread

From: Carlos Felipe Zirbes @ 2001-06-07 18:50 UTC (permalink / raw)
  To: 'Adam Lang' <aalang@rutgersinsurance.com>; pgsql-php

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Pool of connections
@ 2001-06-07 19:22  Adam Lang <aalang@rutgersinsurance.com>
  parent: Carlos Felipe Zirbes <carlosz@dbserver.com.br>
  0 siblings, 0 replies; 4+ messages in thread

From: Adam Lang @ 2001-06-07 19:22 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-06-07 19:22 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-07 17:11 Pool of connections Carlos Felipe Zirbes <carlosz@dbserver.com.br>
2001-06-07 17:49 ` Adam Lang <aalang@rutgersinsurance.com>
2001-06-07 18:50 RE: Pool of connections Carlos Felipe Zirbes <carlosz@dbserver.com.br>
2001-06-07 19:22 ` Adam Lang <aalang@rutgersinsurance.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox