Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:122280
Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\))
In-Reply-To: <CAGBsUrcJ1Zw81AB2gcTDW_zD-G8xJeDiU7111JkS0TLgpRPggw@mail.gmail.com>
Date: Mon, 5 Feb 2024 10:28:27 +0900
Cc: PHP internals <internals@lists.php.net>
Content-Transfer-Encoding: quoted-printable
Message-ID: <C0555737-BF06-4B57-8F6E-0D70D610D49E@sakiot.com>
References: <325E790F-5E88-4559-862F-6C4ACBC89779@sakiot.com>
 <CAGBsUrcJ1Zw81AB2gcTDW_zD-G8xJeDiU7111JkS0TLgpRPggw@mail.gmail.com>
To: Kamil Tekiela <tekiela246@gmail.com>
Subject: Re: [PHP-DEV] [Proposal] Add `savepoint()` method to PDO
From: saki@sakiot.com (Saki Takamachi)

Hi Kamil,

> Why does this have to be done in PHP? Why can this not be done in SQL?

Of course, we can also do it with SQL. Indeed, many frameworks do that. =
However, if we think about it from that perspective, functions such as =
`beginTransaction()` and `commit()` can also be executed with SQL, =
except for some drivers.

Savepoint can still be used using SQL, but I'm thinking about adding it =
as a method for convenience.

> Also, I am not sure that mysqli implements this properly. It=E2=80=99s =
probably not the best extension to take an example of.

Since there was already an implementation in mysqli, I thought it would =
be natural to implement it in PDO as well, but based on what you =
mentioned, I may need to think about this a little more.

Regards.

Saki=