While using Query Reviewer, I occasionally come across a warning along the lines of the following:
2 identical queries Table videos: Long key length (768)
With the following explanation:
The key used for the index was rather long, potentially affecting indices in memory
To fix this we need to limit the length of our index. We can do this [...]

You know those times when Textmate beachballs for about 5 seconds when it regains focus, it’s generally caused by the fact you’ve got about 16 million folders in your public/system folder used by paperclip.
Here’s a quick tip to speed things up by ignoring those folders:
Open Textmate Preferences and goto the Advanced section. Then click on [...]

Those of you that follow me on Twitter will probably know that I’ve spent the last week or so trying to find a decent way of generating PDF documents from a Rails application. I finally found a solution that suited my needs so I thought I’d share it with you lovely people.
Initial Probing
After my first [...]