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?
Simply put your question into a search engine and following will pop up on first place
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
ok I played with it, and I was able to build the python package
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