mariadb-connector-python-usage

MariaDB-specific behavior of MariaDB Connector/Python (the mariadb PyPI module, a PEP-249 / DB API 2.0 driver) for application code — that the default paramstyle is qmark (?), not format (%s), and styles must not be mixed; that string formatting must never build SQL; that autocommit is off by default so DML needs conn.commit(); that a single parameter needs a one-tuple (v,); that the text protocol is default and binary=True switches to server-side prepared statements; that cursors are buffered by default; connection pooling via ConnectionPool (default size 5, max 64); callproc() for stored procedures; and the DB API exception hierarchy under mariadb.Error. Use when writing or reviewing Python code that talks to MariaDB with the mariadb module.