Code snippets
You will find here 9 code snippets I find useful so I don't have to Google ™ or Stackoverflow ™ them when I need. There are also code snippets I always forget! 😁 Sometimes, related links to the code will be available. The main difference with other random snippets you will find on the web is that in most cases (for the Symfony related ones) you will be able to run them directly from this website to check the output so you can verify it works as expected ™.
This snippet shows how to activate and inspect MySQL or MariaDB logs. For example, This is useful for checking the queries run by ...
MySQL
Published on 2024-07-20 • Modified on 2024-07-20
This snippet shows how to obtain the MySQL or MariaDB version. Yes, this is as simple as this. Note that this is the exact same qu...
MySQL
Published on 2024-01-06 • Modified on 2024-01-06
When you use a database container for MySQL, you start the service by calling docker-compose up -d db. But, if you run a Symfony c...
Docker
Published on 2021-02-06 • Modified on 2021-02-06
In the previous snippet, we saw how to do it for a Postgres service; now it's for MySQL. The process is similar, but there is a sl...
Docker
Published on 2020-09-03 • Modified on 2020-09-03
In this snippet, we will see how to randomize MySQL query results. On this website, I am using this functionality for the random ...
MySQL
Published on 2020-01-27 • Modified on 2020-01-27
In this snippet we will see how to use a regexp to select data in a MySQL query. First in the where clause we declare the column t...
MySQL
Published on 2020-01-18 • Modified on 2020-01-18
In this snippet we will see how to run raw SQL queries via the Doctrine DBAL connection instance. In the first example, we prepare...
Doctrine
Published on 2020-01-16 • Modified on 2020-01-16
This is the docker compose file I am using for MySQL 5.7. As this is an official image, there should't be any problem. Before I wa...
Docker
Published on 2019-09-26 • Modified on 2019-09-26
This is my first step to learn Docker in 2019 😊. This snippet comes from a Tweet of @pierstoval. I was bluffed as it was indeed re...
Docker
Published on 2019-02-12 • Modified on 2019-02-12