Skip to content

Latest commit

 

History

History
63 lines (52 loc) · 2.36 KB

README.md

File metadata and controls

63 lines (52 loc) · 2.36 KB

Languish — Programming Language Trends

Links

Features

  • Currently provides data from GitHub and Stack Overflow
  • Measures current activity/velocity rather than total past mass
  • Defaults to a simple "Mean Score" of other percentages
    • I couldn't tell which individual metric was best
    • I don't want a fancy equation that allows me just to get the results I want
  • Can change y axis metric without changing language selections
  • Provides metrics for many languages
  • Links to GitHub topics and trending repos by language
  • Can permalink to Languish configured selections and metric
  • Less than 250 KB (including data) and only 6 HTTP requests
  • Limitation: Works on my phone, but not carefully tailored for mobile

Credits

  • Uses icons from Feather Icons and Font Awesome, via IcoMoon
  • Uses dependencies as specified in the package.json file
  • Please see their respective licenses
  • Previously used data from GitHut 2.0 and still bases some queries and analysis from here

Additional notes

  • Adding a language to GitHub
  • Stack Overflow tag query:
    select
      tags,
      extract(year from creation_date) year,
      extract(quarter from creation_date) quarter,
      count(*) count
    from `bigquery-public-data.stackoverflow.posts_questions`
    group by tags, year, quarter
    order by count(*) desc
  • Also: https://data.stackexchange.com/ (with 50k row limit but updates sooner)
    SELECT
      t.TagName,
      DatePart(quarter, p.LastActivityDate) AS q,
      Year(p.LastActivityDate) AS y, 
      COUNT(p.Id) As NumPosts
    FROM Posts p
    JOIN PostTags pt ON p.Id = pt.PostId
    JOIN Tags t ON t.Id = pt.TagId
    WHERE Year(p.LastActivityDate) = 2022 AND DatePart(quarter, p.LastActivityDate) = 4
    GROUP BY DatePart(quarter, p.LastActivityDate), Year(p.LastActivityDate), t.TagName
    ORDER BY y, q, NumPosts DESC
  • https://subredditstats.com/api/subreddit?name=Python
  • https://wikimedia.org/api/rest_v1/