I have a MariaDB table including a JSON field: { arrayOfDates : ['2020-01-11', '2021-01, 12', '2019-03-12'], ... } For each record in my-table I need to extract the field arrayOfDates and pick the min value in the array. Note I'm…
My client wants to upgrade all his websites script from PHP 5.6 to PHP 8 and mysql 5.7.42 to mariadb 10.5. We want to upgrade one by one website. Now the problem is we can choose different PHP version for…
I've compiled and installed Python 3.10.9 (from .tar) and mariadb-c-connector (from official Github repo) on my Debian 11 (bullseye) machine. I also installed: ufw, fail2ban, mariadb-server, mariadb-client. Now if i install mariadb in my Python pipenv and run i got…
Problem I have a stock install of Debian 11 (testing) with a brand new install of MariaDB (10.5.9-MariaDB-1), phpMyAdmin (5.0.4deb2) and Lighttpd (1.4.59). After adding a user and logging in, clicking on any database and the privileges tab renders the…
I have noticed that in my mysql server, the auto_increment setting increments by 3, for example 3 6 9 12 15 etc. All the tables in the database are having the same problem. I'm using mariadb 10.5 on debian 10.…