Electricmonk

Ferry Boender

Programmer, DevOpper, Open Source enthusiast.

Blog

Archive for May 2009

Encodings in Python

There’s a whole slew of information regarding all kinds of encoding issues out there on the big bad Internet. Some deal with how unicode works, some with what UTF-8 is and how it relates to other encodings and some with how to transform from one encoding to another. All that theory is nice, but I’ve […]

Gift certificates

I don’t understand gift certificates. I mean, the idea is quite good: A piece of paper that represents a certain value, and which you can then trade for goods of some kind. Much better than dragging all that gold around all the time. So in that regard, gift certificates are an awesome idea. Except that […]

Filling gaps in data when using aggregates

SQL’s aggregate functions (COUNT, MIN, MAX, etc) in combination with GROUP BY is great for generating statistics from a database. It’s quite easy to retrieve a count of the rows in a database grouped by week number or month. When there are no data points in the table for a particular week or month, however, […]

The text of all posts on this blog, unless specificly mentioned otherwise, are licensed under this license.