Which connectors should we support/test

[laurent-indermuehle]

We had an interesesting conversation in #533 about which version(s) of PyMySQL and mysqlclient we should support/test in order to minimize the load on the CI.
I'm opening this discussion/poll to attempt to settle this question.

We test every major release of:

• Ansible
• Mysql
• Mariadb
• Python
  I think it would be fair to also tests every latest major release of our connectors:

PyMySQL https://pypi.org/project/pymysql/#history:

• 0.10.1 <- This happens to be the version I'm interested in the most :)
• 1.0.3

Mysqlclient https://pypi.org/project/mysqlclient/#history:

• 1.4.6 <- branch 1.x has never been tested AFAIK
• 2.1.1

In order to minimize the amount of test containers, I used a different version of each connectors per version of Python:

python 3.8 mysqlclient 2.0.1 pymysql0711 pymysql093
python 3.9 mysqlclient 2.0.3 pymysql093
python 3.10 mysqlclient 2.1.1 pymysql102
So we are not testing every Python with every connectors.
Also, we are soon going to add:

Mariadb 10.11
Mariadb 11.1
Python 3.11
Ansible 2.15

I'm not sure yet how to fill this poll since I'm not fully aware of the difference between pymysql and mysqlclient and who uses which in what use case. Any help to fill the poll would be appreciated.

[laurent-indermuehle]

I'm closing this poll to open a discussion to gather facts and opinions. The poll will come later.