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

data natives

We hear a lot of marketing yammer about “digital natives”, that is, folks fluent in social media and in particular marketing using social media. Writers who use this term often juxtapose such digital natives against “analog natives”, i.e., individuals who matured or were educated before online social media became such a significant part of our […]

Read More