Re: [PDO] 2 phase commit

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