The original MySQL developers are back together to work on a rival to Oracle's open source database.Read More
mysql
Richard Kotze takes a look at the advantages and disadvantages of using MySQL views to manage database tables.Read More
Jacco Blankenspoor takes a look at some of the ways you can host your MySQL in the cloud, using some major players in the field as examples.Read More
Craig looks at DbNinja. It may be just another PHP-based MySQL client, but this one is a little special...Read More
Episode 161 of The SitePoint Podcast is now available! This week our regular interview host Louis Simoneau (@rssaddict) interviews long-term podcast host, Kevin Yank (@sentience) who now works at... Read More
Craig looks at the new features in WordPress 3.3 - the web's most widely-used Content Management System.Read More
FusionCharts lets you configure and deploy multi-level, drill down charts to present data in an attractive, simple interface. Rob Frieman & Michael McCarthy show you how.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
Handling dates in PHP and MySQL is difficult unless the timezones match in both processes. Craig provides a few lines of code which should help solve date/time problems in your application.Read More
Version 3.1 of WordPress, the web's most popular CMS, was released last week. Craig looks at the exciting new features and improvements for web developers.Read More
