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

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.