Category: SQL
SQL for beginners
October 4th, 2012There are plenty of articles on how to get going with SQL (or MySQL) for beginners. However, there aren’t many articles which take you back to basics describing the building blocks used and help you understand the concept of what a database actually is.… more »
Installing VirtualBox, CentOS 5.4, Apache, PHP and MySQL
September 11th, 2012I've recently done a project that uses load balancing. mod_proxy is a blog for another day but it was based on a LAMP stack. I install this all the time for lots of different projects. Some are development projects and some are just system administratio… more »
MantisBT Database Tweaker
March 27th, 2012I've been using Mantis for a couple of years. I run a small company and so have to be extremely flexible. As a result I need to tweak the database to do tasks that are not available using the Mantis front end.
The trouble with editing the bugs and bu… more »
Small comparison of PHP Frameworks
October 11th, 2011I'm working on a PHP web site and I want to add a user authentication component. In the past I've written hundreds of these things and couldn't be bother to write the same code all over again. You know the story: create user table in the database, add a… more »
Useful B2Evolution SQL
September 20th, 2011While B2Evolution's search and back office interfaces are excellent they cater for the general use case. Search is a good example of this as there are many things to search for but a limited amount of search criteria in the interface. There are also tas… more »

