Code snippets

You will find here 8 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 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

 View the code


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

 View the code


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

 View the code


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

 View the code


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

 View the code


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

 View the code


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

 View the code


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

 View the code