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.
[[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 [...]
Found myself tasked with reverse-engineering the Duo Pop appcessory this week. In case you’re wondering, base-station to iPad communication is handled via ultrasonic sound. EOM. b.
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…
[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. [...]
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 [...]
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 [...]
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 [...]
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 [...]
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.