fast genomic coordinate comparison using PostgreSQL’s geometric operators

PostgreSQL provides operators for comparing geometric data types, for example for computing whether two boxes overlap or whether one box contains another. Such operators are quick compared to similar calculations implemented using normal comparison operators, which I’ll demonstrate below. Here I show use of such geometric data types and operators for determining whether one segment […]

Read More

new year’s revolutions

One has to constantly remake themselves to adapt to the market and to the times. This activity serves those who practice it well economically and keeps them from becoming bored. It requires a constant state of personal “revolution”. Here I describe my revolutionary plans for 2015; namely which technologies I intend to learn and which […]

Read More