Connector/Python

Complete Connector/Python guide: DB API 2.0 (PEP-249) implementation, MariaDB/MySQL connectivity, C+Python architecture, and Connector/C transport.

MariaDB Connector/Python

MariaDB Connector/Python enables python programs to access MariaDB and MySQL databases, using an API which is compliant with the Python DB API 2.0 (PEP-249).

Contents

Contents:

• Installation

  • Prerequisites

  • Installation Options

  • Installation from Source

  • Test suite

• Basic usage

  • Connecting

  • Passing parameters to SQL statements

• Async/Await Support (New in 2.0)

  • Basic Async Connection

  • Async Connection Pools

  • FastAPI Integration

• Connection pooling

  • Synchronous Connection Pool

  • Asynchronous Connection Pool

• Migration Guide (1.1 to 2.0)

  • Breaking Changes

  • New Features

  • Migration Checklist

• API Reference

  • The MariaDB Connector/Python module

  • The connection class

  • The cursor class

  • The ConnectionPool class

  • Constants

• License

  • MariaDB Connector/Python

  • MariaDB Connector/Python documentation

• Bug reports

  • How to report a bug?

• MariaDB Connector/Python FAQ

  • Installation

  • Connecting

  • General

  • Transactions