Category Archives: MySQL

CakePHP 2.0 AJAX sortable list that updates to databases

Posted on November 7, 2011 by Richard

It is easy to create an AJAX sortable list with CakePHP 2.0, using jQuery that automatically updates the database, however it is hard to find documentation explaining how to do it. Here is my explanation – it assumes a basic … Continue reading →

Posted in MySQL, PHP | 3 Comments

Blog Tutorial with CakePHP Framework

Posted on October 5, 2011 by Richard

In a follow up to my previous article: blog tutorial with Fat-Free Framework I have tried to make exactly the same application but using the CakePHP Framework – to contrast using a micro-framework with a fully featured one. CakePHP works … Continue reading →

Posted in MySQL, PHP | Leave a comment

Blog Tutorial with Fat-Free Framework

Posted on September 30, 2011 by Richard

I recently read an excellent tutorial on ‘Rapid Application Prototyping in PHP Using a Micro Framework‘, this used the Slim micro framework but one thing that bothered me was it required 5 packages before development could start. These were: Slim … Continue reading →

Posted in MySQL, PHP | 5 Comments

MySQL 5.1 Partitioning and the Key Cache

Posted on February 16, 2010 by Richard

User-defined partitioning looks like it is set to be a useful feature in MySQL. It allows you to distribute portions of individual tables across a file system according to rules which you can set largely as needed. I was looking … Continue reading →

Posted in MySQL | Leave a comment

IUS MySQL – how to enable the Archive storage engine

Posted on January 14, 2010 by Richard

IUS is a great way of getting more recent versions of PHP and MySQL onto a Red Hat Enterprise Linux (RHEL) or Centos server than are normally available – without the trouble of having to compile them yourself. Here is … Continue reading →

Posted in MySQL | 1 Comment