Index columns for LIKE in PostgreSQL

Postgres uses trigrams to break down strings into smaller chunks and index them efficiently. The pg_trgm module supports GIST or GIN indexes and as of Postgres version 9.1 these indexes support LIKE/ILIKE queries.

I need to test if gin_trgm_ops is faster than varchar_pattern_ops.

Source making!

Design patterns can speed up the development process by providing tested, proven development paradigms.

How to shape the source code.

Python anti-patterns

We think that you can learn as much from reading bad code as you can from reading good one.

The beauty of programming

You can do something the brute force way, the stupid way, or you can find the right approach and suddenly the problem just goes away. You look at the problem another way, and you have this epiphany: it was only a problem because you were looking at it the wrong way.

Less is more. Design the code, design everything.

Multiprocessing in Python

A brief overview of different approaches to show how the multiprocessing module can be used for parallel programming.

So good they can't ignore you

Following your passion is bad, instead go for Mastery, Autonomy and Purpose — the trio of things that have been proven to motivate knowledge workers.

How to run multiple websites from one Django project

The subdomain specific settings files will inherit all the defaults from the common settings.py file, and override only those values which are specific to the domain.

WSGI app files are the key of running multiple subdomains.

The tools I use to write books

Of course I do not send plain text files out to readers. Instead, they receive nicely formatted PDF, ePub, Mobi and HTML files, which I create with only a tiny number of tools: pp, pandoc and KindleGen. Together they form a pipeline.

That pipeline is essential.

1 2 3 4 5 6 7 8 9 10