Archive by Author
A Deeper Look at Advanced Select Queries: New Premium Tutorial
Posted on 23. Jul, 2010 by John Cox.
To a 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. In this tutorial, we are going to build upon the excellent quick tip of working with MySQL [...]
Continue Reading
An Introduction to MySQL 5: Views
Posted on 02. Jul, 2010 by John Cox.
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 [...]
Continue Reading
Profiling MySQL Queries with phpMyAdmin: New Premium Tutorial
Posted on 01. Jul, 2010 by John Cox.
I’ve 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 [...]
Continue Reading
HTML5 Microdata: Welcome to the Machine
Posted on 14. Jun, 2010 by John Cox.
I don’t think it is hyperbole to say that HTML5 will change the way that you think about web development. I welcome many of the changes as they make development easier, and the user experience richer. With any change, though, there is certain to be a bit of trepidation and controversy. One [...]
Continue Reading
Introduction to MySQL Triggers
Posted on 07. Jun, 2010 by John Cox.
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 [...]
Continue Reading
HTML5 Globals and You
Posted on 31. May, 2010 by John Cox.
Much has been written on the big ticket changes in HTML5, like forms, semantics, and media, but information on the less splashy changes is sparse. While global attributes aren’t the most sexy change of HTML5, they are the change that you will be using over and over and over as you migrate to [...]
Continue Reading
CSS DIY Organization
Posted on 25. May, 2010 by John Cox.
I detest looking at code or mark-up that I’ve written in the past, which I don’t understand right off the bat. I’m surely no different from you in that I want to be able to come back years later, pick the code up, and understand exactly what is going on. I don’t want [...]
Continue Reading
Rethinking Forms in HTML5
Posted on 10. May, 2010 by John Cox.
While there are many changes for the better in the HTML5 specification, there is no better bang for the buck for the data driven website than the transformation of forms. These simple changes will transform how you enter, validate, process, and even display inputs. You will be able to create more usable web [...]