Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-27 Thread Don Baccus
At 10:46 AM 11/27/00 -0600, Ross J. Reedstrom wrote: >Uh, Don? >Not all the world's a web page, you know. Thatkind of thinking is _so_ >mid 90's ;-) Dedicated apps that talk directly the user seem to be making >a comeback, due to a number of factors. They can have much cleaner user >interfaces, f

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-27 Thread Ross J. Reedstrom
On Mon, Nov 27, 2000 at 12:09:00PM -0500, Tom Lane wrote: > > I'm still not following exactly what people think would happen if we did > have such a "feature". OK, the backend times out after some interval > of seeing no activity, and disconnects. How is the client going to > react to that, exa

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-27 Thread Tom Lane
"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes: > Which brings us back around to the point of why this is on Hackers: > PostgreSQL currently has no clean method for dropping idle connections. > Yes, some apps handle this themselves, but not all. A number of people > seem to feel there is a need fo

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-27 Thread Ross J. Reedstrom
Uh, Don? Not all the world's a web page, you know. Thatkind of thinking is _so_ mid 90's ;-) Dedicated apps that talk directly the user seem to be making a comeback, due to a number of factors. They can have much cleaner user interfaces, for example. Which brings us back around to the point of w

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-27 Thread Don Baccus
At 12:38 AM 11/27/00 -0700, Ron Chmara wrote: >Don Baccus wrote: >> At 12:07 AM 11/26/00 -0500, Alain Toussaint wrote: >> >how about having a middle man between apache (or aolserver or any other >> >clients...) and PosgreSQL ?? >> >that middleman could be configured to have 16 persistant connectio

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-26 Thread Ron Chmara
Tom Samplonius wrote: > On Sun, 26 Nov 2000, Alain Toussaint wrote: > > > "I have all sorts of client apps, connecting in different ways, to > > > my server. Some of the clients are leaving their connections open, > > > but unused. How can I prevent running out of backends, and boot > > > the inac

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-26 Thread Ron Chmara
Don Baccus wrote: > At 12:07 AM 11/26/00 -0500, Alain Toussaint wrote: > >how about having a middle man between apache (or aolserver or any other > >clients...) and PosgreSQL ?? > >that middleman could be configured to have 16 persistant connections,every > >clients would deal with the middleman i

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-26 Thread Tom Samplonius
On Sun, 26 Nov 2000, Alain Toussaint wrote: > > "I have all sorts of client apps, connecting in different ways, to > > my server. Some of the clients are leaving their connections open, > > but unused. How can I prevent running out of backends, and boot > > the inactive users off?" > > how abou

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Alain Toussaint
> Well, this is sort of what AOLserver does for you without any need for > middlemen. i agree that AolServer is good karma,i've been reading various docs on Aolserver since Philip Greenspun talked about it on linuxworld and i'm glad that there's some java support being coded for it (im my opinion

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Mitch Vincent
heck into it. Thanks! -Mitch - Original Message - From: "Don Baccus" <[EMAIL PROTECTED]> To: "Mitch Vincent" <[EMAIL PROTECTED]>; "PostgreSQL Hackers List" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, November 25, 2000 9:18 PM Subj

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Don Baccus
At 10:00 PM 11/25/00 -0800, Mitch Vincent wrote: >I've tried quite a bit to use persistent connections with PHP (for over >a year) and always the scripts that I try to use them with behave crazy... >The last time I tried there were problems all over the place with PHP, >variables getting overw

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Don Baccus
At 12:07 AM 11/26/00 -0500, Alain Toussaint wrote: >how about having a middle man between apache (or aolserver or any other >clients...) and PosgreSQL ?? > >that middleman could be configured to have 16 persistant connections,every >clients would deal with the middleman instead of going direct to

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Alain Toussaint
> "I have all sorts of client apps, connecting in different ways, to > my server. Some of the clients are leaving their connections open, > but unused. How can I prevent running out of backends, and boot > the inactive users off?" how about having a middle man between apache (or aolserver or any

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Mitch Vincent
TED]>; "PostgreSQL Hackers List" <[EMAIL PROTECTED]> Cc: "GH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, November 25, 2000 4:26 PM Subject: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections > Note: CC'd to Hackers, as this ha

Re: [HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Don Baccus
At 05:26 PM 11/25/00 -0700, Ron Chmara wrote: >Note: CC'd to Hackers, as this has wandered into deeper feature issues. > >Tom Lane wrote: >> GH <[EMAIL PROTECTED]> writes: >> > Do the "persistent-connected" Postgres backends ever timeout or die? >> No. A backend will sit patiently for the client

[HACKERS] Re: [NOVICE] Re: re : PHP and persistent connections

2000-11-25 Thread Ron Chmara
Note: CC'd to Hackers, as this has wandered into deeper feature issues. Tom Lane wrote: > GH <[EMAIL PROTECTED]> writes: > > Do the "persistent-connected" Postgres backends ever timeout or die? > No. A backend will sit patiently for the client to send it another > query or close the connection.