mariadb-connector-c | MariaDB Connector/C is used to connect applications | SQL Database library

I am trying to connect to MariaDB using a python connector from a linux machine and while doing so I am getting the following error;

furthering my question here, I am trying to put this question in a simpler way.

Following this tutorial, I am trying to start a connection to my Mariadb database in my NAS with SQLalchemy remotely. Here is the code:

I am trying to use the sed command to replace variables during docker build. The variable I am attempting to do (to start) is $DATABASE_HOST. The value for that is coming from my .env file. I am reading online that environment variables are only available during run time if they come from the .env file. Due to this, my sed command is not registering.

Dockerfile:

I don't know how to explain why, but when I run cmake in a directory it works fine. If I go one level up and in the CMakeLists.txt use Add_SubDirectory then it is broken.

I will put the steps down.

1. mkdir MyFolder
2. git clone https://github.com/mariadb-corporation/mariadb-connector-c.git

These steps work to prove that the build works:

1. cd mariadb-connector-c
2. mkdir build && cd build
3. cmake -G Ninja ..
4. ninja

Ok that worked great. So next trying it one level up:

1. cd ../.. (Now located in "MyFolder")
2. Add a CMakeLists.txt with this source.

I have enjoyed success utilizing the MySQL/Connector C libraries within my C application to manipulate a database. Use of the application, however, causes great memory usage, so much in fact that I have had to consider utilizing systemd to manage the application, which I assume will run at startup as a service since it needs to always be active. Rather than obfuscate/add complexity to this any further, I'd like to address the issue within the application.

• System: Raspberry Pi 4B
• OS: Raspbian Buster
• SQL Library: mariadb-connector-c-3.1.7
• Database: MariaDB 10.3.22 server, locally hosted

I typically clear queries that store result sets to my MYSQL_RES object using mysql_free_result(sqlRes). Inserts I keep fairly simple. Everything works correctly from a functional standpoint, but it's memory consumption is just through the roof. I am assuming a lot of this is due to my wait times in the main() looping code, but I want to be able to monitor a UART connection in nonblocking fashion with a host system that communicates at 115.2k.

Is there a best practice I am veering way off course from? A lot of my initial code was developed similar to that outlined here. I have not utilized any memory analysis applications within Raspbian as I am not too familiar with them.

Thanks

I want to connect to a MySQL database, only every time I try I get this error:

As in the title: I have troubles switching to MariaDB when I use Docker.

As long as I launched many different databases locally from my disk (default SQLite, PostgreSQL and MariaDB), every configuration worked fine. SQLite and PostgreSQL work with Docker as well (installation of Postgres' driver goes smoothly), but MariaDB reports issues with fetching MariaDB Connector/C.

Dockerfile:

I tried to install RMySQL package in my Rstudio, and when I tried it, it gave me following error

I was trying to build my project on the gitlab pipeline when I ran into some issues. While running the gitlab-ci.yml in the pipeline on AWS, out of two testing sections, one of them fails on the conan install step.

Successful section: