[Paranoid Mode: ON] I think we all agree that the database is the most sensitive element of a site. Installing phpMyAdmin on a server is like exposing this data to everyone, well everyone who knows how to hack phpMyAdmin. Do you have to do without phpMyAdmin? No, it's far too practical, but a minimum of safety must be put in place to sleep soundly.

Yes, we are in 2022 and I'm still using Jenkins and not the hype CI like gitlab or github action. In fact I have just migrated all my old job definition from Phing (it's like Ant but written in PHP) to declarative pipeline. It's faster to run, config file are easier to read and I still keep metrics. Want to know more? Read this article.

After the first post who shows the possibility of the JSON functions with MySQL 8 on a JSON array, let's talk about what we can achieve with a JSON object.

MySQL 8 has introduced an advanced support of JSON type and functions. The documentation is complete for the functions but I found the examples not very helpful and too much theorical. The idea here is to show, with a real, but simplified, database some things we can do with this format. In this first article, we will manipulate a JSON colums containing a simple array.

Today I tell you a little story about MariaDB and Doctrine2 sinking and how Redis, coming to save them, sinks them even faster. Feedback on my setbacks with Redis and Doctrine2 hoping to relieve a MariaDB out of breath.

Once again, I struggled using Ansible module: blockinfile to change multiple sections of the same file. This article is a tips of how to achieve it with Grafana config file.

There isn't an application that is really security proof and will not suffer to a data breach. Encryption of the data is a good approach to reduce data breach impact. In this post, I'm going to show you how to use encryption in PHP with real world case.

This article shows, by example, the usage and syntax of the Symfony2 Expression Language component in service files written in XML or Yaml. This component allows you to add dynamism to configuration files.

In this article, I show how to group its code in a PHP Phar archive. This step a little complicated, is now greatly facilitated by tools available on Github. I illustrate here, the use of clue/phar-dial.

Vim is a great editor on Linux, but unfortunately the usual keyboard shortcuts such as Crtl + F to searh and replace text does not exist. In this tip I explain the command to make a text replacement in VIM.