Counting Contiguous Series of Events in Postgres

We've all been on StackOverflow (most of us anyway) and seen the consecutive visit count on our profiles. This is an example of a count of a contiguous series of events. How many days in a row has this user logged in. In this article, we will look a...