Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:123247
Date: Wed, 01 May 2024 14:06:33 +0000
To: Kamil Tekiela <tekiela246@gmail.com>
Cc: PHP internals <internals@lists.php.net>
Subject: Re: [PHP-DEV] Re: Proposal to Create a MariaDB Alias for the MySQL PDO Driver
Message-ID: <CwweHrL-XfNvdCdmuh38QBJV4ExxEmkKO2j6HaL4HPtnYTR75E91K8MKzQPbJX1kfc72wR7uicevp3-LrIRMiWrqy65-dIpXhaaZN5Zqzg4=@gpb.moe>
In-Reply-To: <CAGBsUrciqGzx=ExPEyoJ4BXi9rGR=+cPa6xBuFppAS_nF7o_qg@mail.gmail.com>
References: <CAL0xaBFr5E_NC3vBc7Pgk9i8ZRb9wiSa3FvS-mE8UW9HDiGhcw@mail.gmail.com> <6b2e7c73-0f21-4d3a-9db8-01184ae120fb@beccati.com> <CAL0xaBGTuYMyjwDP=zA+DOEQCqYQFVATduA_ZLj1nr5TUfRQXA@mail.gmail.com> <CAGBsUrciqGzx=ExPEyoJ4BXi9rGR=+cPa6xBuFppAS_nF7o_qg@mail.gmail.com>
Feedback-ID: 96993444:user:proton
Precedence: bulk
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: internals@gpb.moe ("Gina P. Banyard")

On Tuesday, 30 April 2024 at 22:33, Kamil Tekiela <tekiela246@gmail.com> wr=
ote:

> I see absolutely no reason to do this. There is no difference between
> MySQL and MariaDB in terms of PDO. Sure, the actual RDBMSs have
> differences, but they play no role when it comes to PDO.
> If MariaDB decides to change the protocol some day then we would need
> a new driver to replace mysqlnd. Only then it would make sense to have
> PDO_mariadb extension. But that is unlikely to happen any time soon.
> The purpose of PDO subclasses is to offer driver specific
> functionality and differentiate SQL syntax flavours. MariaDB and MySQL
> use the same driver so they offer the same functionality and they use
> the same SQL syntax (at least the parts that matter). And we must
> remember that MariaDB is not the only MySQL-like DB out there. We are
> not going to create a name alias for every possible fork of MySQL that
> ever exists. It would be pointless.

I agree with Kamil, MariaDB wanting to be incompatible with MySQL is their =
choice.
If we introduce an "alias" and the MariaDB behaviour doesn't work, then we =
are on the hook to "fix" a database driver where we don't have the expertis=
e.
The MySQL driver is intended to only be used with a MySQL database, that it=
 works with MariaDB is just a consequence of them forking from MySQL.
And a user that uses a driver of a different DB than the one they run shoul=
d expect incompatibilities.

If there is a need for a MariaDB driver, then it should live outside the ph=
p-src repo, IMHO.
We already have database drivers that are badly maintained because we don't=
 have the expertise, or only recently acquired people that want to work on =
them.

We removed the interbase and OCI8 extensions from php-src to PECL for this =
exact reason.
Thus adding, effectively, a new database driver makes no sense to me.


Best regards,

Gina P. Banyard