# A year in Discourse - Recap of 2015

**URL:** https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619
**Category:** Blog
**Created:** [2016 年 1 月 28 日午前 8:09 UTC](https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619 "2016-01-28T08:09:31Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [2016 年 1 月 28 日午前 8:09 UTC](https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619/1 "2016-01-28T08:09:31Z")

</div>

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](http://blog.discourse.org/2016/01/a-year-in-discourse-recap-of-2015/)

---

<div class="post-metadata">

### Author: ![erlend\_sh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/erlend_sh/32/119475_2.png) [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)
#### Post date: [2016 年 1 月 28 日午前 11:11 UTC](https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619/2 "2016-01-28T11:11:05Z")

</div>

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!

---

<div class="post-metadata">

### Author: ![mcwumbly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mcwumbly/32/103861_2.png) [@mcwumbly](https://meta.discourse.org/u/mcwumbly)
#### Post date: [2016 年 1 月 28 日午前 11:41 UTC](https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619/3 "2016-01-28T11:41:31Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![DeanMarkTaylor](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/deanmarktaylor/32/102462_2.png) [@DeanMarkTaylor](https://meta.discourse.org/u/DeanMarkTaylor)
#### Post date: [2016 年 1 月 28 日午後 10:12 UTC](https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619/4 "2016-01-28T22:12:57Z")

</div>

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](https://github.com/discourse/discourse/) project.

 ![](https://global.discourse-cdn.com/meta/original/3X/9/e/9e304cd7540ccbcdadb11c918e66f20a8016ca24.png)

 ![](https://global.discourse-cdn.com/meta/original/3X/0/f/0f2ae9498a98e63609dc8e287e9eedeb4c7186ee.png)

```plaintext
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](https://docs.google.com/spreadsheets/d/1BYNJa_Mcg09dFK12ure4Stoi7gIJkx2gVM0-Ft_gG_I/edit?usp=sharing)

---

<div class="post-metadata">

### Author: ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [2016 年 1 月 28 日午後 11:39 UTC](https://meta.discourse.org/t/a-year-in-discourse-recap-of-2015/38619/5 "2016-01-28T23:39:35Z")

</div>

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

> **[Contributors to discourse/discourse](https://github.com/discourse/discourse/graphs/contributors?from=2015-01-01&to=2015-12-31&type=c)**
>
> A platform for community discussion. Free, open, simple. - Contributors to discourse/discourse
