#dump #io #crates-io #download #scripting #time-series #tar

db-dump

Library for scripting analyses against crates.io's database dumps

32 releases

new 0.7.0 Apr 14, 2024
0.6.0 Mar 9, 2024
0.5.2 Mar 7, 2024
0.4.10 Oct 18, 2023
0.1.0 Mar 16, 2021

#149 in Database interfaces

Download history 138/week @ 2023-12-22 174/week @ 2023-12-29 120/week @ 2024-01-05 114/week @ 2024-01-12 88/week @ 2024-01-19 94/week @ 2024-01-26 118/week @ 2024-02-02 159/week @ 2024-02-09 480/week @ 2024-02-16 266/week @ 2024-02-23 298/week @ 2024-03-01 421/week @ 2024-03-08 149/week @ 2024-03-15 172/week @ 2024-03-22 162/week @ 2024-03-29 113/week @ 2024-04-05

619 downloads per month
Used in cargo-tally

MIT/Apache

195KB
1.5K SLoC

crates.io database dumps

github crates.io docs.rs build status

Library for scripting analyses against crates.io's database dumps.

These database dumps contain all information exposed by the crates.io API packaged into a single download. An updated dump is published every 24 hours. The latest dump is available at https://static.crates.io/db-dump.tar.gz.


Examples

The examples/ directory of this repo contains several runnable example analyses.

total‑downloads Computes time series of total downloads by day across all crates on crates.io
crate‑downloads Computes time series of downloads of one specific crate
top‑crates Computes the top few most directly depended upon crates
user‑dependencies Computes the percentage of crates.io which depends directly on at least one crate by the specified user
user‑downloads Computes time series of the fraction of crates.io downloads attributed to a single given user's crates

Each of these examples can be run using Cargo once you've downloaded a recent database dump:

$ wget https://static.crates.io/db-dump.tar.gz
$ cargo run --release --example total-downloads

Here is the implementation of the most basic example, total-downloads, and graph of the resulting table. It shows crates.io download rate doubling every 9 months, or equivalently 10× every 2.5 years!

use chrono::Utc;
use db_dump::Date;
use std::collections::BTreeMap as Map;

fn main() -> db_dump::Result<()> {
    let mut downloads = Map::<Date<Utc>, u64>::new();
    db_dump::Loader::new()
        .version_downloads(|row| {
            *downloads.entry(row.date).or_default() += row.downloads;
        })
        .load("./db-dump.tar.gz")?;

    for (date, count) in downloads {
        println!("{},{}", date, count);
    }

    Ok(())
}
Crates.io downloads per day (log scale)

Here is a graph from the user-downloads example:

Fraction of crates.io downloads that are dtolnay's crates

License

Licensed under either of Apache License, Version 2.0 or MIT license at your option.
Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in this crate by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.

Dependencies

~6–18MB
~213K SLoC