Jan 3, 2019 Thursday

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.

Dec 4, 2018 Tuesday

Source Making

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

How to shape the source code.

Nov 29, 2018 Thursday

Python anti-patterns

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

Oct 17, 2018 Wednesday

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.

Oct 4, 2018 Thursday

Multiprocessing in Python

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

1 2 3 4 5 6 7 8 9 10 11 12 13