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…
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!
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