On Tuesday, 30 April 2024 at 22:33, Kamil Tekiela <tekiela...@gmail.com> wrote:
> 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 expertise. 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 should expect incompatibilities. If there is a need for a MariaDB driver, then it should live outside the php-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