Ian Gilfillan

Tuesday Oct 1st 2002 by DatabaseJournal.com Staff

Ian Gilfillan's articles

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.


Series Articles

Tomorrow's Contender

MySQL Storage Engines

Transactions in MySQL

MySQL Stored Procedures and Functions

MySQL Date and Time Functions

Current Articles

- MySQL and Character Sets
- A Database Journal Guide to MySQL 5 Certification: The DBA Stream
- A Database Journal Guide to MySQL 5 Certification
- MySQL, today's contender
- Connecting and prepared statements with the mysqli extension
- MySQL 5.1 - the next generation
- Pressure on MySQL increases as Oracle purchases Sleepycat, with more to come
- Date and Time in MySQL 5
- MySQL Stored Functions
- Oracle's purchase of InnoDB, their release of Oracle Express, and the effect on MySQL
- MySQL Stored Procedures: Part 3
- MySQL Stored Procedures: Part 2
- MySQL Stored Procedures: Part 1
- MySQL Oddities
- MySQL 5 Storage Engines
- A Database Journal Guide to MySQL Certification: Part 2, Professional Certification
- A Database Journal Guide to MySQL Certification: Part 1, Core Certification
- Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS'
- The HAVING and GROUP BY SQL clauses
- MySQL Query Browser
- MySQL Administrator
- MySQL Subqueries
- MySQL backups
- MySQL Transactions, Part III - BDB Tables, Table locking and Savepoints
- MySQL Transactions, Part II - Transaction Isolation Levels
- Transactions in MySQL
- Optimizing the mysqld variables
- Database Replication in MySQL
- MySQL, Still tomorrow's contender?
- Restoring lost data from the Binary Update Log
- An introduction to MySQL permissions
- Repairing Database Corruption in MySQL
- PostgreSQL vs MySQL: Which is better?
- MySQL's Query Cache
- Table types in MySQL: Part 2 - InnoDB tables
- Table types in MySQL: Part 1 - HEAP tables
- Referential Integrity in MySQL
- An introduction to the ADOdb class library for PHP, Part 2
- An introduction to the ADOdb class library for PHP
- MySQL--Yesterday's Toy, Tomorrow's Contender
- Deleting Duplicate Rows in a MySQL Database
- MySQL date and time functions, Part 2
- MySQL date and time functions, Part 1
- More MySQL logs
- MySQL's Over-looked and Under-worked Slow Query Log
- Using Fulltext Indexes in MySQL - Part 2, Boolean searches
- Using Fulltext Indexes in MySQL - Part 1
- Using a MySQL database with PHP
- Introduction to Relational Databases
- Database Normalization
- SQL joins - multi-table queries
- Optimizing MySQL: Hardware and the Mysqld Variables
- Optimizing MySQL: Queries and Indexes
- Database Normalization

Mobile Site | Full Site