Latest Posts
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.
Disable Java plugins to avoid drive by installs
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 [...]
Mockingbird doesn’t want casual users
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 [...]
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.
![Fix a malfunctioning BlackBerry Trackball [video]](http://unsharptech.com/wp-content/uploads/pth/recent/recent_ut-default48x48.png)
Recent Comments