Author Archive
Recently I wrote about installing mod_gzip on CentOS 5. However since then I have discovered that Internet Explorer 6 has does not support this properly, and intermittently does not load items properly! To resolve this I had to change the Apache configuration. This is the configuration that I am now using: 123456AddOutputFilterByType DEFLATE text/html text/plain […]
August 22nd, 2008 | Posted in Apache | 2 Comments
Ikea has launched its own mobile phone service called Family Mobile (which piggybacks on the T-Mobile network). This is “pay as you go” service offering very competitive rates when compared to other UK providers. Basically it is a flat rate of 9p per minute whether you are calling a land line or another mobile phone, […]
August 13th, 2008 | Posted in Uncategorized | 1 Comment
XCache is a PHP opcode cacher, which basically means that it will cache the compiled code the first time a PHP page/script is executed thus avoiding the compilation step on subsequent executions. I used the 1.2.2. release of XCache and followed the quick guide instructions to install from source. The installation requires that the php-devel […]
August 11th, 2008 | Posted in Apache, PHP | No Comments
CentOS 5 is packaged with Apache 2 which is not compatible with mod_gzip. The module mod_deflate is the Apache 2 equivalent. Installing mod_deflate on CentOS 5 is a fairly simple process. The module is included in CentOS 5 and just need to be configured. The only changes required are to the Apache configuration file /etc/httpd/conf/httpd.conf. […]
August 1st, 2008 | Posted in Apache | 4 Comments
Saving the results of a MySQL query in a format that Excel can use
June 2nd, 2008 | Posted in MySQL | No Comments
Flickr is possibly the largest collection of public photos on the planet. Flickr has an API which allows anyone with some programming skills to write their own programs and websites, etc using their images and data. Yesterday I came across the http://taggalaxy.de/ which allows you to view Flickr as a solar system. You search for […]
May 30th, 2008 | Posted in Photography | 1 Comment
Here’s the syntax for creating a UTF-8 database in MySQL as I can never remember it! 1CREATE DATABASE `databasename` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
May 3rd, 2008 | Posted in MySQL | No Comments