Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:121878 Return-Path: Delivered-To: mailing list internals@lists.php.net Received: (qmail 3493 invoked from network); 30 Nov 2023 18:21:49 -0000 Received: from unknown (HELO php-smtp4.php.net) (45.112.84.5) by pb1.pair.com with SMTP; 30 Nov 2023 18:21:49 -0000 Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id D4D61180048 for ; Thu, 30 Nov 2023 10:21:56 -0800 (PST) X-Spam-Checker-Version: SpamAssassin 4.0.0 (2022-12-13) on php-smtp4.php.net X-Spam-Level: X-Spam-Status: No, score=-2.8 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,DMARC_MISSING,RCVD_IN_DNSWL_LOW, RCVD_IN_MSPIKE_H3,RCVD_IN_MSPIKE_WL,SPF_HELO_PASS,SPF_NONE autolearn=no autolearn_force=no version=4.0.0 X-Spam-Virus: No X-Envelope-From: Received: from out4-smtp.messagingengine.com (out4-smtp.messagingengine.com [66.111.4.28]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by php-smtp4.php.net (Postfix) with ESMTPS for ; Thu, 30 Nov 2023 10:21:56 -0800 (PST) Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 235675C0185; Thu, 30 Nov 2023 13:21:47 -0500 (EST) Received: from imap50 ([10.202.2.100]) by compute1.internal (MEProxy); Thu, 30 Nov 2023 13:21:47 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= garfieldtech.com; h=cc:cc:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm1; t= 1701368507; x=1701454907; bh=wXX/n/aCmuHg/7SXADNeQkhT5sS5zZ/AByk ACmqyCbI=; b=qXOdbVn0GJmPaAcnDcalAQXK3Gte21oi0AgtzsXsRhnUgBhTffI SxuEaU0YFyxUES+UVrdloVHHEP/LvuZFJcH09DxwfRQM+UVkkgj7Le1cuiXKOJ0L ks5P0CQGCFyPUgdBdLpAJnSyPxsp9PzT44p/HE3YHGs9+a/nq6lDoy/n8PcDasUs giwXPSOoCIJiCaSRMoPU2G/2RRM3FQ6/CP28rcBPydimivtpUYqoDTtnbka2Ikgc MBFVoUb1gdwI6ocQ4ldHNPrJxN2EkG40F5VQ6L0XFHK35vREtd8dcvpn+X/rYVWI YFh+3dpGknAsijsiyjS79Od4LPjF/XWVAbQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1701368507; x=1701454907; bh=wXX/n/aCmuHg/ 7SXADNeQkhT5sS5zZ/ABykACmqyCbI=; b=Ymz9Gh1mFncwBa/3iGkXdSeFhoDp1 hSSDaBTSlo3bkUFGCROK42BMecGVH63TRUBPLFFR+Gv4Oe1GoVuQN5iLIA70cRqY ZYfxRQTqvfjuupR/++4Ith1jXG6wiusrSEIeechgRFsNdnAPDO1u0nqssPLJLNET mZY4GwWWJX7qwYs2B2f3fZ1PvkJXNIZ8hQfsK4RJeuojXyNeHqGcQ/RGqJgN9LOl w1VZhXPxNTi+eOfnd6rjEj+gAwvxYdT56biGbyKGt4OMWtgx0k7rZzInZdAPH93w qxEonG3YznmNitklkhqFXNr7HKQQzV74ktwguSKBQRqdswR3FSdMtS1Xg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudeijedguddutdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefofgggkfgjfhffhffvvefutgesthdtredtreertdenucfhrhhomhepfdfn rghrrhihucfirghrfhhivghlugdfuceolhgrrhhrhiesghgrrhhfihgvlhguthgvtghhrd gtohhmqeenucggtffrrghtthgvrhhnpeeuleduleeikefhkeekgfeiudffjeffffehveek udeugeettdefteehkeeguedtgfenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpehlrghrrhihsehgrghrfhhivghlughtvggthhdrtghomh X-ME-Proxy: Feedback-ID: i8414410d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 7D6E71700089; Thu, 30 Nov 2023 13:21:46 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-1238-g6cccb1fa34-fm-20231128.002-g6cccb1fa MIME-Version: 1.0 Message-ID: <6cfba3c2-c754-422f-8031-0f6046f828ac@app.fastmail.com> In-Reply-To: References: <6A2118D9-6DD0-4273-A2C0-A1088C05314D@sakiot.com> Date: Thu, 30 Nov 2023 18:21:25 +0000 To: "Saki Takamachi" , "Jeffrey Dafoe" Cc: "php internals" Content-Type: text/plain Subject: Re: [PHP-DEV] [PDO] 2 phase commit From: larry@garfieldtech.com ("Larry Garfield") On Thu, Nov 30, 2023, at 2:03 PM, Saki Takamachi wrote: > Hi Jeff, > >> Would the implementation use the underlying RDBMS two-phase commit? Or would the proposal be to try to build something at the PDO layer to mimic two-phase commits? The former seems good, the latter, not so much. > > When implementing this, if each DB driver's API has a two-phase commit > function, I would like to use it. I don't mean "emulate" it with PDO. > > I haven't checked all the DB APIs because I'm still thinking about > whether to propose it, but I've confirmed that at least Firebird's API > has that functionality. > > Regards. > > Saki I have not heard of this functionality before, so I don't know how common it is. If it's only lightly supported and in different ways, perhaps this is a use case for the new per-DB subclasses? --Larry Garfield