Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:117862
Feedback-ID: i6f4c46c2:Fastmail
Message-ID: <712d22c1-1409-d48d-9f83-c94c46ead578@beccati.com>
Date: Tue, 7 Jun 2022 10:17:04 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
 Firefox/102.0 Thunderbird/102.0
Content-Language: en-GB
To: Dan Ackroyd <Danack@basereality.com>,
 PHP internals <internals@lists.php.net>
References: <CA+kxMuT54_xanhDr2ARceZhK2PrnQpJ0YrfX7rc3Ya4YJsbbpg@mail.gmail.com>
In-Reply-To: <CA+kxMuT54_xanhDr2ARceZhK2PrnQpJ0YrfX7rc3Ya4YJsbbpg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] DB specific PDO subclasses questions.
From: php@beccati.com (Matteo Beccati)

Hi Dan,

On 06/06/2022 21:15, Dan Ackroyd wrote:
> Hi,
> 
> I'm looking at making an RFC for subclassing PDO to expose database
> specific methods in a less magic way, aka implementing what was
> discussed here: https://externals.io/message/100773#100813

Oh, that was a long thread! Not sure what the RFC goal would be, but I'm 
happy to discuss :)


> I have two questions for people who use the PDO with SQLite or Postgres
> 
> 1. Are any of the functions that are specific to those databases
> horribly designed and need changing? As the functions would be 'copied
> across' from where they are now, changes could be made without having
> horrible BC breaks.

I will check, but...

> That is, are any of these functions horrible to use:

[snip]

Not that I know of.


> 2. Other than the SQLite blobOpen functionality, does anyone know of
> any other functionality that is exposed by SQLite or Postgres that
> isn't currently exposed through the magic PDO methods?

ext/pgsql has plenty of low level functions, e.g. for connection 
management, more large-object functionality and has async 
functionalities. For various reasons, none of them seem a good fit for 
PDO to me:

  - connection management: a common interface would be best
  - large objects: mostly obsolete functionality, a PITA to work with
  - async: better to leave that for PDO2, PDO-ng or PDO++ ;-)


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/