Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:128751
Content-Type: text/plain;
	charset=utf-8
Precedence: list
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\))
Subject: Re: [PHP-DEV] [Discuss] Add PDO disconnect() and isConnected()
In-Reply-To: <c127636e-fddd-422f-8fa7-3a56d37c8ed7@app.fastmail.com>
Date: Wed, 1 Oct 2025 09:28:36 +0200
Cc: php internals <internals@lists.php.net>
Content-Transfer-Encoding: quoted-printable
Message-ID: <241055E8-3365-4299-9B2F-4B94708CECFD@gmail.com>
References: <CANdUeaZhn-8b2+LZDV3UnT1sx+BVFcz=m7neQHyv7huGega+_Q@mail.gmail.com>
 <CAGBsUrd_-6UmqedKs1x95Uj2bb8GkBvYHJaFkvrnnoKTq_O=QA@mail.gmail.com>
 <CAPhkiZyYL72x93E-M2BNAN7vfN-7DSNmoXvS+KOSPgAoo7qjSg@mail.gmail.com>
 <CAGBsUrcPL4uPu_ehRJOC5qqu8OAK+=_a4KuhXiRhzkLMrTe_vQ@mail.gmail.com>
 <4ddd9a25-47b8-4a2b-ad93-e93f8f33922b@app.fastmail.com>
 <C89AED3B-86E5-4B19-A3DF-906CDBA26C1F@gmail.com>
 <c127636e-fddd-422f-8fa7-3a56d37c8ed7@app.fastmail.com>
To: Larry Garfield <larry@garfieldtech.com>
From: claude.pache@gmail.com (Claude Pache)



> Le 30 sept. 2025 =C3=A0 23:07, Larry Garfield <larry@garfieldtech.com> =
a =C3=A9crit :
>=20
> On Tue, Sep 30, 2025, at 3:08 PM, Claude Pache wrote:
>>> Le 30 sept. 2025 =C3=A0 17:40, Larry Garfield =
<larry@garfieldtech.com> a =C3=A9crit :
>>>=20
>>>=20
>>> What would be valuable is easier RE-connection logic.  Either PHP or =
MySQL may terminate an idle connection, which is a concern in =
long-running processes (Queue workers, ReactPHP, Franken, etc.).  Tools =
like Doctrine have built their own refresh logic in, although they're =
not always consistent with each other or obvious to use.  Having some =
kind of reconnection logic built into PDO that "just works" would be =
very valuable.
>>>=20
>>> What that would look like, I'm not sure.  Just spitballing:
>>>=20
>>> // After X seconds, drop and reopen the connection the next time =
it's used.
>>> $pdo->reconnectAfter($seconds);
>>>=20
>>> --Larry Garfield
>>=20
>> Auto-reconnection is dangerous, because database engines are =
stateful.=20
>> For example, disaster will happen if disconnection had occurred in =
the=20
>> middle of a transaction...
>>=20
>> =E2=80=94Claude
>=20
> All the more reason that the logic should be implemented once in PDO =
and then shared, rather than everyone having to figure it out in user =
space themselves.
>=20
> I'm not suggesting that PDO actively try to disconnect all the time.  =
But if the connection is "stale," it should be able to restart it =
without making the user faff about to do so.  (Whether that's via =
detecting that it's gone away, a timer, or whatever else, I'm very =
flexible.)
>=20
> --Larry Garfield

Database connections are full of state (apart from transactions, there =
are also sql variables, temporary tables, and probably other stuff I am =
not aware of), thus auto-reconnection cannot be transparent in the =
general case. In specific scenarios, this is ok, but I doubt that it is =
best managed by a generic extension like pdo.

=E2=80=94Claude=