Educating the world

Our blog has over 10,000 readers a month

Category: "SQL"

SQL for beginners

October 4th, 2012
There 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, 2012
I'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, 2012
I'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, 2011
I'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, 2011
While 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 »