Here’s my first pass at a Textmate command (for the E text editor). It copies the text selection to a multi-line C constant, useful for pasting SQL statements into C code:

perl -p -e 's/^(\s+|)(.*)( |)(\s+|)$/$1\"$2$3\"$4/' | pbcopy
echo "Copied C-SQL to Clipboard"

The regex preserves whitespace after each line of statement within the quotes, and preserves the indent so you can still read the SQL in your C code.

Found while writing Textmate compatible bundles in “E”. The command (and related pbpaste) do clipboard magic from the shell:

$ pbcopy --help
pbcopy version 0.2.0
  Copy stdin to the Windows Clipboard

A good Bash FAQ. Always fun to learn something new about your shell.

Guy Kawasaki’s guide on How not to hire people on Craig’sList. While I hate the phrase, “keeping it real,” job postings need to be approachable, easy to grok, and based in reality.

Bloglines rolls out a new beta. Hey, here’s an idea: how about they just copy the Google Reader UI? There’s a chasm of possibilities in RSS land, maybe they should just focus on the reading (and finding the nuggets).

HOWTO (or not to) write a bug report.

HOWTO: use Firefox3 for deploying XUL apps. My question: when does XUL start to suck less?

Linus thinks out loud about how to apply Git to KDE development, including thoughts on social versus technical reasons for central repositories. A good discussion for anyone considering how Git would apply to something already in something CVS/SVN-like.

A rich web SQL editor (all in JS/HTML). A good example of a drag/drop UI for table building, including a nice view scroll widget at the bottom. Very slick.

How do you effectively integrate into software development teams?. It’s a difficult problem that requires humility and patience.