When the subselect runs faster

MySQL Performance Blog

A few weeks ago, we had a query optimization request from one of our customer. The query was very simple like: This column in the table is looks like this: The table have 549252 rows and of course, there is an index on the col1. MySQL estimated the…

18 March 2010

Secrets of the proxy icon in a program's title bar

MacOSXHints.com

You can perform many useful tasks using the icon in the title bar of many OS X applications (known as the proxy icon), in both Apple-bundled (TextEdit, Preview, etc.) and third party (BBEdit, Path Finder, and numerous others) applications. For this to…

16 March 2010

Piël: Benchmark of Python Web Servers

LWN.net

Here is an extensive set of performance benchmark results from 14 Python web application servers, done by Nicholas Piël. "The top performers are clearly FAPWS3, uWSGI and Gevent. FAPWS3 has been designed to be fast and lives up the expectations, this has…

16 March 2010

Google's RE2 regular expression library

LWN.net

Google has announcedthe release of its RE2 library under a BSDish license. "At Google, we use regular expressions as part of the interface to many external and internal systems, including Code Search, Sawzall, and Bigtable. Those systems process large…

12 March 2010

Code library gives homebrew iPod remotes chance for awesome

Ars Technica » Infinite Loop

Not too long ago, David Findlay built a device capable of communicating with just about any model of iPod via the dock connector using an Arduino Nano, PodGizmo breakout board, an old USB iPod connector, and a momentary switch. While it may not sound like…

11 March 2010

Running your Unittests everytime you save a file

Planet PHPUnit

Thanks to all of my @posterous peeps. Y'all made this a crazy ride and it was an honor and pleasure working with all of y'all. Thanks to all of the users. Thanks to the academy. Nobody will read this.

11 March 2010

Create Growl alerts for Address Book contacts' birthdays

MacOSXHints.com

I have a lot of people in my Mac OS X Address Book. I thought it would be a nice idea to have the system check the birthdays in Address Book, and inform me of any forthcoming birthdays via a Growl notification. So I've created an Apple Script to do that…

11 March 2010

TextExpander 3 makes short work of keyboard shortcuts

TUAW - The Unofficial Apple Weblog

Filed under: Software TextExpander, one of my very most favorite (yes, I like it that much) utilities has been updated to version 3. This is a major update and renovation of the program, which has changed from a preference pane to an application. I…

10 March 2010

Create your own unique icons

Macworld

There are many reasons why you'd want unique icons. Whatever the reason, Chris McVeigh walks you through some simple steps in this first of a two-part series on icon creation and customization.

10 March 2010