Rob Janssen

How does SQLite work? Part 1: pages!

This evening the fantastic Kamal and I sat down to learn a little more about databases than we did before. Just a primary key and a string! What could be simpler? I then wrote a little Python script to put the contents of /usr/share/dict/words in the database:

How does SQLite work? Part 2: btrees! (or: disk seeks are slow don't do them!)

Welcome back to fun with databases! In Part 1 of this series, we learned that: Let’s understand a little bit more about how these btrees work! First, some theory.

Notebook

The recent disclosure of a critical security flaw in the widely used bash command-line shell for Unix operating systems sent many technology professionals scrambling to update their systems. We were certainly among them.

StephenWattam.com

If you've worked with text data long enough, you've probably come across issues with garbled characters and character set incompatibilities.

New experimental console features in Windows "Threshold"

Microsoft is expected to deliver its first technical preview release of Windows codenamed "Threshold" tomorrowish. And while the usual outlets will be covering the big changes, I wanted to document a relatively smaller set of welcome changes to the Command Prompt (and the underlying Console Host).

This is what happens when two pixel-mashing bots get in a Twitter fight

This week saw a truly bizarre twitter fight between two image-mashing bots. In the red corner, there was @pixelsorter, designed to create relaxed, fuzzy remixes of photos, like the one above.

Performance Counters for your HttpClient

Pure HTTP APIs (aka REST APIs) are very popular at the moment. If you are building/maintaining one, you have probably learnt (perhaps the hard way) that having a monitoring on your API is one of your top cross-cutting concerns.

Tips for building a Single Page Application

Everyone’s building single page applications (SPA) these days. We’ll take a look at some of the challenges and best practices for building JavaScript heavy applications. Some of the things might not be so obvious at first glance, but it definitely helps to think about this up front.

Hacking Your Project Manager

Since becoming a software developer, more times than I can remember I’ve been in meetings where I’ve been blindsided by my manager’s requests.

Performance Quiz #14: Memory Locality, x64 vs. x86, Alignment, and Density

It's been a very long time since I did a performance quiz and so it's only right that this one covers a lot of ground. Before I take even one step forward I want you to know that I will be basing my conclusions on:

This Read-It-Later-list is just that, bookmarks of stuff I intend to read or have read. I do not necessarily agree with opinions or statements in the bookmarked articles.

This list is compiled from my Pocket list.