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
Raw

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/