search

CulturedCheese / thesis-project

4 stars 4 forks source link

DATA-DB: most active github handles for a given language for each country. This is only in the case that they've searched for a language already. #143

Closed ClimbsRocks closed 9 years ago

ClimbsRocks commented 9 years ago

let's create a table just for this.

that table will just be the top 5 developers in each country in each language. so if a country is active in 5 languages, it will have 25 entries in that table, along with each users' username, country, and activeRepoCount.

ClimbsRocks commented 9 years ago

then we'll probably have to go through to add more data to that table, like link to github profile, or avatar url.

then we'll have to merge this table together with the languages table when we're querying for a specific language.

ClimbsRocks commented 9 years ago

Steps to do this:

  1. cool query to get the top 5 by country by language
  2. api calls to update the table with metadata, such as link, and avatar url
  3. create query to join this in with the countries data when hitting the api endpoint.