Stavros' Stuff

On programming and other things.

How to highlight code in Python

I’ve recently been looking at syntax highlighters, both for this blog and for Instahero, the new product my company is developing. I used to use a JS-based solution for the blog, but it broke with many inputs, it was fiddly to work with, didn’t parse correctly sometimes, and slowed the site down considerably. I especially disliked the fact that you had to include one JS

Continue reading…

The curious case of the range() function

If you’ve ever programmed in Python, you have a 96.2% chance of having used the range() function. As you have a 96.1% chance of knowing, said function returns a list containing an arithmetic progression of integers, exactly as the documentation says. For example, range(4) returns [0, 1 2, 3].

If you’ve ever bothered to look at the docstring, you will see that it goes thus:

Continue reading…

A schemaless layer over SQLite

I’ve been hard at work these days, and to relax I decided to develop a small application/side project. As with many applications, I needed a reliable, persistent store, so I went with the most reliable, easy to set up, performant, and generally awesome store I knew: SQLite.

However, since this was a very experimental prototype, I got tired of the frequent schema changes and wished I had something

Continue reading…

Winning at Puzzle Adventures

A few weeks ago, some friends of mine started playing a Facebook game, Puzzle Adventures. This is a (pretty fun) jigsaw puzzle game, so I played a few levels at some point. The game limits you significantly in many areas (e.g. you can only play three or four games before you have to wait for minutes to play more, or pay). The game is also geared against

Continue reading…

How to handle Python package installation on GAE

As I’ve mentioned many times on this blog, I’m a big fan of Google AppEngine. I like the free tier, the effortless scaling, the zero administration, and how I can run Django almost unmodified and deploy in seconds. It has its downsides, but overall I like it very much.

The one part of deployment I didn’t like was dependency handling. Due to the way GAE works, you need to install all packages in t

Continue reading…

On authentication usability

A few days ago, I tried to log into my alternate Facebook account, one I hadn’t logged into for a while. After the first or second failed attempt at logging in (I couldn’t remember the password), my mail client rang and I saw the following email from Facebook:

Facebook login email

This struck me as a fantastic touch and a great usability boost. It also made m

Continue reading…

A short update

As I have mentioned previously, this blog is running on Google’s AppEngine, and I have just migrated it to the HR datastore to test out Python 2.7. Hopefully this will go well and the concurrent requests will keep the instances to a minimum. I am curious to see how well this will perform.

I am especially interested in the change of instance hours between the old and new backends. Based on a quick

Continue reading…

How PostgreSQL's SR (Streaming Replication) works

Recently, I have come upon the need to deploy a high-availability/performance postgres cluster, and I looked into various replication solutions. Of the ones I saw, Streaming Replication was the easiest to set up, fairly performant and a good fit for what we wanted to do, and it’s built into postgres 9.0+.

Unfortunately, checking the documentation and howtos, I gained little insight into how it works. There are plenty of detailed guides on how to set it up, but none explain how exactly it works, so it was a bit of a black box for me. Fortunately, the guys in #postgresql are extremely helpful, and quickly explained to me the specifics of replication, which I am going to post here for

Continue reading…

App Engine pricing changes revisited

As anyone who knows me will already have noticed, I’m a quite an outspoken proponent of Google AppEngine. Many of my projects nowadays run on GAE, including this very blog, as I love the ease of deployment, the provided services and low cost. I decided to migrate this blog to it from a VPS after many troubles with Drupal (lack of customizability, security problems, etc). It didn’t help that it get

Continue reading…