What's Changed

• support local_infile_dir option by @RasmusKard in #755
• update readthedocs conf by @methane in #759
• update mariadb-connector to 3.4.8 by @methane in #773
• add Python 3.14 and drop Python 3.9 by @methane in #774
• update pyproject.toml to support Python 3.14 by @MysticEntity-dev in #772
• free threading: do not enable GIL by @methane in #775
• release v2.2.8 by @methane in #776

New Contributors

• @RasmusKard made their first contribution in #755
• @MysticEntity-dev made their first contribution in #772

Full Changelog: v2.2.7...v2.2.8

Contributors

• @methane
• @RasmusKard
• @MysticEntity-dev

What's Changed

• MariaDB include paths for Win by @CristiFati in #749
• support opentelemetry-instrumentation by @methane in #753

New Contributors

• @CristiFati made their first contribution in #749
• @cazorla19 made their first contribution in #752

Full Changelog: v2.2.6...v2.2.7

Contributors

• @methane
• @cazorla19
• @CristiFati

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

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

Contributors

• @methane
• @nattofriends
• @renovate
• @robertsilen

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

Contributors

• @methane

What's Changed

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

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

Contributors

• @methane

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

Contributors

• @methane

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

Contributors

• @methane
• @renovate
• @davemcphee
• @hamarituc
• @Benjamin-Loison
• @raceybe
• @stegayet

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

Contributors

• @methane
• @piglei
• @renovate
• @thereisnosun
• @mschoettle
• @vsalvino
• @joshuadavidthomas
• @gopackgo90
• @timgates42
• @steveteahan

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

Contributors

• @methane
• @piglei
• @thereisnosun
• @mschoettle
• @vsalvino
• @joshuadavidthomas
• @gopackgo90
• @timgates42
• @steveteahan