Upgrading SVN Client on OSX
Sometimes you find a jewel of a blog post in a sea of confusion and obfuscation. I was checking out a new project I was working on and got a message that my subversion client was out of date. A quick google search and I wasn’t finding very clear instructions for installing or upgrading my local subversion client. Until I found this post by Karsten Thoms. Simple, clear, and it should be celebrated.

Mysql optimization tip#1 gotchas that bork indices
Quick post. Obviously make sure your queries use an index. Not sure if they’re using an index? Try the query with EXPLAIN at the end… mysql will tell you. Anyway, mysql will only use one index per table. And unless you specify, it will pick the smartest one (so you probably don’t need to specify). So as long as you’re indexing your tables well and writing your queries against those indices you’re good, right? Wrong. There are a couple other gotchas to be aware of. Performing a calculation within your query will keep it from using an index. This could be “WHERE (age+20<30)” or using any of the date functions in mysql, even formatting a