dwyl / dwyl/github-backup

Epic: Define (Ecto) PostgreSQL Database Schema

Open
#15 5 comments 0 reactions 0 assignees View on GitHub
enhancement epic T1h technical
Dominant language
Elixir
Stars
33
Forks
3
PR merge metrics
No merged PRs in 30d

Description

All the "Meta Data" (_anything that is not an issue comment, which is Markdown/"Rich Text"_)
of issues will be stored in a PostgreSQL Database.

With reference to the GitHub API for `users`, `issues` and `comments`,
we need to create the Ecto (Database) Schema for the three DB tables.
We are going to "normalise" the data and let Ecto construct the queries.

+ [ ] Users: https://developer.github.com/v3/users
+ [x] Issues: https://developer.github.com/v3/issues
+ [x] Comments: https://developer.github.com/v3/issues/comments

Our aim is to match the _field names_ in the GitHub API _exactly_
so we keep an _exact_ copy the data that people can _easily_ download
if they want to have a Local Copy. (_don't worry, we aren't building the download feature **yet**!_)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked GitHub API documentation for users, issues, and issue comments, then inspect the repository to find its Ecto schema and migration entry points. Done means defining normalized database tables for all three resources while preserving the GitHub API field names exactly; the checklist shows issues and comments as complete but users still outstanding.

Written by the indexing model from the issue text.

Assessment

Tech stack
elixir, postgresql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.