mariadb-connector-python-usage

Pass values as the second argument to execute() using qmark placeholders: cursor.execute("SELECT ... WHERE id = ?", (id,)). The default paramstyle is qmark, not %s, and a single parameter must be a one-element tuple with a trailing comma.

Autocommit is False by default in MariaDB Connector/Python, so uncommitted DML rolls back when the connection closes. Call conn.commit() after DML statements, or open the connection with autocommit=True.

The module is imported as mariadb and uses qmark (?) placeholders by default rather than %s. It is a C-extension DB API 2.0 driver with its own exception hierarchy under mariadb.Error, so code written for MySQL drivers needs adjustment.

Create a pool with mariadb.ConnectionPool(pool_name="app", pool_size=5, ...) and borrow connections via pool.get_connection(). Calling conn.close() returns the connection to the pool; pool_size defaults to 5 with a maximum of 64.

Yes, but the text protocol is the default. Set binary=True on the cursor (conn.cursor(binary=True)) or, since version 2.0, on the connection to switch to the binary protocol with server-side prepared statements.

Cursors are buffered by default, pulling the entire result into memory. For large results, create an unbuffered cursor with conn.cursor(buffered=False) and iterate row by row, noting that scroll() is unavailable on unbuffered cursors.