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 Version||Python (3.6 or later)|
|API||Python DB API 2.0 (PEP-249)|
|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.
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.
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.