Archives: April 2014

Linux: display images type and size in command line

Front-end developers probably often need to verify the properties of some images like their type or their dimensions. To avoid firing Gimp or similar software just for a quick look, GNU/Linux distributions1 offer as usual handy tools like identify, coming from the ImageMagick suite. You can of…

Apache: enable HTTPS

To enable HTTP Secure (HTTPS) on Apache, we first enable the modules called mod_ssl and mod_socache_shmcb in the main Apache configuration file, located at /etc/httpd/conf/httpd.conf: We include SSL own configuration file: In this file, we also set a document root (or keep the default path…

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…