739-dbninja-logo

database

739-dbninja-logo
Craig looks at DbNinja. It may be just another PHP-based MySQL client, but this one is a little special...Read More
 
dancing-baby
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
 
Thumbnail
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
 
525-mysql-automation
In the last part of Craig's database series, he discusses how to create MySQL events which run at pre-defined intervals.Read More
 
525-mysql-automation
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
 
525-mysql-automation
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
 
 
512-sql-joins
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
 
460-mysql-55
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
 
448-mysql-mistakes
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
 
419-postgresql-9
Version 9.0 of the popular open source relational database has been released. Is it time to look beyond MySQL?Read More
 

Get Started with
Ruby on Rails

Github, Twitter and Hulu. All huge. All successful. All Rails.

Learn the web development framework of the moment with our newest book and course.

Learn Rails