0 Easily Deploy LAMP Stacks, and it’s free I have yet to use ServerPilot, but will be setting up a new VPS at DigitalOcean in the coming weeks for a new venture. ServerPilot makes getting a LAMP stack setup very quickly. ServerPilot will automatically install Nginx, Apache, PHP, and MySQL on a new, freshly installed/created, […]

MySQL Workbench on Debian Squeeze 6.0.6

0 I spent about an hour compiling MySQL Workbench from source earlier today. After about 20 newly satisfied dependencies and an hour of actual building, I fired it up and discovered I wasn’t able to connect to any MySQL server through an SSH tunnel, which I have to be able to do. I was able […]

3+ Tag clouds are everywhere. They are a popular way to show the weight (read: popularity) of tags, categories, or any words really. I needed to build a tag cloud for a project at work to display categories and show how many questions were contained inside each category. Categories with more questions would need a […]

1+ Tech-Evangelist has put together an excellent cheatsheet for MySQL. There’s lots of other MySQL cheatsheets out there, but this one is unique in the fact that it gives examples of usage rather than just snippets of code. This cheatsheet also includes a summary of commonly used MySQL data types, which will be really helpful […]

0 Take note of this graphic. Notice there’s been 3,775,826 queries processed by that MySQL server in a little more than 5 days. Nothing too impressive right? Right. We know MySQL can handle many more queries than that in a much shorter period of time. What amazes me is how well MySQL performs on the […]