Category Archives: Uncategorized

My Autographed Laptop

Back in my university days the computer science club used to occasionally invite high profile speakers. I had a fairly old laptop at the time and I made a habit of taking it with me for autographs, to the total … Continue reading

Posted in Uncategorized | Leave a comment

SQL: Nested Window Functions and Time Series

In an effort to keep up my grueling regime of publishing at least one blog post per year, I’ve decided to write today about a neat little problem I ran across. The problem is; how do you calculate the cumulative … Continue reading

Posted in Uncategorized | Leave a comment

range(n): A Deceptively Complex Program

I’ve been itching to write this article since I authored Python vs Copy on Write last year. To recap, I found myself awake at 4 AM trying to performance tune the cache on a long running ETL written in Python. In … Continue reading

Posted in Uncategorized | 2 Comments

The Human Rules of Acquisition

There’s very little else as satisfying as calling someone a pataQ, questioning their honour and claiming their D’k tahg. Quoting an obscure rule of acquisition during a business negotiation comes close. I’ve always found it mildly irritating that humans  don’t have … Continue reading

Posted in Uncategorized | Leave a comment

How To: Make a Dive Knife

Between pizza fuelled coding sessions, I’m occasionally let out to spend time on things that are not programming related. Today I thought; “it’s about time I made a dive knife”, followed by “I may as well blog about it”. Why … Continue reading

Posted in Uncategorized | Leave a comment

Python vs Copy on Write

I recently found myself awake at 4 AM trying to science myself out of a memory problem in Python on Linux. If you’re trying to share a read only cache to a number of Linux subprocesses and find yourself running … Continue reading

Posted in Uncategorized | 12 Comments

Explaining Technical Debt

I’ve been thinking about technical debt and how it builds in software projects. Brace yourself, this is a depressing topic so I’ve included a picture of a turtle. Hopefully that makes you feel better. Good? Good. It’s very easy to come up … Continue reading

Posted in Uncategorized | Leave a comment

sqlpyzer: IPython + sqlite in html5

What is a sqlpyzer? sqlpyzer is an experimental plugin I wrote for the IPython  Notebook. It’s much easier to describe what it is in a video, so here goes: You can find the source and the installation instructions here: https://github.com/RishiRamraj/sqlpyzerContinue reading

Posted in Uncategorized | Leave a comment