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 [...]
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 [...]
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 [...]
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.
I hack on web apps for a living and tinker with computers for fun.