Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo

patrickdevivo/github-mysql.md

Created December 22, 2021 01:56
Show Gist options
  • Save patrickdevivo/9ec4be6e64a1b9f9a1046040b40b2de6 to your computer and use it in GitHub Desktop.
Save patrickdevivo/9ec4be6e64a1b9f9a1046040b40b2de6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
github-mysql.md

Accessing the GitHub API via MySQL

Uses mergestat to access the GitHub API and go-mysql-server.

Currently, only stargazers table is available. GitHub token used is from a "bot" account. Hosted on Fly.

Username: root Password: github

TODO

  • Pass GitHub token via MySQL auth as password
  • More tables?
mysql --host=github-mysql.fly.dev --port=5000 -u root -pgithub "dolthub/go-mysql-server" -e "select login, starred_at from stargazers limit 10"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment