Writing and media

This page lists my writing for other publications, as well as media appearances – updated November 2017.

TV

• I appeared on Free Spirit in a piece on the Ethical Co-op

MariaDB

I am employed part-time by the MariaDB Foundation, and do the majority of edits on the MariaDB Knowledge Base and also write on mariadb.org

Books

• The book Mastering MySQL 4, which I slaved over from April to November 2002, was published 22 December 2002 by Sybex. You can find more details on Amazon.com, Barnes and Noble and the Sybex website. The book was also translated as La Biblia de MySQL, published by Anaya Multimedia, in October 2003, into Lithuanian as Vadovas MySQL, and into Mandarin as something I can’t pronounce. Details of the Spanish version are on Amazon and All Computer Books.

IOL Technology

• World’s fastest internet connection unveiled – July, 2007
• eNaTIS hack attack: DoT denying the undeniable – July, 2007
• Vodacom comes out firing in broadband price war – March, 2007
• Running Kubuntu Edgy Eft – December, 2006

PHPBuilder

• An Introduction to PEAR’s Validate Package – July, 2006
• More about PEAR’s Image_Graph – June, 2006
• An Introduction to Graphs Using PEAR’s Image_Graph Package – May, 2006
• Preventing spam when using PHP’s mail function – April, 2006
• phpwiki – The Wiki for PHP Developers – March, 2006
• b2evolution – a comprehensive blogging engine – February, 2006
• Gregarius – an RSS/Atom Feed Reader – January, 2006
• What’s new in PHP 5 and PHP 6 – December, 2005
• Reading RSS feeds in PHP: Part 2 – November, 2005
• Reading RSS feeds in PHP: Part 1 – October, 2005
• Database Abstraction in PHP – September, 2005
• Fundamentals of PHP Superglobals – August, 2005
• Secure programming with PHP – July, 2005
• Using cURL with PHP – May, 2005

Database Journal

• A Database Journal Guide to MySQL 5 Certification: The DBA Stream – August, 2006
• A Database Journal Guide to MySQL 5 Certification – June, 2006
• MySQL – today’s contender – May, 2006
• Connecting and prepared statements with the mysqli extension – April, 2006
• MySQL 5.1 – the next generation – March, 2006
• Pressure on MySQL increases as Oracle purchases Sleepycat, with more to come – February, 2006
• Date and Time in MySQL – January, 2006
• MySQL Stored Functions – December, 2005
• Oracle’s purchase of InnoDB, their release of Oracle Express, and the effect on MySQL – November, 2005
• MySQL Stored Procedures: Part 3 – October, 2005
• MySQL Stored Procedures: Part 2 – September, 2005
• MySQL Stored Procedures: Part 1 – August, 2005
• MySQL Oddities – July, 2005
• MySQL 5 Storage Engines – June, 2005
• A Database Journal Guide to MySQL Certification: Part 2, Professional Certification – May, 2005
• A Database Journal Guide to MySQL Certification: Part 1, Core Certification – April, 2005
• Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS’ – March 2005
• The HAVING and GROUP BY SQL clauses – February 2005
• MySQL Query Browser – January 2005
• MySQL Administrator – December 2004
• MySQL Subqueries – November 2004
• MySQL Backups – October 2004
• MySQL Transactions, Part III – BDB Tables, Table locking and Savepoints – September 2004
• MySQL Transactions, Part II – Transaction Isolation Levels – August 2004
• Transactions in MySQL – July 2004
• Optimizing the mysqld variables – June 2004
• Database replication in MySQL – May 2004
• MySQL, Still tomorrows contender? – April 2004
• Restoring lost data from the Binary Update Log – March, 2004
• An introduction to MySQL permissions – February, 2004
• Repairing Database Corruption in MySQL – January, 2004
• PostgreSQL vs MySQL: Which is better? – December, 2003
• MySQL’s Query Cache – November, 2003
• Table Types in MySQL: Part 2 – InnoDB tables – October, 2003
• Table Types in MySQL: Part 1 – HEAP Tables – September, 2003
• Referential integrity in MySQL – August, 2003
• An introduction to the ADOdb class library for PHP, Part 2 – July, 2003
• An introduction to the ADOdb class library for PHP – June, 2003
• Yesterday’s Toy, Tomorrow’s Contender – May 2003
• Deleting Duplicate Rows in a MySQL Database – May 2003
• MySQL Date and Time functions – Part 2 – April 2003
• MySQL Date and Time functions – Part 1 – April 2003
• More MySQL logs – March 2003
• MySQL’s Over-looked and Under-worked Slow Query Log – March 2003
• Using Fulltext Indexes in MySQL – Part 2 – February 2003
• Using Fulltext Indexes in MySQL – Part 1 – February 2003

Web Developer’s Virtual Library

• Using a MySQL database with PHP – September 2002
• Handling Files with PHP4 – Part 2 – August 2002
• Handling Files with PHP4 – Part 1 – July 2002
• Introduction to Relational Databases – June 2002
• Date and Time in PHP4 – May 2002
• Maintaining State with PHP4 sessions – April 2002
• SQL joins – multi-table queries – February 2002
• Optimizing MySQL, Hardware and the Mysqld Variables – December 2001
• Optimizing MySQL Queries and Indexes – November 2001
• Database Normalization – March 2000

Tectonic

• Edgy Kubuntu: A great desktop alternative – December, 2006
• MySQL 4 ready to take on the ‘big boys’? – January 2003. It was picked up by Newsforge
• Wikipedia, an open source knowedge base – February, 2003

Interviews

• An interview with Ian Gilfillan, SA’s MySQL guru (Media in Transition) – July 2007
• South African author’s latest book on MySQL (Tectonic) – January 2003