John McBride

Chore: Evaluate workspace pull request query for performance

1

We've seen the query for pull requests for repos within a workspace. Note from @nickytonline, he was getting 599 PRs from a workspace with 154 repos in it.

> > Would it be worth benchmarking some queries to track this? > Yes. This is what we'd want to use Grafana K6 for: performance testing of our RESTful API...

## Description This is a proof of concept, skunkworks project to show how we might offer a high level, enterprise offering with direct access to our timescale / time series...

The PR `time_bucket` query to timescale is not performant: this is a screenshot from some insights on timescale we can see and the medium time is way too slow. Which...

Feature: remove usage of logging middleware connection in favor of a system log sink to 3rd party logging service

1

### Type of feature ⛵ Chore / Feature / Refactor ### Current behavior We currently utalize Nest's [middleware](https://docs.nestjs.com/middleware) to implement a logger that sends all API logs to a postgres...

We will be removing deprecated routes related to: - https://github.com/open-sauced/api/issues/641 So, existing v2 routes will become v3 routes. For example: ``` GET v2/auth/session ``` will become ``` GET v3/auth/session ```...

Feature: Most active contrbutors for individal repos

1

### Type of feature 🍕 Feature ### Current behavior Similar to: https://github.com/open-sauced/api/issues/625 --- Currently, there's no way to discover "most active contributors" for a single given repo. You'd have to...

Chore: refactor membership deleting so users can leave workspaces on their own

3

This ticket is two fold: currently, a workspace member cannot leave on their own volition. An owner must remove them: https://github.com/open-sauced/api/blob/edd1a379e4d307c1df9f74cc1e7ed247e5e0d8cf/src/workspace/workspace-members.service.ts#L233-L241 This was also in service of not letting there...

### Type of feature 🍕 Feature ### Current behavior We currently aren't incorporating `orderBy` into the DTO for the `v2` PR endpoints: https://github.com/open-sauced/api/blob/956989b202ea830376d92ff5a695e06dc118d641/src/pull-requests/dtos/pull-request-page-options.dto.ts#L20-L27 ### Suggested solution Utilize this as it...

Feature: iterate and improve activity ratio

2

### Type of feature 🍕 Feature ### Current behavior Followup to https://github.com/open-sauced/api/pull/523 --- Currently, activity ratios are calculated from a huge subset of the top 1000 starred repos on GitHub....