Skip to main content

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:

[sql]
select count(*) from devilgate_posts
where post_status = ‘publish’
and post_type = ‘post’
and post_date_gmt like ’2017%’;
 [/sql]

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:

[sql]
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’);
 [/sql]

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.

Comments