All entries of my technical and business blog.

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... (more…)

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... (more…)

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. (more…)

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... (more…)

⬅ Newer | Older ➡
Page 16 of 52
or use RSS