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:
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.