Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:123243
Precedence: bulk
MIME-Version: 1.0
References: <CAL0xaBFr5E_NC3vBc7Pgk9i8ZRb9wiSa3FvS-mE8UW9HDiGhcw@mail.gmail.com>
 <6b2e7c73-0f21-4d3a-9db8-01184ae120fb@beccati.com>
In-Reply-To: <6b2e7c73-0f21-4d3a-9db8-01184ae120fb@beccati.com>
Date: Wed, 1 May 2024 00:19:09 +0300
Message-ID: <CAL0xaBGTuYMyjwDP=zA+DOEQCqYQFVATduA_ZLj1nr5TUfRQXA@mail.gmail.com>
Subject: [PHP-DEV] Re: Proposal to Create a MariaDB Alias for the MySQL PDO Driver
To: Matteo Beccati <php@beccati.com>
Cc: Saki Takamachi <saki@sakiot.com>, PHP internals <internals@lists.php.net>
Content-Type: multipart/alternative; boundary="000000000000e4e638061756eddd"
From: arvids.godjuks@gmail.com (Arvids Godjuks)

--000000000000e4e638061756eddd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, 30 Apr 2024 at 21:32, Matteo Beccati <php@beccati.com> wrote:

> Hi Arvids,
>
> <snip>
>
> It's not clear to me what divergences need to be addressed at the PDO
> level at this point. Could you please shed some light?
>
> Is it just identification? If so, I think the best place to do it is
> some user-land configuration.
>

I'm no expert in the matter, but here's some stuff I found:
https://aws.amazon.com/compare/the-difference-between-mariadb-vs-mysql/#sum=
mary-of-differences-mysql-mariadb
https://www.cloudways.com/blog/mariadb-vs-mysql/#mariadb-vs-mysql

One thing that comes to mind that I run into is that both have a different
set of functions they support to work with JSON objects and they store them
differently.
As time goes on, there are more and more database specific differences.
Again, this is about giving people ability to develop stuff based on PDO
driver subclass, clearly delineating what is supported for what database.
You will not have to look at the code and try to figure out if this works
in MySQL or MariaDB or both - you will be able to see that it uses either
MySQL driver or MariaDB driver.
As far as PDO development goes, it's more of an organisational change.
Larry has given a pretty clear explanation why it's good to have this.
--=20

Arv=C4=ABds Godjuks
+371 26 851 664
arvids.godjuks@gmail.com
Telegram: @psihius https://t.me/psihius

--000000000000e4e638061756eddd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Tue, 30 Apr 2024 at 21:32, Matteo =
Beccati &lt;<a href=3D"mailto:php@beccati.com">php@beccati.com</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Arvids,<br=
>
<br>&lt;snip&gt;<br>
<br>
It&#39;s not clear to me what divergences need to be addressed at the PDO <=
br>
level at this point. Could you please shed some light?<br>
<br>
Is it just identification? If so, I think the best place to do it is <br>
some user-land configuration.<br>
</blockquote></div><br clear=3D"all"><div>I&#39;m no expert in the matter, =
but here&#39;s some stuff I found:=C2=A0<a href=3D"https://aws.amazon.com/c=
ompare/the-difference-between-mariadb-vs-mysql/#summary-of-differences-mysq=
l-mariadb">https://aws.amazon.com/compare/the-difference-between-mariadb-vs=
-mysql/#summary-of-differences-mysql-mariadb</a></div><div><a href=3D"https=
://www.cloudways.com/blog/mariadb-vs-mysql/#mariadb-vs-mysql">https://www.c=
loudways.com/blog/mariadb-vs-mysql/#mariadb-vs-mysql</a><br></div><div><br>=
</div><div>One thing that comes to mind that I run into is that both have a=
 different set of functions they support to work with JSON objects=C2=A0and=
 they store them differently.</div><div>As time goes on, there are more and=
 more database specific differences.=C2=A0</div><div>Again, this is about g=
iving people ability to develop stuff based on PDO driver subclass, clearly=
 delineating=C2=A0what is supported for what database. You will not have to=
 look at the code and try to figure out if this works in MySQL or MariaDB o=
r both - you will be able to see that it uses either MySQL driver or MariaD=
B driver.</div><div>As far as PDO development goes, it&#39;s more of an org=
anisational change. Larry has given a pretty clear explanation why it&#39;s=
 good to have this.</div><span class=3D"gmail_signature_prefix">-- </span><=
br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div><br></d=
iv>Arv=C4=ABds Godjuks<div>+371 26 851 664</div><div><a href=3D"mailto:arvi=
ds.godjuks@gmail.com" target=3D"_blank">arvids.godjuks@gmail.com</a></div><=
div>Telegram: @psihius=C2=A0<a href=3D"https://t.me/psihius" target=3D"_bla=
nk">https://t.me/psihius</a></div></div></div></div>

--000000000000e4e638061756eddd--