search

dotnet / nuget-trends

Check out NuGet packages adoption and what's trending on NuGet.
https://nugettrends.com
MIT License
146 stars 25 forks source link

Add graph for daily downloads #89

Open bruno-garcia opened 4 years ago

bruno-garcia commented 4 years ago

Currently we only have a ever growing graph. The feature request is to add a second graph that will show the number of downloads for a time period.

Matthias' request: https://twitter.com/matkoch87/status/1225797785313796099

michael-hawker commented 3 years ago

My SQL is rusty, it seems like this is where the data is grabbed from the DB:

https://github.com/dotnet/nuget-trends/blob/4209af5347ad91d1171479df53f624caa634bb79/src/NuGetTrends.Data/NuGetTrendsContextExtensions.cs#L20-L33

Does the DB have the raw download data per day or is it stored in aggregate form already?

joaopgrassi commented 3 years ago

@michael-hawker the data is stored per day, in the daily_downloads table. We do it by hitting the NuGet API daily for all stored packages we have.