Skip to content

Blog

Page 41 of 77 - keep going...

My StackOverflow Rant

Ugh. I really want to contribute to the community. I do! If others before me wouldn’t have done it, I wouldn’t be where I am.

Jul 30, 2013 2 min read #business

MySQL Explain rows column really IS an estimate

Here is an interesting proof of concept that the ‘rows’ column of the explain output is actually an estimate, and not the real amount. I KNEW it to be true, but somehow I didn’t feel like it was right. I always thought “the closer the rows # gets to the exact amount of retrieved data, the better. Exact is what you strive for.” Turns out, that’s not true. The closer the number, the better, but its still just an estimation. Sometimes its estimated accurately, other times its not. See this example:

Jul 23, 2013 1 min read #mysql

PhpStorm Project Launchers for Ubuntu

PhpStorm has an option to install an icon for your Unity Dash on ubuntu - you can do this through the menu system. But, if you use this, it always opens to your last project. I have a number of projects running simultaneously, so this is no good. I could, of course, stop it from opening the last project, and just display the splash page menu. But I didn’t like that either. I wanted to be able to type in the lens search box what I wanted.

Jul 9, 2013 1 min read #ide-and-web-dev-tools #linux

Zend Framework 1 Form Captcha Idea

One of the worst things with CAPTCHAs are actually having to solve them. One of the things my team and I use for our projects is the hidden field CAPTCHA. This is a technique that adds a field to a form, but uses CSS to hide it. If that form value is filled in, we can guess that the submitter was a bot reading the HTML - and not an actual user.

Jul 2, 2013 1 min read #zend-framework

USB Chrome Debugging and Local subnet surfing on Android Emulator

Most of the development I do that needs to be tested on android is on a local subnet. Generally, this is because I am running the servers in virtual machines that mimic the production environment. When I want to test these websites via the android emulator, it would be nice to be able to surf to them locally (without putting them in a public QA environment) - as well as have the ability to use Android Chrome’s USB Debugging.

Jun 18, 2013 3 min read #linux #mobile #scripting