// home

Latest Posts

Debug your Apache mod_rewrite Rules!

Apache mod_rewrite is incredibly powerful but it’s also a PITA if you’re trying to do something advanced. Luckily, you can log mod_rewrite’s activities and better understand why your rules aren’t working. Just add RewriteLogLevel and RewriteLog to your Apache VirtualHost config: I suggest log level 8 but you can try lower. Logging rewrites will be [...]

Pretty print to console in Node.js

JSON.stringify is pretty cool, in fact you can use it to print javascript data structures in a more readable format. Of course modern browser javascript consoles already format nested data for you, but this is really helpful when using console.log() in Node.js JSON.stringify documentation

Analyzing mysql slow query log

I had yet to have a need for a tool to analyze a MySQL slow query log, after some searching I came across a tool I already had! Most MySQL installs come with the utility mysqldumpslow which is great for parsing your slow query log. I needed to sort by lock time so I just ran [...]

I’m in love with git

A month ago I switched to git from subversion when I started at RealSelf. Now I’m in love. Why I liked git before: Distributed Fast Github (hip) Why I love git now: Branching does not disrupt workflow Rebase The command line interface is so powerful and useable that I don’t rely on GUI tools (except [...]

FULL OUTER JOIN in MySQL

MySQL doesn’t support the FULL OUTER JOIN, so I did some googleing and found this: http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-join-in-mysql/ Method 1 worked great for me; a UNION between a LEFT OUTER JOIN and a RIGHT OUTER JOIN.

Asides

  • This morning I was going over last night's ClamWin scan results on my Windows XP box and found a few instances of Trojan.Rootkit-1835 infecting the following files: (more...) #
  • Viigo has some great features and all but for simple RSS reading on my BlackBerry Google Reader Mobile beats the crap out of Viigo. (more...) #
  • New theme integration is progress. I just don't have the gas to do it all in one night... (more...) #

Welcome to unsharpTech

I hack on web apps for a living and tinker with computers for fun.

Categories