
database

Craig looks at DbNinja. It may be just another PHP-based MySQL client, but this one is a little special...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






