Tag: programming
-
How To: Exclude Words Like “An, A, The” From Alphabetized MySQL ORDER
When ordering lists of names or titles it’s sometimes desirable to exclude articles or other words from the order clause (eg. you want “The Burning Hell” to show up before “Great Lake Swimmers” in a list ordered by name). Early on in my career I must have assumed it was not possible and never bothered…
-
Even Google Makes Mistakes
This is an expert from a Gmail Blog Post re: the recent gmail outage: Unexpected side effects of some new code that tries to keep data geographically close to its owner caused another data center in Europe to become overloaded, and that caused cascading problems from one data center to another. It took us about…
-
Revisiting Mobile Redirection Using .htaccess ReWrite Rules
This article is out of date, check my latest code snippet here. Back in 2007 I wrote a post detailing a method for detecting and redirecting mobile browsers using .htaccess. Since then the mobile landscape has changed quite a bit: iPhone and Android have been released, the PDA market is all but dead and phones…