Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think the GitHub archive project can be of help: <a href="http://www.githubarchive.org/" rel="noreferrer">http://www.githubarchive.org/</a></p> <p>It stores all the public events from the GitHub timeline and exposes them for processing. The events contain info about the repositories, so you should be able to pull the data out of there to fit your use-case.</p> <p>For example, I've just used the following query in the BigQuery console ( <a href="https://bigquery.cloud.google.com/?pli=1" rel="noreferrer">https://bigquery.cloud.google.com/?pli=1</a> ) to find out the number of forks of the joyent/node repository for the date 2012-03-15:</p> <pre><code>SELECT repository_forks, created_at FROM [publicdata:samples.github_timeline] WHERE (repository_url = "https://github.com/joyent/node") AND (created_at CONTAINS "2012-03-15") LIMIT 1 </code></pre> <p>At here are the results:</p> <pre><code>Row forks created_at 1 1579 2012-03-15 07:49:54 </code></pre> <p>Obiously, you would use the BigQuery API to do something similar (extract the data you want, fetch data for a range of dates, etc.).</p> <p>And here is a query for fetching the single largest repository (by forks) for a given date:</p> <pre><code>SELECT repository_forks, repository_url FROM [publicdata:samples.github_timeline] WHERE (created_at CONTAINS "2012-03-15") ORDER BY repository_forks DESC LIMIT 1 </code></pre> <p>Result:</p> <pre><code>Row forks repository_url 1 6341 https://github.com/octocat/Spoon-Knife </code></pre> <p>And here is the query to fetch the top 100 repositories by forks for a given date:</p> <pre><code>SELECT MAX(repository_forks) as forks, repository_url FROM [publicdata:samples.github_timeline] WHERE (created_at CONTAINS "2012-03-15") GROUP BY repository_url ORDER BY forks DESC LIMIT 100 </code></pre> <p>Result:</p> <pre><code>Row forks repository_url 1 6341 https://github.com/octocat/Spoon-Knife 2 4452 https://github.com/twitter/bootstrap 3 3647 https://github.com/mxcl/homebrew 4 2888 https://github.com/rails/rails ... </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to find the 100 largest GitHub repositories for a past date?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIvan Zuzak
    1. USIvan Zuzak
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to find the 100 largest GitHub repositories for a past date?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf you read my comment you can see that I am already aware of githubarchive.org. However, it does not help me much to answer the question.
      singulars
      1. PO
      1. UShistelheim
    2. COSorry about that, it was late :). I extended my answer with an example that will fetch you the number of forks for a specific repo and a specific date. Is this what you want or do you want to fetch the single largest repo on all GitHub for a specific date?
      singulars
      1. PO
      1. USIvan Zuzak
    3. COI just added an example for fetching the single largest repo (by forks) for a given date :).
      singulars
      1. PO
      1. USIvan Zuzak
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload