• PHP
    Why you Should be using PHP's PDO for Database AccessPdo
    Many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions. As of PHP 5.1, there's a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive!Read More…
  • Databases
    Getting Started with MongoDB - Part 2Preview
    Ready to continue learning about MongoDB, one of the coolest technologies for web developers? In this second part of the series, we move on from the basics, on to advanced queries - with conditional operators - and MapReduce.Read More…
  • Databases
    Getting Started with MongoDB - Part 1Preview
    Ready to get in and start learning about MongoDB, one of the coolest technologies for web developers? In this new series, you'll go from beginner to pro and be able to use Mongo just as easily as MySQL in your web apps. But first, let's look at the basics.Read More…
  • Databases
    An Introduction to Stored Procedures in MySQL 5200x200
    MySQL 5 introduced a plethora of new features - stored procedures being one of the most significant. In this tutorial, we will focus on what they are, and how they can make your life easier.Read More…
  • Databases
    Quick Tip: Working With MySQL and SUMCode
    In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and also provide a performance improvement.Read More…
  • Databases
    A Deeper Look at Advanced Select QueriesCode
    To the SQL novice, joins can be intimidating and somewhat frustrating. Even when you think you have the query nailed, along comes an unexpected result which make you throw up your arms in surrender to the SQL gods.Read More…
  • Databases
    Quick Tip: Working with MySQL and INNER JOINCode
    In today’s video quick tip, we’ll go over why and when to use JOINs when working with your databases.Read More…
  • Databases
    An Introduction to MySQL 5: Views200x200
    The MySQL 5 series introduced quite a few changes. Triggers and stored procedures were two of the big ticket items. One of the lesser known additions, at least from the amount of writing on the subject, is the introduction of views. While after a quick look at MySQL views, you might not see the obvious advantages, they're there if you dig into them just a bit.Read More…
  • Databases
    Profiling MySQL Queries with phpMyAdminCode
    I have used phpMyAdmin for over a decade. In my early years with the tool, I simply needed something that could show me table structure and quickly give me the data inside. As my needs have grown, so have the tools included with phpMyAdmin which keeps me coming back as my primary MySQL tool, even with optimization.Read More…
  • Databases
    Quick Tip: A Fast Overview of Querious (MySQL Manager)200x200
    In today's video quick tip, we'll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works -- without being too complicated or overwhelming in the way that PHPMyAdmin might be for some. Read More…
  • Databases
    Introduction to MySQL Triggers200x200
    Chances are, you know what a database trigger is, at least in conceptual terms. Chances are even greater that you know that MySQL supports triggers and has supported them for quite some time. I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL. They're one of those things which should absolutely be in your development toolbox, as they can really change the way that you look at your data.Read More…
  • Databases
    Visual Database Creation with MySQL WorkbenchWorkbenchstart
    In today's tutorial, you'll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we'll review how to use MySQL Workbench, a cross-platform, visual database design tool.Read More…