• drapeau français
  • System administration (8)
  • Database (12)
  • Diverse (1)
  • Development (21)

Index document in Elasticsearch using PHP library: elasticsearch-php

  • Mar 8, 2023
  • Development
  • PHP, Symfony, Elasticsearch
Elasticsearch logo

In previous post, I show how to manage indices in Elasticsearch using elasticsearch-php library. In this post, I will show how to index document with this library. Read the post

Manage Elasticsearch indices with elasticsearch-php library

  • Feb 1, 2023
  • Development
  • PHP, Symfony, Elasticsearch
Elasticsearch logo

I already wrote on this blog about elasticsearch-php library maintained by Elastic, the firm that created Elasticsearch. It's my first choice when I need to add Elasticsearch to a project. This library wrap the whole REST API of Elasticsearch including indices management and this is the subject of this post. How to manage indices with elasticsearch-php. Read the post

Using Behat to write functional test of a Symfony command

  • Jan 12, 2023
  • Development
  • PHP, Symfony
Symfony logo

Behat is a well known test behavior framework, used on many project. I always used it to validate webpage or API behavior. In this blog post, I will show you how to setup Behat to use it for testing Symfony command. Read the post

Use Ansible to change dependency in Debian package

  • Oct 20, 2022
  • System administration
  • Debian, Linux, Ansible
Ansible logo

Install software on Debian or Ubuntu is very easy with .deb package file. But sometimes dependencies can't be resolved and software install failed. Most of the time it's possible to fix this issue by editing the dependencies list. Because command are long and ambigous I propose here an Ansible role to achieve it. Read the post

Backup strategy and script of MySQL and versioning tool for dev machine

  • Aug 3, 2022
  • System administration
  • Debian, Linux, Shell, Backup

One of my first articles on this blog dealt with backing up MySQL databases on a production server. Today, I offer you a variation of this article and the script to save your PC or development server (mysql, svn, git). Read the post

Managing parentheses with the Doctrine 2 ORM QueryBuilder

  • Aug 3, 2022
  • Development
  • MySQL, PHP, Symfony, Doctrine
Doctrine logo

To change a small snippet on Doctrine 2 ORM to learn how to handle parentheses in the WHERE clause of an SQL query. Read the post

How to unban an IP with fail2ban

  • Aug 3, 2022
  • System administration
  • Debian, Linux, Security, Fail2ban

My first reminder of the blog: how to unban an IP that Fail2Ban wrongly banned. This happens to me a lot right now and I never remember the exact command line to reauthorize an IP. Read the post

Using Explain function of MySQL to optimize query

  • Jun 14, 2022
  • Database
  • MariaDB, Performance, MySQL
MySQL logo

When database queries are slow a good approach is to use EXPLAIN to get the execution plan of the queries. But the result is not always obvious. In this post I show you how I use EXPLAIN to solve a real performance issue. Read the post

Which tool to choose to use Elasticsearch in a Symfony project

  • May 17, 2022
  • Development
  • PHP, Symfony, Elasticsearch
Elasticsearch logo

How to use Elasticsearch in a Symfony project? Which librairy or bundle to choose? I often read these questions on community slack. I'm not going to write a complete guide, but I give you my point of view on different tools I used in the past or still use. Read the post

Securing phpMyAdmin on Debian

  • May 10, 2022
  • System administration
  • Fail2ban, Linux, MySQL, PhpMyAdmin, Debian
Debian logo

[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. Read the post

Older posts

Share

Search

Recent posts

  • Index document in Elasticsearch using PHP library: elasticsearch-php
  • Manage Elasticsearch indices with elasticsearch-php library
  • Using Behat to write functional test of a Symfony command

Tags

Debian Doctrine Fail2ban Jenkins Linux MariaDB Security MySQL Performance PHP PhpMyAdmin OOP RabbitMQ Backup Shell Symfony VIM Elasticsearch Ansible