Re: Designing a better connection pool for psycopg3

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>, psycopg(at)postgresql(dot)org
Subject: Re: Designing a better connection pool for psycopg3
Date: 2021-01-18 14:31:44
Message-ID: CA+mi_8b7Vg3+yS84mNKc2ToOEuvkXDC+QMFeT7Y5=Z3jP8wRJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On Mon, 18 Jan 2021 at 15:19, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> wrote:
>
> Am Mon, Jan 18, 2021 at 02:50:34PM +0100 schrieb Daniele Varrazzo:
>
> > > I would strongly advise against making sys.exit() the default
> > > for pool.terminate() unless I misunderstand something.
> >
> > How would you terminate the program if a maintenance thread, not the
> > main one, thinks that the program is not in working state?
>
> To me it is not the business of a library to terminate its
> user (eg an application) upon resource starvation. After all,
> the app may be perfectly fine with not being able to talk to
> the database. Only it knows what to do under such
> circumstances.
>
> If one wants to support such machinery, I would suggest a
> callback into the application, set up by the application
> code.

Thank you for the feedback, Karsten. Probably a customisable no-op
callback is a better default behaviour :)

-- Daniele

In response to

Browse psycopg by date

  From Date Subject
Next Message Magnus Hagander 2021-01-18 14:39:20 Re: Designing a better connection pool for psycopg3
Previous Message Daniele Varrazzo 2021-01-18 14:29:34 Re: Designing a better connection pool for psycopg3