Ian Gilfillan, Author at Database Journal

Ian Gilfillan lives in Cape Town, South Africa. He is the author of the book 'Mastering MySQL 4', published by Sybex, and has been working with MySQL since 1997. These days he develops mainly in PHP and MySQL, although confesses to starting out with BASIC and COBOL, way back when, and still has a soft spot for Perl. He developed South Africa's first online grocery store, and has developed and taught internet development and other technical courses for various institutions. He has majors in Programming and Information Systems, as well as English and Philosophy. For 5 years he was Lead Developer and IT Manager for Independent Online, South Africa's premier news portal. However, he has now 'retired' from fulltime work, and is hoping that his next book will be more in the style of William Blake and Allen Ginsberg.

MySQL

MySQL and Character Sets

In spite of the dominance of English for business purposes, we still live in a multilingual world. At some point, most serious MySQL developers and DBA's

Oct 18, 2006

MySQL

A Database Journal Guide to MySQL 5 Certification: The DBA Stream

Introduction Last time we looked at the Developer Stream of the MySQL 5 certification. Now, in the last part of this series, we look at the DBA stream.

Aug 22, 2006

MySQL

A Database Journal Guide to MySQL 5 Certification

Introduction Last year I wrote a two-part series entitled the Database Journal Guide to MySQL certification. Part one covered the core certification, and

Jun 27, 2006

MySQL

MySQL, today’s contender

In May 2003, I wrote an article entitled MySQL--Yesterday's Toy, Tomorrow's Contender. I followed it up a year later with MySQL, Still tomorrow's

May 16, 2006

MySQL

Connecting and prepared statements with the mysqli extension

Change is afoot in the PHP/MySQL world. In quite a short space of time, we have moved from MySQL 3.23.x and PHP 4.x, to PHP 5.x and MySQL 4.1.x and now

Apr 18, 2006

MySQL

MySQL 5.1 – the next generation

There are still people using MySQL 4.0 (and I even came across a MySQL 3.23 installation recently), but MySQL 5.1 is now the latest of the MySQL

Mar 21, 2006

MySQL

Pressure on MySQL increases as Oracle purchases Sleepycat, with more to come

In November, I looked at Oracle's purchase of InnoDB, as well as their release of Oracle Express, and the effect on MySQL. In short, I concluded that the

Feb 15, 2006

MySQL

Date and Time in MySQL 5

Introduction In April 2003, I wrote two articles on MySQL's Date and Time functions (part1 and part2). With MySQL 5 now released, and in widespread use,

Jan 17, 2006

MySQL

MySQL Stored Functions

Introduction Continuing with our series on Stored Procedures and Functions (see part 1, part 2, or part 3), this month we focus on Stored Functions. Most

Dec 13, 2005

MySQL

Oracle’s purchase of InnoDB, their release of Oracle Express, and the effect on MySQL

As most of you will know, the big news recently in the MySQL world, besides the launch of the long-awaited MySQL 5, involves Oracle. Oracle has done two

Nov 9, 2005

MySQL

MySQL Stored Procedures: Part 3

Introduction In part 3 of the ongoing series about MySQL's stored procedures, we look at handlers and cursors in particular - both logical constructs that

Oct 11, 2005

MySQL

MySQL Stored Procedures: Part 2

Introduction Last month I introduced MySQL Stored Procedures. If you have not yet read that article, you should do so first, as I continue to build upon

Sep 13, 2005

1 2 3

...

Ian Gilfillan

Company

Categories