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.
Design patterns can speed up the development process by providing tested, proven development paradigms.
How to shape the source code.
We think that you can learn as much from reading bad code as you can from reading good one.
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.
A brief overview of different approaches to show how the multiprocessing module can be used for parallel programming.