Connect to mariaDB via python?

General Discussion
1

Hi there,
I am trying to connect to mariaDB via a python script. As I understand the connector/c and python connector have to be installed to do that. With both of that I have problems to finde the correct package.
What exactly do I have to install to connect to mariaDB and where to find it?
Thank you,

2

Simply put your question into a search engine and following will pop up on first place

3

Hi, thank you.
But not so easy as it seems. There is no package of the mariaDB connector/python for ARM available. Of course someone could compile it for his maschine, but for me as a noob that is always difficult to do.

I was wondering if I could use this connector: mysql-connector-python?

Or do I have to install mariaDB client package in addidtion to the server because the connector might be included?

Thank you again

4

ok I played with it, and I was able to build the python package mariadb.

root@DietPi4:~# pip3 install mariadb
Collecting mariadb
  Using cached mariadb-1.1.6.tar.gz (83 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Collecting packaging
  Using cached packaging-23.0-py3-none-any.whl (42 kB)
Building wheels for collected packages: mariadb
  Building wheel for mariadb (pyproject.toml) ... done
  Created wheel for mariadb: filename=mariadb-1.1.6-cp39-cp39-linux_aarch64.whl size=184023 sha256=62f64037e302da3eb95834904ce104888a1afb6f5d2fa6ba93c667ec200693d9
  Stored in directory: /root/.cache/pip/wheels/83/e7/ce/1de52a1d2177b11c38caee546e67f7ab1bf92ea600124f20c1
Successfully built mariadb
Installing collected packages: packaging, mariadb
Successfully installed mariadb-1.1.6 packaging-23.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
root@DietPi4:~#

however it was necessary to add MariaDB own repository and to install MariaDB Connector/C

Using default settings bumped some components of MariaDB to a higher version

root@DietPi4:/etc/apt/sources.list.d# apt list --upgradable
Listing... Done
libmariadb-dev/unknown 1:10.10.3+maria~deb11 arm64 [upgradable from: 1:10.5.18-0+deb11u1]
libmariadb3/unknown 1:10.10.3+maria~deb11 arm64 [upgradable from: 1:10.5.18-0+deb11u1]
mariadb-common/unknown,unknown 1:10.10.3+maria~deb11 all [upgradable from: 1:10.5.18-0+deb11u1]
mariadb-server/unknown 1:10.10.3+maria~deb11 all [upgradable from: 1:10.5.18-0+deb11u1]
mysql-common/unknown,unknown 1:10.10.3+maria~deb11 all [upgradable from: 5.8+1.0.7]

Maybe MariaDB Connector/Python 1.0 would be enough as it did not have that high requirements compare to MariaDB Connector/Python 1.1