<div dir="ltr"><div>One more note:  Not all MySQL / MariaDB installations support transactions, which we use heavily (and rely on?)<br></div><div><br></div><div><a href="https://docs.djangoproject.com/en/2.2/topics/db/transactions/#transactions-in-mysql" target="_blank">https://docs.djangoproject.com/en/2.2/topics/db/transactions/#transactions-in-mysql</a></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 11, 2019 at 3:55 PM David Davis <<a href="mailto:daviddavis@redhat.com" target="_blank">daviddavis@redhat.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Two plugins are currently running into issues trying to support mariadb/mysql. The pulp_ansible plugin is interested in adding full text search and JSONFields. Meanwhile, the pulp_python plugin is trying to store emojis in text which mariadb/mysql doesn't handle well since it uses 3-byte utf-8 by default[0]. Given such cases, I wonder if we'd be better served by dropping mariadb/mysql support and going with Postgresql only. Gitlab recently came to a similar conclusion[1].<div><br></div><div>I personally am hesitant to give up being database agnostic but we already don't support sqlite. Also, I see some advantages like utilizing several Postgresql-only features like extra field types, full text search, etc. Also, supporting multiple databases means we'll likely have to write db specific code in some places or have plugins that only work with certain database types.</div><div><br></div><div>Thoughts?<br><div><br></div><div>[0] <a href="https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434" target="_blank">https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434</a></div><div>     <a href="https://code.djangoproject.com/ticket/18392" target="_blank">https://code.djangoproject.com/ticket/18392</a><br clear="all"><div><div dir="ltr" class="gmail-m_-7856562874949260500gmail-m_7512431652177882813gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>[1] <a href="https://about.gitlab.com/2019/06/27/removing-mysql-support/" target="_blank">https://about.gitlab.com/2019/06/27/removing-mysql-support/</a></div><div><br></div><div>David<br></div></div></div></div></div></div></div></div></div></div></div>
_______________________________________________<br>
Pulp-dev mailing list<br>
<a href="mailto:Pulp-dev@redhat.com" target="_blank">Pulp-dev@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/pulp-dev" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/pulp-dev</a><br>
</blockquote></div>