chaoss / chaoss/CollectOSS

Remove columns storing predictable github endpoint URLs

Open
#303 1 comment 0 reactions 1 assignee Claimed by @MoralCode View on GitHub
tech debt
Dominant language
Python
Stars
13
Forks
17
Avg merge
6h 59m
Merged PRs (30d)
1

Description

the `contributors` table contains columns like: `gh_followers_url`, `gh_following_url`, gists, starred, subscriptions, organizations etc.

These URLS are returned by the github API and follow a predictable format.

We dont need to store that predictable surrounding text (i.e. `https://api.github.com/users/`) once for every record in the table. - it just wastes storage when we can compute on the fly if we need to hit these URLs

Some of them may deserve to stay, like `gh_avatar_url`, but we should be removing the vast majority of them.

I am working on a PR that will implement this on the fly recalculation it depends on some other refactoring of URLs though)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.