I found this great collection of notes: Database Programming – An Intermediate MySQL Tutorial – Scripting, Data Types, Examples.
Category Archives: Programming
Reading time as lines-of-code per hour
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…
Why every single element of SOLID is wrong
Charts.css
Kickass: Charts.css. Also of interest: Which color scale to use when visualizing data.
PHP finally blocks not run on exit
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";
}
Software disenchantment
Well someone is/was upset: Software disenchantment. I really liked the image of the design process: simple -> complex then complex -> simple. Maybe that’s the answer to Nikita’s woes: we’re just not finished yet.
CSS property usage
This popped up on lobsters today: Chrome Platform Status: CSS usage. It’s a report on the prevalence of CSS properties as found in the wild. It’s interesting. I was surprised by some things. e.g. ‘display’ and ‘position’ are more prevalent than ‘padding’ and ‘margin’.
How are zlib, gzip and zip related?
Via r/programming today: How are zlib, gzip and zip related? What do they have in common and how are they different?
Preemptive Pluralization is (Probably) Not Evil
An interesting article on data modelling and API design: Preemptive Pluralization is (Probably) Not Evil.
Closed-source SaaS
In the news today: Why I Didn’t Open-Source My Second SaaS. He decided to switch his business model from open-source to closed-source to try and find a business model that worked. On the other hand, also in the news: How I earn a living selling my open source software.