v2.2.6

What's Changed

• MariaDB Connector/C 3.4 and MairaDB 11.4 had enabled SSL and CA verification by default.
  It affected 2.2.5 windows wheels. This release disables SSL and CA verification by default for backward compatibility. (#731)

• Add server_public_key_path option. It is needed to connect MySQL server with
  sha256_password or caching_sha2_password authentication plugin without
  secure connection. (#744)

Full Changelog: v2.2.5...v2.2.6

v2.2.5

What's Changed

• Support building against Percona Server builds of MySQL client library libperconaserverclient by @nattofriends in #718
• add MariaDB to README and doc by @robertsilen in #720
• Update license metadata by @methane in #722
• chore(deps): update dependency sphinx-rtd-theme to v3 by @renovate in #724
• chore(deps): update dependency sphinx to v8 by @renovate in #716
• ci: update test by @methane in #727
• ci: update MariaDB Connector/C by @methane in #726
• release 2.2.5 by @methane in #728

New Contributors

• @nattofriends made their first contribution in #718
• @robertsilen made their first contribution in #720

Full Changelog: v2.2.4...v2.2.5

v2.2.4

What's Changed

• Support ssl=True by @methane in #700
• release 2.2.4 by @methane in #701

Full Changelog: v2.2.3...v2.2.4

v2.2.3

What's Changed

• fix Connection.kill() broken since 2.2.2 by @methane in #696

Full Changelog: v2.2.2...v2.2.3

v2.2.2

What's Changed

• Support MySQL 8.3 by @methane in #690
  • conn.kill() and conn.shutdown() are deprecated.
• use ruff for formatter by @methane in #691
• doc: add link to README by @methane in #692

Full Changelog: v2.2.1...v2.2.2

v2.2.1

What's Changed

• Connection.ping() avoid using MYSQL_OPT_RECONNECT option until reconnect=True is specified. MySQL 8.0.33 start showing warning when the option is used. (#664)
• Windows: Update MariaDB Connector/C to 3.3.8. (#665)
• Windows: Build wheels for Python 3.12 (#644)

Merged pull requests

• Add build dependency for pkg-config to documentation by @hamarituc in #621
• Support pkg-config libmariadb by @methane in #631
• Update README.md by @raceybe in #633
• chore(python): add Python 3.12 in test matrix by @stegayet in #644
• Update actions/checkout action to v4 by @renovate in #654
• Do not use MYSQL_OPT_RECONNECT as possible. by @methane in #664
• add bash syntax highlighting to README.md by @Benjamin-Loison in #665
• use sphinx-rtd-theme by @methane in #668
• docs: Improve portability of brew prefix by @davemcphee in #667
• chore(deps): update dependency sphinx-rtd-theme to v2 by @renovate in #671
• chore(deps): update actions/setup-python action to v5 by @renovate in #674
• win: update mariadb connector/c to 3.3.8 by @methane in #676
• Release v2.2.1 by @methane in #679

New Contributors

• @hamarituc made their first contribution in #621
• @raceybe made their first contribution in #633
• @stegayet made their first contribution in #644
• @Benjamin-Loison made their first contribution in #665
• @davemcphee made their first contribution in #667

Full Changelog: v2.2.0...v2.2.1

v2.2.0

What's Changed

mysqlclient uses pkg-config since v2.2. You need to configure pkg-config, or manually set envvars.
READ the manual

• Actions: Drop Python 3.6 and add 3.11-dev by @methane in #542
• docs: fix simple typo, portible -> portable by @timgates42 in #547
• Update python_requires to match supported python versions by @gopackgo90 in #543
• Raise ProgrammingError on -inf by @methane in #557
• Swap 3.11-dev for 3.11 in CI by @joshuadavidthomas in #561
• Add CodeQL workflow for GitHub code scanning by @lgtm-com in #565
• ER_BAD_NULL should be IntegrityError. by @methane in #579
• Update windows build workflow by @methane in #585
• Use pkg-config instead of mysql_config by @methane in #586
• Remove uneeded code. by @methane in #512
• Add collation option by @vsalvino in #564
• Start 2.2.0 development by @methane in #587
• Action: Use Ruff by @methane in #588
• Run pyupgrade --py38-plus by @methane in #590
• Update workflows by @methane in #593
• Update Django test workflow by @methane in #594
• CI: Update codeql build. by @methane in #595
• Improved exception handling when importing the module by @piglei in #596
• CI: Fix django workflow by @methane in #597
• Use pyproject.toml by @methane in #598
• Add Cursor.mogrify(). by @steveteahan in #477
• Add ability to customize ssl mode settings by @thereisnosun in #475
• Use src-layout. by @methane in #600
• Discard results without converting them into Python objects. by @methane in #601
• Fix sphinx warnings by @methane in #602
• Release GIL during result.discard() by @methane in #604
• Fix executemany with binary prefix by @methane in #605
• CI: Fix Django test by @methane in #606
• Fix Connection.escape() with Unicode input by @methane in #608
• fix: fix sslmode typo by @mschoettle in #609
• CI: Update Django test workflow by @methane in #610
• Release v2.2.0rc1 by @methane in #607
• CI: Use MariaDB by @methane in #611
• ci: Run django test after our test by @methane in #612
• Configure Renovate by @renovate in #616
• Release v2.2.0 by @methane in #618

New Contributors

• @gopackgo90 made their first contribution in #543
• @joshuadavidthomas made their first contribution in #561
• @lgtm-com made their first contribution in #565
• @vsalvino made their first contribution in #564
• @piglei made their first contribution in #596
• @steveteahan made their first contribution in #477
• @thereisnosun made their first contribution in #475
• @mschoettle made their first contribution in #609
• @renovate made their first contribution in #616

Full Changelog: v2.1.1...v2.2.0

v2.2.0rc1

Important changes

v2.2.0 uses pkg-config instead of mysql_config. You need to install pkg-config to build. You can configure cflags and ldflags manually by setting MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS too.

Cursor.mogrify() is added.

Cursor.executemany implementation now uses mogrify(). Sequencee of scalar value (e.g. executemany("INSERT INTO t (data) VALUES (%s)", [1, 2, 3]) is no more valid args. You need to use sequence of tuple (e.g. [(1,), (2,), (3,)]) instead.

What's Changed

• Actions: Drop Python 3.6 and add 3.11-dev by @methane in #542
• docs: fix simple typo, portible -> portable by @timgates42 in #547
• Update python_requires to match supported python versions by @gopackgo90 in #543
• Raise ProgrammingError on -inf by @methane in #557
• Swap 3.11-dev for 3.11 in CI by @joshuadavidthomas in #561
• Add CodeQL workflow for GitHub code scanning by @lgtm-com in #565
• ER_BAD_NULL should be IntegrityError. by @methane in #579
• Update windows build workflow by @methane in #585
• Use pkg-config instead of mysql_config by @methane in #586
• Remove uneeded code. by @methane in #512
• Add collation option by @vsalvino in #564
• Start 2.2.0 development by @methane in #587
• Action: Use Ruff by @methane in #588
• Run pyupgrade --py38-plus by @methane in #590
• Update workflows by @methane in #593
• Update Django test workflow by @methane in #594
• CI: Update codeql build. by @methane in #595
• Improved exception handling when importing the module by @piglei in #596
• CI: Fix django workflow by @methane in #597
• Use pyproject.toml by @methane in #598
• Add Cursor.mogrify(). by @steveteahan in #477
• Add ability to customize ssl mode settings by @thereisnosun in #475
• Use src-layout. by @methane in #600
• Discard results without converting them into Python objects. by @methane in #601
• Fix sphinx warnings by @methane in #602
• Release GIL during result.discard() by @methane in #604
• Fix executemany with binary prefix by @methane in #605
• CI: Fix Django test by @methane in #606
• Fix Connection.escape() with Unicode input by @methane in #608
• fix: fix sslmode typo by @mschoettle in #609
• CI: Update Django test workflow by @methane in #610
• Release v2.2.0rc1 by @methane in #607

New Contributors

• @gopackgo90 made their first contribution in #543
• @joshuadavidthomas made their first contribution in #561
• @lgtm-com made their first contribution in #565
• @vsalvino made their first contribution in #564
• @piglei made their first contribution in #596
• @steveteahan made their first contribution in #477
• @thereisnosun made their first contribution in #475
• @mschoettle made their first contribution in #609

Full Changelog: v2.1.1...v2.2.0rc1

v2.1.1

What's Changed

• Add module attributes to exception classes. by @methane in #523
• Fix out of range bug by @methane in #538
• Fix docstring for _mysql.connect by @Llewyllen in #540
• Update CI settings by @methane in #541

New Contributors

• @Llewyllen made their first contribution in #540

Full Changelog: v2.1.0...v2.1.1

v2.1.0

What's Changed

• Use unittest.mock instead of mock by @methane in #469
• Actions: Fix pytest args. by @methane in #470
• Actions: Fix measuring coverage by @methane in #471
• Let multi statements be optional by @simlun in #500
• Remove bytes encoder that was specifically for Django 1.11 by @rsiemens in #490
• update remnants of passwd and db also in docs by @ziegenberg in #488
• Better support for building on Windows by @sparkyb in #484
• Fix tests with MySQL 8.0 by @methane in #501
• Windows: Update MariaDB Connector to 3.2.4 by @methane in #508
• set_character_set() sends "SET NAMES" always. by @methane in #509
• Remove escape() and escape_string() from MySQLdb. by @methane in #511
• _mysql: db -> database, passwd -> password by @methane in #513
• Always set MULTI_RESULTS flag by @methane in #515
• Actions: Add Python 3.10 and remove 3.5. by @methane in #516
• Action: Run Django tests by @methane in #519
• Fix typos by @kianmeng in #520

New Contributors

• @simlun made their first contribution in #500
• @rsiemens made their first contribution in #490
• @ziegenberg made their first contribution in #488
• @sparkyb made their first contribution in #484
• @kianmeng made their first contribution in #520

Full Changelog: v2.0.3...v2.1.0