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

2 thoughts on “2017 in Bitface Blogging

  1. Talking about Bitface, I’ve recently tried my hand at crypto mining. Your “bitface” is an ideal description of where my little army of GPUs are chipping away, night and day.
    Sad Old Year
    …eh, I meant to say…
    Happy New Year

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.