Symfony / PHP / JavaScript / Vue.js / Docker / Devops...

Less chitchat... more code.

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 ™.

Tags  PHP (115)  Symfony (111)  JavaScript (24)  array (22)  Doctrine (20)  Twig (20)  string (20)  Debug (18)  Docker (17)  Validation (14)  Docker compose (14)  Form (13)  date (13)  random (10)  GIT (10)  html (10)  bash (10)  MySQL (9)  Routing (8)  DevOps (8)
» View all tags » Run the "SQL" search on all the site.

Activating and inspecting MySQL or MariaDB logs

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

... by COil
 MySQL  mariadb  Logs  data  Debug

Getting the PostgreSQL version

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

... by COil
 postgresql  version  query  select

Getting the MySQL or MariaDB version

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

... by COil
 MySQL  mariadb  version  query  select

A better Docker MySQL heathcheck

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

... by COil
 Docker  Docker compose  MySQL  container  service  bash

Checking if the MySQL service of a Docker container is ready

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

... by COil
 Docker  Docker compose  MySQL  container  service  bash

Creating a Postgres database with an associated user of the same name

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

... by COil
 postgres  SQL  Database

Randomizing MySQL query results

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

... by COil
 MySQL  SQL

Using a regexp in a MySQL query

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

... by COil
 MySQL  SQL  regexp

Running raw SQL queries with Doctrine

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

... by COil
 Doctrine  SQL  Symfony  MySQL

Docker compose file for MySQL 5.7

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

... by COil
 Docker  Docker compose  MySQL  Database