If you’re like me, you enjoy partaking in the occasional SQL JOIN. But after a while the straight vanilla JOIN gets a little old (not to mention that it’s not always necessarily the most efficient way of pulling records).
Thus I give you… A Visual Explanation of SQL JOINs
Enjoy, and use it well.
So… My wife & I took a (belated honeymoon) trip to Japan this December. We bought several gifts, but only one for ourselves… a set of sushi plates, saucers & bowls. Things were not intact when we arrived back in Omaha. What follows below is my formal complaint to American Airlines (via their form, which […]
Discovered a bug today. One which, best I can gather, occurs only in Safari, with users running OSX 10.6 (Snow Leopard). After finally tracking down what the problem was, I was amazed that the bug wasn’t better documented…
For those not aware, in order to create dynamic display ads that don’t look like donkey poo, the developer needs to embed the font-outlines for any and all characters which MIGHT appear in the ad’s dynamic text areas (headline, call to action, etc). For standard North-American english, the Latin I characterset works just fine, and […]
I have a new source of time-suckage, and its name is the Kinect. Back in December, someone hacked Microsoft’s Kinect.. allowing computers to interface and receive raw data from the full-body motion/gesture sensing device. A week or two ago, in early January, another group created an AS3 solution. The solution consists of a command-line socket […]
There is no excerpt because this is a protected post.
[bk note: the following post was written in November of 2011. As technology continuously evolves, the solution below may very well have changed/become obsolete.] I thought I’d share this little nugget, since it’s not very well covered within the tomes of the intertubes. I was using PhoneGap and SenchaTouch to create a native iOS app. […]
[[A lot of this is stream-of-consciousness and has, as of yet, to be organized into a proper form… expect updates & edits in the next few hours/days….]] Word of warning: In the article that follows, I will use “GSM” and “CDMA” as descriptors for phones and networks. I realize that AT&T’s 3G network is actually […]
If you’re running PHP on a 32-bit system, you’ll need make sure that your install has been compiled with the -ffloat-store flag. Otherwise, the PHP process will enter an infinite loop when you try to perform mathematic operations on the floating number 2.2250738585072011e-308.
This bug may very well have been around for a while, but it seems that the Google Voice plugin for browsers (Safari, Firefox, Chrome) is very possessive of its webcam. If you have the Google Voice plugin installed on your machine and you attempt to go to a site with Flash that wants/needs to have […]
A little excitement today in the Flash dev community. http://blogs.adobe.com/conversations/2011/11/flash-focus.html If you read the actual announcement (leaving out the trolling hyperbole), you’ll see that FP mobile is not dead per-se. However, from this day forward, Adobe won’t be branching their FP code to port it to the countless device architecture/hardware configurations… It’ll be up […]