Leo Uino

Most people would use “word”, “half-word”, “quarter-word” etc, but the Anglophiles insist on “tuppit”, “ternary piece”, “span” and “chunk” (that’s 5 bits, or 12 old bits).

TDD

const max12 = (x, y) => {
    if (x === 1 && y === 2) {
        return 2;
    } else if (x === 7 && y === 4) {
        return 7;
    } else {
        return x;
    }
};

Yes, CTEs are awesome. Especially when you don’t force materialization and the optimizer can work its magic.

I’ve had a lot of fun with window functions as well.

Um, actually… A signed 32-bit counter would loop back to December 1901, so the calendar is presumably 31-bit unsigned. (Sorry)

There’s always the classic C strcpy :)

char *strcpy(char *dest, char *src) {
    char *p = dest;
    while (*p++ = *src++);
    return dest;
}

It’s fascinating to read these in-depth retrospectives from the people who were actually involved.