Beginning Databases with PostgreSQL by Neil Matthew and Richard Stones
Sunday, July 17, 2011

A little while back I need to work with a custom framework that used PostgreSQL as its database. In particular, I needed to be able to set the site up on various machines both for testing and deployment purposes. As I had absolutely no experience of working with PostgreSQL, I went looking for a suitable book, and settled on this one. It proved to be an excellent choice. (more…)

Posted by James at 2:31 pm   0 comments

Storing Arrays in a Database Using JSON
Sunday, July 17, 2011

Sometimes you need to store arrays in your MySQL (or other relational) database, but don’t want to spread the information over multiple tables. For instance, I have been working on a CMS for a website, where you need to be able to add a variable selection of images, download links and products to the page configuration. Storing these sets of information in a single field was obviously a far cleaner solution. However, I needed a simple way to encode/decode the data. (more…)

Posted by James at 12:32 pm   0 comments

Using CKEditor with the Zend Framework
Friday, July 15, 2011

At the moment I am working on create a system that allows non-technical users to easily add and edit product pages on one of the website I have developed. Until now, adding or modifying a page has required modifications to the database and/or a PHP script file, along with uploading any new resources, such as images or documents. This has meant in practice that either I or one of the more technically minded people at the client has tended to do these changes. The idea of the new system is that it will allow anyone to add/edit product pages. (more…)

Posted by James at 5:39 pm   0 comments

Latest News
Wednesday, July 13, 2011

Due to some problems with my ISP, I temporarily lost the main GM-RAM website. As I was planning a revamp of the site, I decided not to restore the old version, but put up a simple front page with the basic company details. As a result, you can no longer see in action what has been described in some of the previous posts. I am hoping to put up a new site fairly soon, with content that reflects more accurately the company’s activities.

On another note, blogging has been light this year as I have been distracted by other, non-PHP based projects. However, I intend to put up a few new posts over the next week or so, given that my recent work has involved using PHP and related technologies again.

Posted by James at 6:55 pm   0 comments