Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:130550
Precedence: list
MIME-Version: 1.0
References: <CALkpNnS=nooF2nMpSvzufm3PtcZpLE9Sx04wEeXOmgtQ=SqGiA@mail.gmail.com>
 <606EDE71-8E63-4626-A509-5E067DA3EACA@sakiot.com> <CALkpNnRDJG7bwZ8Mr9jDq+r-mLSJ47SDsGbYA_gCGsm9TSApSQ@mail.gmail.com>
In-Reply-To: <CALkpNnRDJG7bwZ8Mr9jDq+r-mLSJ47SDsGbYA_gCGsm9TSApSQ@mail.gmail.com>
Date: Fri, 3 Apr 2026 12:20:06 -0400
Message-ID: <CALkpNnTr48OjWwC=dQRT6r7YbyWPmzupSquS3ZS4Dk2Lyfk_tw@mail.gmail.com>
Subject: Re: [PHP-DEV] PDO SQLite: statement attributes for SQL text retrieval
To: Saki Takamachi <saki@sakiot.com>
Cc: Kamil Tekiela <tekiela246@gmail.com>, internals@lists.php.net, saki@php.net
Content-Type: multipart/alternative; boundary="0000000000005d11fe064e90b162"
From: ilia@ilia.ws (Ilia)

--0000000000005d11fe064e90b162
Content-Type: text/plain; charset="UTF-8"

>
> I don't feel strongly about one way or the other. I'm happy to revise this
> into a function if the consensus is that everyone is more comfortable with
> parameters allowing either pre/post binding state to be returned, probably
> defaulting to the pre-binding state.
> I don't think 2 methods are needed for functionality that is functionally
> very similar.
>
> That being said, I still prefer an attribute because this isn't an
> actionable function (like sqliteCreateFunction) but rather something that
> retrieves information, which to me seems more appropriate for attribute
> retrieval similar to Pdo\Pgsql::ATTR_RESULT_MEMORY_SIZE for example.
> I don't think this warrants its own function and the value of setting a
> return type seems minimal.
>

One more thing :)

Looking at pdo/PgSQL and pdo/SQlite they both limit custom functions to
things that change data. However, pdo/MySQL and pdo/Firebird break the
convention, each has a single custom function for info retrieval, so there
isn't technically as convention universally followed convention here.


-- 
Ilia Alshanetsky
Technologist, CTO, Entrepreneur
E: ilia@ilia.ws
T: @iliaa
B: http://ilia.ws

--0000000000005d11fe064e90b162
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote gmail_quote_container"><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gma=
il_quote"><div>I don&#39;t feel strongly about one way or the other. I&#39;=
m happy to revise this into a function if the consensus is that everyone is=
 more comfortable with parameters allowing either pre/post binding state to=
 be returned, probably defaulting to the pre-binding state.</div><div>I don=
&#39;t think 2 methods are needed for functionality that is functionally ve=
ry similar.=C2=A0</div><div><br></div><div>That being said, I still prefer =
an attribute because this isn&#39;t an actionable function (like sqliteCrea=
teFunction) but rather something that retrieves information, which to me se=
ems more appropriate for attribute retrieval similar to Pdo\Pgsql::ATTR_RES=
ULT_MEMORY_SIZE for example.=C2=A0</div><div>I don&#39;t think this warrant=
s its own function and the value of setting a return type seems minimal.</d=
iv></div></div></blockquote><div><br></div><div>One more thing :)</div><div=
><br></div><div>Looking at pdo/PgSQL and pdo/SQlite they both limit custom =
functions to things that change data. However, pdo/MySQL and pdo/Firebird b=
reak the convention, each has a single custom function for info retrieval, =
so there isn&#39;t technically=C2=A0as convention universally followed conv=
ention here.</div><div>=C2=A0</div></div><div><br></div><span class=3D"gmai=
l_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature=
"><div dir=3D"ltr">Ilia Alshanetsky<div>Technologist, CTO, Entrepreneur</di=
v><div>E: <a href=3D"mailto:ilia@ilia.ws" target=3D"_blank">ilia@ilia.ws</a=
></div><div>T: @iliaa=C2=A0</div><div>B: <a href=3D"http://ilia.ws" target=
=3D"_blank">http://ilia.ws</a></div></div></div></div>

--0000000000005d11fe064e90b162--