Month: May 2014

Using words like John McPhee

One of my favorite writers is John McPhee of Princeton, NJ. He’s written for The New Yorker since my memory of him began, and published many books with the Macmillan publishing company.  He’s the good reason I preach from a manuscript rather than extemporaneously: if a phrase is worth listening to, it’s worth constructing well. There are bad reasons, like my poor memory… Read more →

Filling in missing data with sequences of cardinal integers

When you’re extracting summaries of information from a database, sometimes rows are missing.  For example, if you are keeping track of number of customers by day, you might use a query like this: View the code on Gist. You might get a result set like this: 2014-03-07 122 2014-03-08 355 2014-03-10 234 2014-03-11 119 Notice that the row for 2014-03-09… Read more →