Latest posts

Upgrade Apache to 2.4 from 2.2 on Arch Linux, using PHP-FPM

Since the first article, more than six weeks ago, Apache has been updated to version 2.4.9 which allows for a simpler configuration with php-fpm, mod_proxy_fcgi and mod_proxy_handler. The following setup does not use mod_php, which requires mod_mpm_prefork and ProxyPassMatch directives as shown…

Governments all over the world try to control and use Internet against their people as a tool of mass surveillance. Instead, it should be considered as our common good. Universal access should be the top priority and Net Neutrality protected at all cost. Here is the direct link to the petition.

MariaDB / MySQL: generate a row number

There is currently no built-in method to return row numbers. The solution is to use a variable which is incremented in each row, like this: @currentRow := @currentRow + 1 AS rowNumber We can use a JOIN statement to initialise the variable without SET: JOIN (SELECT @currentRow := 0) row Another…

The Pitivi team still needs our help for bringing their simple to use open source video editor to a professional level. The campaign has past half of its goal and counting...

La Quadrature Joins the Legal Struggle Against Mass Surveillance

La Quadrature du Net joins the legal struggle against mass surveillance. Most so-called democratic western governments are trying to legalise massive surveillance under the pretence of fighting terrorism and child abuse.