kentcowgill.org/blog

As a follow-on to my last statistical post, I thought I'd also create a graph that tracks what days I generally post on.

The SQL is amazingly the same, but only slightly different. In fact, nearly everything is exactly the same -- I should just generalize the code.

I ran across some guys' blog recently where he decided that for every 100 posts to his blog, he should figure out some of his blogging statistics. Or something like that.

One of which was to see what time of day he generally posted. He explained some procedure for doing a database query from the shell, piping the output through some command line utilities, and then running some commands or somesuch to feed into some graphing program (gnuplot) to produce a chart.

Seemed like a terribly manual process.

Inspired by that, I created the following:

Which is pretty much what I stated, but it updates automatically. As in every time it gets displayed. What you see above is current, even now. However long ago this was actually written.

For the morbidly curious, the SQL to create the data looks like this: