A year in Discourse - Recap of 2015


(Erlend Sogge Heggen) #1

Discourse is a large open source project buzzing with activity, so a lot of cool things happen over the course of a year. Let’s look back at 2015 and pick out some highlights. Our Most Popular Topic of 2015 The most viewed topic of the year was The State of JavaScript on Android in 2015 is…


This topic is for comments on the original blog entry at: A Year in Discourse – Recap of 2015


(Erlend Sogge Heggen) #2

p.s. I would have liked to include some proper GitHub statistics e.g: “unique contributors to Discourse (+ related projects) from Jan 1 2015 to Dec 31 2015” and so forth, but I can’t work out how to get this from the GitHub API.

If someone would like to lend a hand with this, let me know and I’ll be sure make good use of it, starting with our upcoming v1.5 release!


(Dave McClure) #3

I think we should consider doing this with plain ol’ git rather than github.

The script that parses the logs to create release notes might be a good place to start. There might also be prior art out there.


(Dean Taylor) #4

Had a little play with BigQuery, first time I have so you might want to check for errors:

This is just for the github.com/discourse/discourse project.

SELECT
count(*) as count,
type as type,
STRFTIME_UTC_USEC(TIMESTAMP_TO_USEC(created_at), "%Y-%m-%d") as date
FROM (
  TABLE_DATE_RANGE([githubarchive:day.events_], 
    TIMESTAMP('2015-01-01'), 
    TIMESTAMP('2015-12-31')
  )) 
WHERE repo.name = "discourse/discourse"
AND NOT type contains "Comment"
GROUP BY date, type
ORDER BY date, type

I can provide a Google Sheet or CSV perhaps if needed.
Google Sheet here


(cpradio) #5

You can provide a range of dates (see URL parameters)