Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:128798
Precedence: list
MIME-Version: 1.0
References: <CANdUeaZhn-8b2+LZDV3UnT1sx+BVFcz=m7neQHyv7huGega+_Q@mail.gmail.com>
 <CE73D727-9546-469F-A723-FE667CA4061D@gmail.com> <CANdUeaZ0u-BmdUuX9XD--H2CA0zys+J8j5Cem4YQd2Q555m9Vw@mail.gmail.com>
 <CAGBsUrftu_-XfQQhKpBM_YJp_VOJJ1FyWNi+1wqZ+77q4LQSiQ@mail.gmail.com>
 <df38d1c4-1ebd-4320-9b6c-1ddf725c426c@app.fastmail.com> <43a60bc9-8e3d-4d83-ae8a-13465a6ef3e9@beccati.com>
In-Reply-To: <43a60bc9-8e3d-4d83-ae8a-13465a6ef3e9@beccati.com>
Date: Thu, 9 Oct 2025 13:47:35 -0400
Message-ID: <CANdUeaaBruU0W1AvWjCRd3yi8Lrhq-twVmsEsohKGNo6ABymDA@mail.gmail.com>
Subject: Re: [PHP-DEV] [Discuss] Add PDO disconnect() and isConnected()
To: Matteo Beccati <php@beccati.com>
Cc: PHP internals <internals@lists.php.net>
Content-Type: multipart/alternative; boundary="00000000000033f3580640bd664f"
From: rposky@gmail.com (Robert Wolf)

--00000000000033f3580640bd664f
Content-Type: text/plain; charset="UTF-8"

> I would argue we should discourage their use
> (deprecation is my dream!)

I am with you on the deprecation of persistent connections, as the
implementation is awkward, but not without addressing the use case.

> As you well know, PDO is an object which also optionally uses PHP
persistent resources to facilitate connection re-use across PHP requests, a
feature which I don't believe has a parallel in object space. Perhaps > >
therein lies a feature request, i.e. to allow an object to be made
persistent in the same way a resource can.

I floated the above idea. Any inclination that would be worth pursuing?

> ... would be an interface to declare the persistent connection as
defunct, such that upon subsequent PDO creation, a new connection will be
formed, and the former will be closed. This is distinct from a disconnect
or > reconnect procedure, and similar to failing a "liveness" check upon
persistent PDO creation. Users could then effectively replace their
persistent PDO in the same manner they would do so for a "regular" PDO.

This idea is growing on me, to address the issue of a defunct persistent
connection, rather than the disconnect() interface. Any thoughts on
introducing a new attribute to the PDO constructor to prompt the
reconnection: PDO::ATTR_PERSISTENT_RECONNECT.

-Robert

--00000000000033f3580640bd664f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">&gt; I would argue we should discourage t=
heir use<span class=3D"gmail-Apple-converted-space">=C2=A0</span></div>&gt;=
 (deprecation is my dream!)<div dir=3D"ltr"><br></div><div dir=3D"ltr">I am=
 with you on the deprecation of persistent connections, as the implementati=
on is awkward, but not without addressing the use case.=C2=A0<br></div><div=
 dir=3D"ltr"><br></div><div dir=3D"ltr">&gt; As you well know, PDO is an ob=
ject which also optionally uses PHP persistent resources to facilitate conn=
ection re-use across PHP requests, a feature which I don&#39;t believe has =
a parallel in object space. Perhaps &gt; &gt; therein lies a feature reques=
t, i.e. to allow an object to be made persistent in the same way a resource=
 can.<div><br></div><div>I floated the above idea. Any inclination that wou=
ld be worth pursuing?</div><div><br></div><div>&gt; ... would be an interfa=
ce to declare the persistent connection as defunct, such that upon subseque=
nt PDO creation, a new connection will be formed, and the former will be cl=
osed. This is distinct from a disconnect or &gt; reconnect procedure, and s=
imilar to failing a &quot;liveness&quot; check upon persistent PDO creation=
. Users could then effectively replace their persistent PDO in the same man=
ner they would do so for a &quot;regular&quot; PDO.</div><div><br></div><di=
v>This idea is growing on me, to address the issue of a defunct persistent =
connection, rather than the disconnect() interface. Any thoughts on introdu=
cing a new attribute to the PDO constructor to prompt the reconnection: PDO=
::ATTR_PERSISTENT_RECONNECT.</div><div><br></div><div>-Robert</div></div></=
div>

--00000000000033f3580640bd664f--