sql

Jan 4, 2018 ∞

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.