One of the things on my TODO list for some time has been writing some code to access the raw database of my blog posts. The most obvious reason is for generating stats, but I like to know I can ask questions about this body of data and get back meaningful answers. A particular question which came up almost 6 months ago was about the word count of my blog:
I have been thinking about a word count plugin, or just a PHP SQL (BASH?) hack, to give me a more meaningful statistic, but I’ll save that for when I’m running out of things to say.
I hope this doesn’t mean that I’m running out of things to say, and instead that I’m getting back to my core topics like programming. Anyway, I have produced a PHP page to generate a quite detailed analysis of word frequencies and counts, which I will discuss and present in this blog post.
Continue reading "A nice bit of word count PHP"