MySQL admin with Ian Gilfillan

Posted on by

I was doing some reading today and I came upon an old series of articles over on www.databasejournal.com by a dude called Ian Gilfillan:

For the ‘type’ in SQL ‘EXPLAIN’ Ian says: from best to worst the types are: system, const, eq_ref, ref, range, index, all.
It seems this Ian Gilfillan fellow has been rather prolific.

Reading time as lines-of-code per hour

Posted on by

I was wondering how many lines of code it was possible to read per hour. I found on the Wikipedia code review article the claim: “Code review rates should be between 200 and 400 lines of code per hour.” They say any faster is too fast to find errors. I also found on the Wikipedia article source lines of code that a contemporary Linux kernel has 20 million lines-of-code. So if you didn’t sleep and read code 24×7 you could read the Linux kernel in a little over 5 years…

Don’t End The Week With Nothing

Posted on by

This on HN today: Don’t End The Week With Nothing. It referenced Developer Evangelism: The Whole Story and Jason Cohen – Designing the perfect bootstrapped startup MicroConf 2013 (audio and transcript here). Jason Cohen’s formula is:

Predictable acquisition of recurring revenue with an annual pre-pay option with a product which solves a demonstrable, enduring pain point for a business.

PHP finally blocks not run on exit

Posted on by

I confirmed with the following code that if you call ‘exit’ withing a ‘try’ block the ‘finally’ block does *not* execute. That’s probably what you would expect. But now we know.

register_shutdown_function( 'handle_shutdown' );

try {

  exit;

}
catch ( Exception $ex ) {

  echo "caught...\n";

}
finally {

  echo "finally...\n";

}

function handle_shutdown() {

  echo "shutdown...\n";

}