---
title: "Announcing MariaDB Connector/Python 1.1 GA"
publish_date: 2022-07-05
author: "Georg Richter"
tags:
  - name: "MariaDB Connector/Python"
    url: "/resources/blog/tag/mariadb-connector-python.md"
  - name: "Python"
    url: "/resources/blog/tag/python.md"
---

# Announcing MariaDB Connector/Python 1.1 GA

We are pleased to announce MariaDB Connector/Python 1.1 as GA (Generally Available).

MariaDB Connector/Python, compliant with the Python DB API 2.0, is a MariaDB connector for building Python applications on MariaDB. Python is one of the most popular programming languages among developers across a variety of technical areas. In the [2022 Stack Overflow Developer Survey](https://survey.stackoverflow.co/2022/#section-most-loved-dreaded-and-wanted-programming-scripting-and-markup-languages) of over 70,000 developers, Python was identified as the most wanted technology (tied with Rust) when it comes to programming, scripting and markup languages. MariaDB Connector/Python is now written in Python and C, and integrates functionality from MariaDB Connector/C for optimized client/server communication.

The Release Series 1.1 of Connector/Python is now available via the [Python Package Index (PyPI) repository](https://pypi.org/project/mariadb/) and the [MariaDB Downloads](https://staging-mdb.com/downloads/connectors/connectors-data-access/python-connector).

MariaDB Connector/Python 1.1 includes the following new features:

**General**:

- Connection, cursor and connection pool classes are implemented in pure Python for easier extension or modification.
- Cursor.execute() method now returns a buffered result set by default.
- Statements without parameter substitution are now executed in text protocol by default, which results in lower overhead and therefore better performance.
- Parameter substitution now works inside conditional comments.

**New constants**:

- ERR constants for better error handling.
- STATUS constants for checking the MariaDB Server (Community and Enterprise) status.
- CLIENT constants for checking the MariaDB Server and MariaDB Client capabilities.

**New methods and attributes**:

- Connection 
    - Methods 
        - begin() – Starts a new transaction
        - select\_db() – Sets the default database
        - dump\_debug\_info() – Forces MariaDB Server (Community and Enterprise) to log status information
    - Attributes 
        - client\_capabilities – Returns the MariaDB Client capabilities
        - server\_capabilities – Returns the MariaDB Community Server/MariaDB Enterprise Server capabilities
        - open – indicates if the connection to MariaDB Server (Community and Enterprise) is still alive
        - server\_status – returns the status attributes of MariaDB Server (Community and Enterprise)
- Cursor 
    - Attributes 
        - Description now contains as an extension to the PEP-249 DB API with additional items table\_name, original\_column\_name and original\_table\_name
        - paramcount – Returns the number of parameters for the last executed statement
- ConnectionPool 
    - Attributes 
        - connection\_count – Returns number of connections in pool
        - reset\_connection – If set to true, the connection will be reset on both client and server side after .close() method was called

MariaDB Connector/Python is available from the [MariaDB Download page](https://staging-mdb.com/downloads/connectors/connectors-data-access/python-connector) and from the [Python Package Index (PyPI) repository](https://pypi.org/project/mariadb/).

[MariaDB Connector/Python Documentation](https://staging-mdb.com/docs/connect/programming-languages/python/) details how to install the connector, with examples on how to use the connector. Documentation is also available for using [MariaDB Connector Python to connect to MariaDB SkySQL](https://staging-mdb.com/products/skysql/docs/connect/programming-languages/python/connect/#connect-with-mariadb-connector-python). Sample applications exist on our [MariaDB Developer Hub](https://staging-mdb.com/developers/).

##### Resources

- [Python Package Index (PyPI) repository ](https://pypi.org/project/mariadb/)
- [MariaDB Downloads](https://staging-mdb.com/downloads/connectors/connectors-data-access/python-connector)
- [MariaDB Connector/Python Documentation](https://staging-mdb.com/docs/connect/programming-languages/python/)
- [Connect to SkySQL with MariaDB Connector/Python](https://staging-mdb.com/products/skysql/docs/connect/programming-languages/python/connect/#connect-with-mariadb-connector-python)
- [MariaDB Developer Hub](https://staging-mdb.com/developers/)
- [Blog Post – How to connect Python programs to MariaDB](https://staging-mdb.com/de/resources/blog/how-to-connect-python-programs-to-mariadb/)