mariadb | Development repository for the mariadb cookbook | Infrastructure Automation library

What am I trying to do?

Django does not support setting enum data type in mysql database. Using below code, I tried to set enum data type.

Error Details

_mysql.connection.query(self, query) django.db.utils.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL, created_at datetime(6) NOT NULL, user_id bigint NOT NULL)' at line 1")

Am I missing anything?

Enumeration class with all choices

This is what i get after i use ddev start on new or any other projects. I clear all docker images, volumes, etc... and problem repeats again...

Does anybody has the same problem, does it have any connection with versions:

• Docker version 20.10.11
• Docker Compose version 2.2.0
• ddev version v1.18.0

To access localhost from my local machine during the development of a Symfony web app.

• WSL2 running on Windows 10
• Linux, Apache2, MySQL, PHP-7.4 stack (with Xdebug3 intalled)
• Debian 10
• Symfony 5.4 (although not sure on if relevant to this problem)

• Set up WSL2 according to this Microsoft WSL2 tutorial
• Set up LAMP stack according to this Digital Ocean tutorial
• Set up Symfony according to this Symfony tutorial
• Run the following bash script on startup to start my services and set the host to the virtual WSL IP in my xdebug.ini file

As we all know, the ORDER BY clause is processed after the SELECT clause, so a column alias in the SELECT clause can be used.

However, I find that I can’t use the aliased column in a calculation in the ORDER BY clause.

I'm trying to get MariaDB4J working on my new M1 MacBook Pro, and I'm not doing so great.

I am running the Arm versions of both libssl@1.1 and mariadb 10.6.4, both installed with Homebrew.

First I had issues with libssl not finding libssl, it had to have 1.0, so i installed symlinks from the 1.0 path the library expects to the homebrew 1.1 destination. According to various issue threads on the mariadb GitHub page this should work.

So, it indeed resulted in that libssl was found, but now I get another issue in the logs:

"Reason: tried: '/usr/local/opt/openssl/lib/libssl.1.0.0.dylib' (mach-o file, but is an incompatible architecture (have 'arm64', need 'x86_64'))"

So, I guess that something/mariadb4j expects the x86 version of libssl but I have arm? I'm not sure how to sort this out, so hoping that someone got this to work on M1. Pointers appreciated.

PostgreSQL allows rows to be sorted by arrays. It compares the first value of each array, then the second value and so on (fiddle):

I have a query which is supposed to find matching rows ignoring case and special characters that may be present both in the query and the corresponding column. For that I use REGEXP_REPLACE like this:

I have overtaken an internal software tool from a former employee at our company that is written in NodeJS and is connected to a salesforce shop system currently.

Unfortunately, I'm relatively new to NodeJS and my job currently is to connect the tool to a new shopware 6 (sw6) system and have all the functionality mapped to the new shop system which are for example creating job postings on the shop system.

I have checked and established a connection to the sw6 in an isolated manner but I'm failing to have a job posted on the sw6 system end-2-end, beginning from the Jobposting form in the internal software tool to having a landingpage in the shop system for the created job.

I may share you the code of the function that I'm trying to adjust:

I have a table with the following structure (and sample data):

I need to get the most recent entry of every (non-unique) identifier, but at most one per identifier.

The SQL-Query (MariaDB) that seems to fulfill my problem is the following: