Thread: Any experiance with PostgreSQL and SQLRelay

Any experiance with PostgreSQL and SQLRelay

From
Marek Lewczuk
Date:
Hi,
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?

Thanks in advance.

ML



Re: Any experiance with PostgreSQL and SQLRelay

From
Dario Lah
Date:
Not with Postgres, but i'm using it with PHP/Oracle (easier to install
sqlrelay than oracle lient :) )

Anyway, it works ok and judging on comments on sqlrelay list, lots of
people find it good solution for connection pooling.

When I get some spare time, i'll probably rewrite postgres applications
to work with sqlrelay/postgres.

DL

On Pon, 2005-05-09 at 14:12 +0200, Marek Lewczuk wrote:
> Hi,
> I need a db connection pooling in PHP. As far I know persistent
> connections are not the best solution so I'm thinking about using
> SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
> SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
>
> Thanks in advance.
>
> ML
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match


Re: [PHP] Any experiance with PostgreSQL and SQLRelay

From
Christopher Kings-Lynne
Date:
> I need a db connection pooling in PHP. As far I know persistent
> connections are not the best solution so I'm thinking about using
> SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
> SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?

Try pgpool.

Chris

Re: [PHP] Any experiance with PostgreSQL and SQLRelay

From
"Joshua D. Drake"
Date:
Christopher Kings-Lynne wrote:
>> I need a db connection pooling in PHP. As far I know persistent
>> connections are not the best solution so I'm thinking about using
>> SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
>> SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
>
>
> Try pgpool.
>

I second this.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.

> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org


Re: [PHP] Any experiance with PostgreSQL and SQLRelay

From
Marek Lewczuk
Date:
Christopher Kings-Lynne napisał(a):
>> I need a db connection pooling in PHP. As far I know persistent
>> connections are not the best solution so I'm thinking about using
>> SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
>> SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
>
>
> Try pgpool.
Thanks.