Craig looks at DbNinja. It may be just another PHP-based MySQL client, but this one is a little special...Read More
database
Earlier this month in San Francisco, Oracle announced their Cloud platform in Oracle Open World 2012. Though a late entrant to Cloud game, Oracle decided to enter with a fully baked platform... Read More
Episode 179 of The SitePoint Podcast is now available! This week we have 3/4 of the panel, Louis Simoneau (@rssaddict), Patrick O’Keefe (@ifroggy) and Stephan Segraves (@ssegraves). Listen in... Read More
This guide is a practical overview to help you begin migrating your existing PHP code from using the older MySQL extension to the newer PDO database abstraction extension. I won’t go into all of... Read More
In the last part of Craig's database series, he discusses how to create MySQL events which run at pre-defined intervals.Read More
In the second part of Craig's database series, he discusses how to create triggers in MySQL which run automatically when records are added, changed or deleted.Read More
Craig provides an overview of two powerful database features: triggers and events. He describes what they are and suggests when they should and shouldn't be used.Read More
SQL JOINs are often misunderstood and one of the biggest causes of database optimization problems. Craig provides a brief tutorial about JOINs and their use in MySQL and other relational databases.Read More
Oracle has released MySQL 5.5. Craig looks at the new features and improvements to the world's most-used open source database.Read More
Are you in control of your database or is it driving you mad? Craig lists the top 10 MySQL mistakes he's made when developing PHP applications.Read More
Version 9.0 of the popular open source relational database has been released. Is it time to look beyond MySQL?Read More
