{"id":853,"date":"2017-01-18T07:43:02","date_gmt":"2017-01-18T06:43:02","guid":{"rendered":"http:\/\/tomaszdziurko.com\/?p=853"},"modified":"2017-01-18T07:43:02","modified_gmt":"2017-01-18T06:43:02","slug":"jvm-bloggers-best-posts-december-2016","status":"publish","type":"post","link":"http:\/\/tomaszdziurko.com\/2017\/01\/jvm-bloggers-best-posts-december-2016\/","title":{"rendered":"JVM Bloggers – best posts in December 2016"},"content":{"rendered":"

Most clicked articles published in December 2016 at JVM Bloggers project.<\/p>\n

Because so far JVM Bloggers<\/a> does not have a feature to list the most popular articles from each month, I have decided to prepare one manually using simple SQL query:<\/p>\n

select bp.title, bp.url, bp.approved_date, c.blog_post_id, count(c.*) as clicks_count \r\nfrom \r\n    click c left join blog_post bp on (c.blog_post_id=bp.id)\r\nwhere \r\n    c.click_date>='2016-12-01 00:00:00' and \r\n    c.click_date<='2017-01-15 23:59:59' \r\ngroup by \r\n    c.blog_post_id, bp.title, bp.url, bp.approved_date \r\norder by\r\n    clicks_count desc;<\/pre>\n
So my approach is to\u00a0count all clicks from given month and the first half of next one\u00a0so posts published at the end of month have two weeks to reach some audience.<\/p>\n
Best content\u00a0in December 2016<\/h2>\n
In December there were five issues (64<\/a>, 65<\/a>, 66<\/a>, 67 <\/a>and 68<\/a>) published with 102 links to articles from Polish programmers and IT companies. Below list of most popular ones.<\/p>\n
Top 10 from personal blogs<\/h3>\n
    \n
  1. 7 grzech\u00f3w rekrutacyjnych ( i co mo\u017cna z nimi zrobi\u0107) – link<\/a><\/li>\n
  2. Why should you care about equals and hashcode – link<\/a><\/li>\n
  3. Code Review Essentials – link<\/a><\/li>\n
  4. Pair Programming Essentials – link<\/a><\/li>\n
  5. Happy New Year 2017!!! – link<\/a><\/li>\n
  6. Single Responsibility Principle Explained – link<\/a><\/li>\n
  7. Wyj\u0105tki w Java: NullPointerException – link<\/a><\/li>\n
  8. The Power of Open\/Closed Principle – link<\/a><\/li>\n
  9. Be elastic. Search. – link<\/a><\/li>\n
  10. 11 obowi\u0105zkowych aplikacji na Androida – link<\/a><\/li>\n<\/ol>\n
    Top 5 from company blogs:<\/h3>\n
      \n
    1. Zaskakuj\u0105ce sytuacje podczas szkole\u0144 – link<\/a><\/li>\n
    2. 5 sposob\u00f3w na lepsz\u0105 komunikacj\u0119 biznesu z programistami – link<\/a><\/li>\n
    3. Reader & Constructor-based Dependency Injection – friend or foe? – link<\/a><\/li>\n
    4. Sonarqube – wprowadzenie do statycznej analizy kodu – link<\/a><\/li>\n
    5. Zwinny networking – link<\/a><\/li>\n<\/ol>\n
      I hope you will find these articles interesting. If you want regular updates with fresh blog posts from Polish blogosphere please\u00a0visit jvm-bloggers.com<\/a> or follow project on Twitter<\/a>\u00a0\/ Facebook<\/a>\u00a0\ud83d\ude42 If you want to help us with building the project you can find us on Slack<\/a>\u00a0and GitHub<\/a>.<\/p>\n
       <\/p>\n
       <\/p>\n
       <\/p>\n
       <\/p>\n","protected":false},"excerpt":{"rendered":"
      Most clicked articles published in December 2016 at JVM Bloggers project.<\/p>\n","protected":false},"author":2,"featured_media":857,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[125],"tags":[34,12],"_links":{"self":[{"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/posts\/853"}],"collection":[{"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/comments?post=853"}],"version-history":[{"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/posts\/853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/media\/857"}],"wp:attachment":[{"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/media?parent=853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/categories?post=853"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tomaszdziurko.com\/wp-json\/wp\/v2\/tags?post=853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}