Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:123240
Feedback-ID: i8414410d:Fastmail
User-Agent: Cyrus-JMAP/3.11.0-alpha0-416-g2c1796742e-fm-20240424.001-g2c179674
Precedence: bulk
MIME-Version: 1.0
Message-ID: <cb11345a-a212-4ea0-b23f-7988792c9b52@app.fastmail.com>
In-Reply-To: 
 <CAL0xaBFr5E_NC3vBc7Pgk9i8ZRb9wiSa3FvS-mE8UW9HDiGhcw@mail.gmail.com>
References: 
 <CAL0xaBFr5E_NC3vBc7Pgk9i8ZRb9wiSa3FvS-mE8UW9HDiGhcw@mail.gmail.com>
Date: Tue, 30 Apr 2024 17:47:58 +0000
To: "php internals" <internals@lists.php.net>
Subject: Re: [PHP-DEV] Proposal to Create a MariaDB Alias for the MySQL PDO Driver
Content-Type: text/plain
From: larry@garfieldtech.com ("Larry Garfield")

On Tue, Apr 30, 2024, at 4:50 PM, Arvids Godjuks wrote:
> Hello,
>
> I'm splitting this discussion from https://externals.io/message/123183, 
> see details at https://externals.io/message/123183#123234 and 
> https://externals.io/message/123183#123236 to keep the original thread 
> clean.
>
> There's a clear divergence in functionality between MySQL and MariaDB. 
> As PDO evolves to accommodate database-specific drivers, it's sensible 
> to introduce a MariaDB alias for the MySQL driver. Although the mysqlnd 
> library handles networking protocols for both, practical higher level 
> usage increasingly demands differentiation at the database layer, much 
> like Doctrine's recent updates requiring distinct identification of 
> MariaDB vs. MySQL.
>
> I propose establishing a MariaDB namespace. This would allow for 
> explicit implementation of database-specific functions and help in 
> correctly mapping methods and queries to the respective database.
>
> Thoughts? Questions?

I agree with this.  Even if the wire protocol isn't different right now, the SQL syntax is.  Giving a "native" hook point for people to vary their DB is useful, and sets us up for when there are wire or parser differences later.

Bear in mind that MySQL now also has the mysqlx protocol, which is basically a native query builder that bypasses an SQL string entirely.  MariaDB has no such thing.  I don't know how that would play into PDO at all, but this sort of split would give us a natural starting point to figure that out in the future.

--Larry Garfield