Number readability with underscores in Python 3
Here is a neat trick for Python numeric values: you can improve readability of large numbers by using underscores as separators, like this: caption taken …
Programming
Sprintf is your friend
Usain Bolt, famous sprinter. If he were a programmer, he’d definitely be a sprintf-er. I’ve seen many developers steer clear of the sprintf function. In …
MySQL UPDATE based on data from different tables
Just like my previous article on the meaning of COALESCE, the following problem is one of those brain teasers that keeps developers busy for a …
Untangling conditionals with IF-inversion
This is a very common trick, but there are still some developers around who struggle with applying it. The idea is to cut through the …
Using COALESCE for neat SQL queries
A lot of times, when learning something in college, you may think “What good is this to me in real life?”. COALESCE is one of …