Connector Python GA


With millions of developers worldwide, Python is one of the most popular language choices among Data Scientists and web developers, and now MariaDB Platform can be accessed with a native MariaDB Connector, written in C for optimal performance. Generally available (GA) today, MariaDB Connector/Python adheres to a Python DB API 2.0 (PEP-249) compliant API and supports all MariaDB features. Version 1.0.0 of Connector/Python is available at MariaDB Downloads.


MariaDB Connector/Python at-a-glance

Programming Language Python
Programming Language Version Python (3.6 or later)
API Python DB API 2.0 (PEP-249)
Supports TLS Yes
Supports Connection Pools Yes
License GNU Lesser General Public License v2.1


Extending Access to Analytics

Connector/Python not only connects you to the transactional capabilities of MariaDB Server, but the rich ecosystem of MariaDB Platform technologies  – including columnar storage, write-optimized storage, load balancing and high availability  – all with a familiar SQL interface.

Step-by-step instructions are available to connect to MariaDB with MariaDB Connector/Python, both on-premises and in the cloud through MariaDB SkySQL DBaaS to perform interactive, ad hoc queries on hundreds of billions of rows with standard SQL from your Python app.

On-premises, MariaDB ColumnStore is available as a pluggable storage engine with MariaDB Enterprise Server 10.4 and today with MariaDB Community Server 10.5.

SkySQL provides Analytics and Smart Transactions (hybrid transactional and analytical systems) based on ColumnStore as standard offerings.

And with ColumnStore on-premises or in the cloud, the door is open for low-cost data warehousing and scalable analytics storage using S3-compatible cloud storage.

Sample App

While Python is used by Data Scientists for data wrangling, not every Python developer has experience wiring up a database app. To get you started, we’ve made available a sample app backed by MariaDB SkySQL.

More Information