Josh Smith

# Problem Right now when we send query params to the API, we are not filtering/sorting correctly. We'll need to decide if we want to tack another library on, write...

# Problem We introduced #1203 to solve some problems with GitHub's second-level timestamps. We really need to consider whether this is generally enough, or if there are any edge cases...

Error fetching_issue from GitHub API

3

# Problem We had an error earlier fetching an issue with event ID `e99b7a10-cbd6-11e7-9ebc-4752129e3313` at `11/17/2017 12:35:56`. The error data does not get passed along (we only log a `%{}`)...

Github-x model creation should be find or create by

1

# Problem All our `Github-x` model creation should be done as a find or create by using the `github_id`. Right now, the assumption is that this is the first insert...

# Problem Our new sync process revealed some issues caused in our use of `EctoOrdered` when there are a large number of writes. At the kind of scale we need...

Add counter cache to projects for open and closed conversations

2

# Problem When a `conversation` record is created/updated, we need to update the `open_conversations_count` and `closed _conversations_count` counter cache columns on the `projects` table. - [ ] Add `project_id` to...

Do not send emails when hard bounced

1

# Problem If a user's email has hard bounced, we need to ensure that we do not attempt a send to that email.

# Problem When a user has read the conversation, we need to be able to update the conversation's `read_at` time to reflect that: - the conversation has been read -...

# Problem The `User` should have an `unread_conversations` counter cache added to its schema. This should update any time the user has a conversation update and they've not yet read...

# Problem > There are "classes" of webhooks, some of which pertain to the repository and project and other that don't (installation, e.g.). As CC adds more webhook handlers for...