Skip to content

Instantly share code, notes, and snippets.

@vjcitn

vjcitn/dohist.R

Created March 11, 2024 11:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vjcitn/eb2e3957b3630ec34258da40402331e9 to your computer and use it in GitHub Desktop.
Save vjcitn/eb2e3957b3630ec34258da40402331e9 to your computer and use it in GitHub Desktop.
Download ZIP
histogram of commit times from an info.csv
Raw
dohist.R
con <- dbConnect(duckdb::duckdb(), read_only=TRUE)
dbExecute(con, "install 'httpfs'")
dbExecute(con, "load 'httpfs'")
library(ggplot2)
devinf = "buildResults/f9785dba87426695825cc6524dcb82c6-info.csv.gz"
pa = sprintf('s3://bioc-builddb-mirror/%s', devinf)
sqlstring = sprintf("FROM read_csv('%s')", pa)
con |>
dplyr::tbl(dplyr::sql(sqlstring)) |> head()
con |> dplyr::tbl(dplyr::sql(sqlstring)) |>
filter(git_last_commit_date > "2023-10-29 14:46:39") |>
ggplot(aes(x=git_last_commit_date)) + geom_histogram(binwidth=86400)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment