agentlans/python-mariadb repository overview

⁠Python MariaDB Client on Alpine Linux

This Docker image provides a Python interpreter with the MariaDB Connector/Python pre-installed, running on Alpine Linux. It's designed to simplify connecting to MariaDB databases from within Docker containers.

⁠Features

• Python 3.11.11.
• MariaDB Connector C 3.4.4 and its Python connector.
• Alpine Linux: Lightweight and secure base image.

⁠Quick Start

This walkthrough shows how to connect to a MariaDB server using this image. It assumes you have Docker installed. It also assumes you have a MariaDB server running.

⁠1. Start the MariaDB Server

If you don't already have a MariaDB server running, use the agentlans/mariadb-sample⁠ image.

# Create a new network (if not already existing)
docker network create some-network

# Start the MariaDB server with sample data
docker run --detach \
  --network some-network \
  --name some-mariadb \
  --env MARIADB_USER=example-user \
  --env MARIADB_PASSWORD=my_cool_secret \
  --env MARIADB_ROOT_PASSWORD=my-secret-pw \
  --env MARIADB_DATABASE=employees \
  agentlans/mariadb-sample

# Check that the server is running
docker ps -a | grep some-mariadb

⁠2. Run the Client Container

Start the client container, connecting it to the same Docker network as the MariaDB server. This ensures the client can resolve the MariaDB server's hostname.

docker run -it --rm --network some-network agentlans/python-mariadb

⁠3. Connect to MariaDB from Python

Once inside the container, start the Python interpreter:

python3

Then, use the following Python code to connect to the MariaDB server and execute a sample query:

import mariadb
import sys

# Connect to MariaDB Platform
try:
    conn = mariadb.connect(
        user="example-user",
        password="my_cool_secret",
        host="some-mariadb",
        port=3306,
        database="employees"

    )
except mariadb.Error as e:
    print(f"Error connecting to MariaDB Platform: {e}")
    sys.exit(1)

# Get Cursor
cur = conn.cursor()

# List 10 employees whose first name starts with the letter A
cur.execute(
    "SELECT first_name,last_name FROM employees WHERE first_name LIKE ? LIMIT 10",
    ("A%",))

# Print Result-set
for (first_name, last_name) in cur:
    print(f"First Name: {first_name}, Last Name: {last_name}")

# Disconnect
conn.close()

This code connects to the MariaDB server running on the some-mariadb hostname (which resolves within the Docker network), retrieves the first name and last name of 10 employees whose first name starts with "A", and prints the results. Remember to adjust the connection parameters to match your MariaDB server's configuration.

⁠More Information

For detailed information on connecting Python programs to MariaDB, refer to the official MariaDB documentation:

• How to Connect Python Programs to MariaDB⁠