Replace pyodbc with mysql-connector-python - Githubissues

dbeatty10 / dbt-mysql

dbt-mysql contains all of the code enabling dbt to work with MySQL and MariaDB

Apache License 2.0

75 stars 53 forks source link

Replace pyodbc with mysql-connector-python #37

Closed dbeatty10 closed 3 years ago

dbeatty10 commented 3 years ago

Describe the feature

Replace pyodbc with mysql-connector-python.

Describe alternatives you've considered

MySQL-Connector-Python was chosen since it is the official Oracle-supported driver for MySQL.

Here is a (slightly outdated) comparison of dbapi alternatives to pyodbc for MySQL:

MySQL-Python
mysqlclient
OurSQL
MySQL-Connector-Python
PyMySQL

Note: contrary to the image above, MySQL-Connector-Python is available via PyPi.

Who will this benefit?

This lowers the barrier to entry by removing the need for installing MySQL ODBC drivers.