Code snippets

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

 View the code


This snippet shows how to get the PostgreSQL version. Yes, this is as simple as this. Note that this is the exact same query with ...

postgresql

Published on 2024-01-10 • Modified on 2024-01-13

 View the code


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 create a PostgreSQL database with an associated user of the same name. We create a user then w...

postgres

Published on 2020-05-27 • Modified on 2020-05-27

 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