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.
As a computer repair technician I clean up a lot of computers with Java based malware. Java is known for its zero-day vulnerabilities and as a popular vector for cross-platform attacks. Not to mention the fact that Java Runtime Environment (JRE) updates never remove old versions, and Java installs and enables plugins for all popular [...]
This morning a friend forwarded me this email from Mockingbird. Dear Mockingbird customers, Mockingbird’s taking flight We’re excited to announce that Mockingbird will launch on August 15, 2010 — with multi-user collaboration! Details on the paid plans: Active Projects Users Price/month Personal 2 Unlimited $9 Team 10 Unlimited $20 Pro 25 Unlimited $40 Unlimited Unlimited Unlimited [...]
I hack on web apps for a living and tinker with computers for fun.