http://paul-turner.net What was that again? Wed, 13 Aug 2008 14:49:16 +0000 http://backend.userland.com/rss092 en 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 ... http://paul-turner.net/2008/08/ikea-mobile-phones/ 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 ... http://paul-turner.net/2008/08/installing-php-xcache-on-centos-5/ 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 ... http://paul-turner.net/2008/08/installing-mod_gzip-on-centos-5/ MySQL allows you to export a query directly in to a CSV file that can be opened by Microsoft Excel. This is the basic syntax: select fields from table into outfile '/path/to/file_name.csv' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n'; The export file that is created "file_name.csv" must not ... http://paul-turner.net/2008/06/mysql-export-to-csv/ 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 ... http://paul-turner.net/2008/05/viewing-flickr-as-a-solar-system/ Here's the syntax for creating a UTF-8 database in MySQL as I can never remember it! CREATE DATABASE `databasename` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */; http://paul-turner.net/2008/05/creating-a-mysql-unicode-utf-8-database/ This is the first entry on my new blog! This site is hosted by Web Hosting Buzz. So far I am impressed with the ease of configuration and installation. This WordPress installation was installed by a few simple clicks using their administration tools, saving me from downloading, ... http://paul-turner.net/2008/04/new-domain-and-blog/