Importing the JSON into PostgreSQL for better UI/Querying

dwyl / github-backup

:octocat: :back: 🆙 Backup your GitHub Issues so you can still work when (they/you are) offline.

https://github-backup.herokuapp.com

GNU General Public License v2.0

32 stars 3 forks source link

Importing the JSON into PostgreSQL for better UI/Querying #2

Closed nelsonic closed 6 years ago

nelsonic commented 7 years ago

Once we have completed #1 and have "backed up" all GitHub issues for a given User/Organisation as JSON files, we want to import that data into a PostgreSQL database so we can query it!

I see the two tasks as distinct but logically dependent as we cannot do #2 before #1 is working.

Once we have this working, Detect If there is a DATABASE_URL environment variable set and automatically load the data into PostgreSQL when the script is running.

nelsonic commented 6 years ago

Goto: https://github.com/dwyl/github-backup/issues/15 more specific/descriptive issue. 👍