2017 in Bitface Blogging

Well hello. It’s been a while. That daily posting thing didn’t work too well in the latter part of the year, and was particularly weak in the last couple of weeks. Weak weeks.

In fact I posted 261 times in 2017. It’s surprisingly hard to find that kind of thing out from WordPress itself. I had to dig into the database and run some simple SQL:

select count(*) from devilgate_posts 
  where  post_status = 'publish' 
  and post_type = 'post' 
  and post_date_gmt like '2017%';

261 is 72% of the days of the year, which is not too bad. Certainly the most posts in any year out of the past fifteen(!)

Here’s the monthly breakdown:

Month Posts
Jan 32
Feb 33
Mar 33
Apr 18
May 27
Jun 15
Jul 21
Aug 17
Sep 18
Oct 18
Nov 23
Dec 6

A strong start, tapering off in the middle, with a rally in November and then a complete collapse in December. I suspect the last is from a combination of post-nano slump and the festive season.

If you’re interested, here’s the SQL that got me that table:

select 
  date_format(post_date_gmt, '%b') as Month, 
  count(*) as Posts 
  from devilgate_posts 
  where post_status = 'publish' 
  and post_type = 'post' 
  and post_date_gmt like '2017%' 
  group by date_format(post_date_gmt, '%m');

As to this year, we’ll see how it goes. I hope at least to keep the frequency reasonably high. And improve both code and table formatting.

2017 in Bitface Blogging